Computing.Net > Forums > Database > DataSource change when not in admin

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

DataSource change when not in admin

Reply to Message Icon

Name: tzuhsun
Date: April 3, 2006 at 21:21:31 Pacific
OS: Windows 2000 Pro SP4
CPU/Ram: P4 2.4
Product: Dell
Comment:

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.



Sponsored Link
Ads by Google

Response Number 1
Name: jhunt303
Date: April 4, 2006 at 02:35:53 Pacific
Reply:

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


0

Response Number 2
Name: tzuhsun
Date: April 4, 2006 at 19:53:33 Pacific
Reply:

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.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: DataSource change when not in admin

MSSQL 2005 change scale in column www.computing.net/answers/dbase/mssql-2005-change-scale-in-column/388.html

Need help with Database in Access 2003 www.computing.net/answers/dbase/need-help-with-database-in-access-2003/669.html

Script to check database status www.computing.net/answers/dbase/script-to-check-database-status-/393.html