Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbconnect (fpsql) problem
Message
From
02/04/2003 14:23:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Title:
Dbconnect (fpsql) problem
Miscellaneous
Thread ID:
00773153
Message ID:
00773153
Views:
57
Hello,
Im trying to access a SQL Server 2000 from FP2.6 via fpsql.dll

It works ok on a Win XP machine, but fails on W98.

The dbconnect() call returns with code -2

The error message is
ODBC error IM002 [microsoft][odbc dll] Data source name not found and no default driver specified.

The syntax I use is

store dbconnect(mydsn,myuser,mypwd) to nConn.
Also tried
store dbconnect(mydsn,myuser,mypwd,mydatabase) to nConn

It returns -2 in nConn on W98 SE, MDAC 2.6 SP1.
mydsn exists and works ok

Any ideas?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform