>>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.
Thanks...we found the problem...my user setup was incorrect and I was not getting logged onto the NT server correctly. (We have Novell and NT). I could see the server volumes but could not write data. I changed my setup and things went okay. Apparently this was a difference between 95 and NT, since it had worked in 95. the command x=sqlconnect() returns a 1 for x if it was successful or a 0 if it wasn't. We just use it to see if we can actually make a connection.
I really do appreciate your help.
Previous
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