Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL connect error?
Message
From
25/06/1998 18:07:49
Bob Lucas
The WordWare Agency
Alberta, Canada
 
 
To
25/06/1998 17:01:24
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00111725
Message ID:
00111749
Views:
13
>I've got a machine that I just set up with NT 4.0. I just installed VFP 5.0. When I try to connect to the sql server, I get an error '01000'. It is failing while attempting to open the connection. I am testing this by typing 'x=sqlconnect()' which usually works. I can see the server data source in the dialog box...the error comes after it tries to connect.
>The ODBC control settings seem to be the same as another NT box we have nearby....am I missing something simple?

Sqlconnect won't work without parameters. You need to pass the ODBC datasource, userid and password.

If you don't connect, use AERRORS() to determine the exact ODBC error. Usually in the 2nd and/or 3rd element. Sometimes there are two rows.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform