>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement