ODBC system DSN Issue

Hi,
I have a problem with SQL 2005, ODBC Connection,
I did create a ODBC conection with user DSN to a SQL 2005 database, and
there is a 3rd party aplication that we use to access that SQL database ever
y
thing went fine.
I did create ODBC connection with System DSN to the same Database but when
I try to open the database with our 3rd party application I get this error:
The datasource you specified does not exist.
Any idea why I can access the same database on the same SQL server with user
DSN and not with System DSN?
We are useing Windows 2003R2 (64 bit) and SQL 2005 (64 bit).
Thanks,
Shahin.ODBC on an x64 based OS has 2 sets of system DSN settings stored in the
registry.
If you run: %SystemRoot%\SysWOW64\odbcad32.exe you modify the 32bit
settings.
If you run: %SystemRoot%\system32\odbcad32.exe you modify the 64bit
settings.
32bit client applications use the 32bit settings, 64bit apps use the 64bit
settings.
So, first check which system DSN settings you set (32 or 64bit), then check
the 3rd party app to see if it's 32 or 64bit.
cmk|||Hi Chris,
Thanks for info it was very helpful and it did solve my problem
"Chris Kushnir" wrote:

> ODBC on an x64 based OS has 2 sets of system DSN settings stored in the
> registry.
> If you run: %SystemRoot%\SysWOW64\odbcad32.exe you modify the 32bit
> settings.
> If you run: %SystemRoot%\system32\odbcad32.exe you modify the 64bit
> settings.
> 32bit client applications use the 32bit settings, 64bit apps use the 64bit
> settings.
> So, first check which system DSN settings you set (32 or 64bit), then chec
k
> the 3rd party app to see if it's 32 or 64bit.
>
> cmk
>
>