Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Domain changed

Author  Topic 

amber
Starting Member

7 Posts

Posted - 2010-09-28 : 13:06:50
Hello,
Due to the purchase of our company, we had to change our domain name.
I have a server running SQL Server 2000.
Enterprise Manager is v8.
I have the SQL database back up and running, and can view tables etc.
One of the databases is setup for users to access via a MS Access front end, with linked tables.

I have the system DSN set up in the ODBC data source administrator, and when I test the connection, it is successful.

But when I'm in the database front end, and try to open a form that's based on one of these SQL tables, I get an ODBC--connection 'mySql DBS' failed.
I can't figure out how to fix this...

Any help would be greatly appreciated!!
Amber


   

- Advertisement -