[ODBC]
DRIVER=SQL SERVER [or whatever! this is an old driver, btw -- still works but is slow]
UID=MyUserID
DATABASE=MyDatabaseName
SERVER=MyServerName
PASSWORD=MyPassword
Once you have a DSN file, you can use it to link to tables in that database from Access.SQL Server Native Client 10.0
maybe I was wrong about the generic form always working -- or maybe something is not right in other parameters. Eliminate extra spaces in your DSN file. Make sure it is stored as ASCII.can you open what you are trying to connect to?Sure.
you will always get the 64 bit version if your using a 32 bit OS, otherwise you get the 32 bit version.Is this a typo or why is that so, for 32 I get 64 and vice versa?
Only by the drivers available and the DSN's it creates can you tell what your working with.Can you tell from the attached list of drivers which version do I have?
That pic looks like the 64-bit driversAre you referring to your pics or mine?
you will always get the 64 bit version if your using a 32 bit OS, otherwise you get the 32 bit version.
Is this a typo or why is that so, for 32 I get 64 and vice versa?
So being that on the PC in question have OS Win7 Pro 64, means the ODBC tools is 32 bit, and my office version is 32 (thanks to the link you posted...-:), why did I had to create a dsn using 64 version?
My bet is that you've created a 64-bit dsn, and the Access you're running is 32-bit.
Which version of windows are you creating this on? Then I'll try to find the different odbc managers for you. They vary by windows version.
HTH
David