C
Chefjay22
Hello there. I am working on a project where we have all our back office SQL
servers moving and changing names. We unfortunately have many MS Access 2000
DB's that link to global SQL tables that we need to update. Our issues is
this, the SQL server may have many databases on it, and for some reason when
we go to the properties on the link table we are unable to see the database
name on some of our links.
Here is an example of one where we see the DB name indicated in the ODBC
connection string:
ODBC;DRIVER=SQL Server;SERVER=SERVERXXX;UID=JohnDoe;APP=Microsoft(R) Windows
NT(TM) Operating
System;WSID=6943CKP5K021;DATABASE=Reports;Network=DBMSSOCN;TABLE=dbo.testtable
Notice it days "DATABASE=Reports;"
Some of our links look like this:
ODBC;DRIVER=SQL Server;SERVER=SERVERXXX;UID=JohnDoe;APP=Microsoft Open
Database
Connectivity;WSID=TDAN-DEV;Network=DBMSSOCN;Address=test.sd.com,1433;TABLE=dbo.testtable
Notice there is no referrence to the DATABASE. Does anyone know how we could
view this information, or if this is happening because perhaps it is
connecting to the Default DB on the server or something. Any help would be
awesome! Thanks.
Jason
servers moving and changing names. We unfortunately have many MS Access 2000
DB's that link to global SQL tables that we need to update. Our issues is
this, the SQL server may have many databases on it, and for some reason when
we go to the properties on the link table we are unable to see the database
name on some of our links.
Here is an example of one where we see the DB name indicated in the ODBC
connection string:
ODBC;DRIVER=SQL Server;SERVER=SERVERXXX;UID=JohnDoe;APP=Microsoft(R) Windows
NT(TM) Operating
System;WSID=6943CKP5K021;DATABASE=Reports;Network=DBMSSOCN;TABLE=dbo.testtable
Notice it days "DATABASE=Reports;"
Some of our links look like this:
ODBC;DRIVER=SQL Server;SERVER=SERVERXXX;UID=JohnDoe;APP=Microsoft Open
Database
Connectivity;WSID=TDAN-DEV;Network=DBMSSOCN;Address=test.sd.com,1433;TABLE=dbo.testtable
Notice there is no referrence to the DATABASE. Does anyone know how we could
view this information, or if this is happening because perhaps it is
connecting to the Default DB on the server or something. Any help would be
awesome! Thanks.
Jason