Hi all,
Recently I try some script from microsoft which need to connect to SQL Server 2000 (SP4) database using ODBC, but my PC keep on show me datasource not found.

This problem only occur when I login PC using ordinary user account. If I login using admin account everything will work fine.

For example:
Datasource=MY_PC
User Acccount: XXX

So the script will pop me something like this:
"Datasource not found: MY_PC\XXX" but actually I coded "Datasource=MY_PC" in my test script.

The error above would not happen if run under admin account.

Hope someone can advise on this weird thing.
Thanks.

Make sure it is a 'system DSN' and not 'User DSN' ODBC connection

Hi jhunt303, I quite sure I put the ODBC in system DSN already.

One more thing is the data source name I use is same name with local PC name.

When I tested it with another data source name (still connect to same database), the error msg pop again, but this time different:
"[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied."
Error Code: 80004005
Source: Microsoft OLE DB Provider for SQL Server.

Could it cause by user rights?

Help pls, thanks.