Failure to access SQL 2000 db via ODBC
Posted on 2003-03-10
I have a network where three Citrix metaframe servers host executables which access a SQL server 2000 database via ODBC DSN, the SQL 2000 client drivers are on the Citrix servers. Two of the Citrix boxes have no problem but the other will only let the network administrator access the db. Other attempts to utilze the ODBC DSN by ACCESS also meet with failure. When ordinary user tries the link they get the following error displayed:
SQL State: '01000'
SQL Server Error 2
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL State: '08001'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
Testing the DSN succeeds, but using it fails. The registry is allowing Everyone to fully control the ODBC DSN in question and a regmon trace of the ODBC DSN access show it as successful... Any ideas.