Connecting to MS Sql Server 2005 with ODBC
Hi there,
I have just made a switch from sql server 2000 to sql server 2005 - that went without major problems...
My server is located in Denmark.
We have an office located in the US which are also connecting to our server - that goes without problems except for one machine connecting through ODBC directly (the others use remote desktop).
The machine also connected through ODBC when I was using the old server - and there never seemed to be any problems.
At first I could not see the machine by name, but I could ping it by ip-number.
I added it to the hosts file - and now I can ping it by name as well.
My problem is this:
- When I try to correct the ODBC settings I do not get my new aerver on the sql-server list.
Do I need some sort of software? MDAC or so? to update the drivers on the local machine in the US, so that they can see the server as well?
I am to call up these guys today at 16.00 (danish time) - 6 hours from now - so any ideas on how to get this fixed would be nice.
Thank you in advance.
Martin
