>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only