DevForce Community Forum : Dynamic Connections http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Dynamic Connections Wed, 15 Apr 2026 00:35:51 -700 Thu, 05 Jul 2007 08:06:10 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=106 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Dynamic Connections : I believe what you want is a DataSourceKeyResolver.... http://www.ideablade.com/forum/forum_posts.asp?TID=106&PID=235#235 Author: jeffdoolittle
Subject: 106
Posted: 05-Jul-2007 at 8:06am

I believe what you want is a DataSourceKeyResolver.  You could have two DataSourceKeys in your ibconfig file, called something like "default_primary" and "default_secondary".  In the Resolver code, you could check for availability of the primary server and use the secondary one in case of an outage.  In the event of a disconnect once you've instantiated your PM, you could also switch over to the other DataSourceKey and therefore the other server.
 
Off the top of my head, I'm not sure whether you can change the DataSourceKey of an instantiated PM, or whether you'd have to start a new one and then copy all your existing changes over. 
]]> Thu, 05 Jul 2007 08:06:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=106&PID=235#235 Dynamic Connections : I want to provide the capability... http://www.ideablade.com/forum/forum_posts.asp?TID=106&PID=233#233 Author: rclarke
Subject: 106
Posted: 05-Jul-2007 at 6:52am

I want to provide the capability to connect to a different instance of SQL in the event the primary instance is down. This will not be using BOS. In this case there will be a primary server that is normally used. At the end of using the application, a backup (or mirror copy) is made to a backup server or even to the local computer. Upon application start I want to connect first to the primary and if problems exist, prompt the usrer for an alternate SQL Server instance. I know how to get the list of available SQL Server instances but it is not clear to me how to dynamically change the connection string for PM.
 
Thanks in advance,
 
Ron Clarke
]]> Thu, 05 Jul 2007 06:52:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=106&PID=233#233