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!!
View Complete Post