DataSource change when not in admin
|
Original Message
|
Name: tzuhsun
Date: April 3, 2006 at 21:21:31 Pacific
Subject: DataSource change when not in adminOS: Windows 2000 Pro SP4CPU/Ram: P4 2.4Model/Manufacturer: 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.
Report Offensive Message For Removal
|
|
Response Number 2
|
Name: tzuhsun
Date: April 4, 2006 at 19:53:33 Pacific
Subject: DataSource change when not in admin |
Reply: (edit)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.
Report Offensive Follow Up For Removal
|
Use following form to reply to current message: