Question Locked

ODBC problem in Terminal Server on Windows 2003

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have develop a VB apps with a MS-Access back-end.

It run perfectly on Windows 2000 Terminal Server but i am experiencing problem in Windows 2003 Terminal Server.

When I am log as Administrator it work perfectly.

As soon as I am connected as Normal user I get this error message.

Run-time error'-2147220992 (80040200)':
[Microsoft][ODBC Driver Manager] Data source name too long.

5 replies

by rkuhn040172

Check and see if the DSN was setup under the User or System.

Control Panel, Administrative Tools, Data Sources (ODBC).

by lewis_1968

Hi,

Thanks for your help.

I do not use DSN as it is hardcoded in the db using the apppath method.

EXE and MDB in same folder.

In the VB6 coding I am using msjet4.0 to connect to the mdb to run the sql command.

I find it weird that it's all working in admin mode but not when non admin. And also working perfectly under Windows 2000 Terminal Server.

Your help is much appreciated.

Any suggestions ?

by sadsam422

I used DSN, check both User/System DSN setup..

as long as user take out from local admin group.. failed to load..

any suggestion

This discussion is closed to new replies.