Connection failed: ODBC error

[cjackson]

Hello everyone, I hope someone can help me with this as it is making me loose what little hair I have left:

I have recently changed IP addresses on the SQL 7 server and all the clients.

Since doing so I can not connect via Access to the tables, I get the following errors:

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
Connection failed:
SQLState: '08001'
SQl Server Error: 11

These connections test OK in ODBC Administrator

If I create a new database I can connect to the tables OK

Any idea's would be greatly appreciated.

Cheers

Chris

 

[eradtke]

Have you deleted the tables and "Re-Link" them?

If new DB's work just fine with that DSN then that should do it.

 

[cjackson]

Yes this does work fine, but I have loads to change, anyone know a quick way of doing this?

Cheers

Chris