[dba-SQLServer]SWAP DBs

Arthur Fuller artful at rogers.com
Wed Nov 26 15:23:26 CST 2003


Is this a general question, or do you know the list of possible
connections in advance? If the latter, just create a specific connection
to each, then examine the strings. You can write a SELECT CASE block to
deal with them in a few seconds. If the former, create a couple of
connections to various alternatives and examine the connection strings.
It's not difficult to parse them. Look for semi-colons and keywords. You
might want to write the results into a table to eliminate future parsing
of the string (i.e. every time the user "creates" a new connection, you
parse it, write its pieces to the table and thereafter use that).

Hth,
Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Reid
Sent: Tuesday, November 25, 2003 10:21 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer]SWAP DBs


I need to be able to swap into different databases from Access.

Anyone have an example of swapping the connection to point to another
SQL Server DB


Martin

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list