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