[dba-SQLServer]SWAP DBs

Will do. I know the three databases that may be used. One is  alive
database, other two are test copies.

Martin


----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Wednesday, November 26, 2003 1:23 PM
Subject: RE: [dba-SQLServer]SWAP DBs


> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>