Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check a SQL Server ODBC connection silently?
Message
 
 
To
30/03/2000 08:44:50
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00352660
Message ID:
00352672
Views:
7
Using SQLStringConnect() or SQLConnect() has not returned any popup message for me when I use it. My examples are:

lnHandle = sqlconnect('DSN=SDWIS/Fed;UID=xmx;PWD=wrong;SERVER=sdwisfed;')
lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=reg6;UID=npdes;PWD=wrong;')

Both returned -1 with no messagebox. Both returned a valid connection when I used the correct password.

>I need to confirm the userid/password of an odbc connection.
>I know one way to test an odbc connection is to use SQLCONNECT(). However, if you pass in the wrong userid/password you not only get the -1 return which I want, but you also get a popup error message. I don't want the popup. Does anyone know how to turn this off or another way to test the odbc conncection silently?
>
>Thanks,
>-Isaac
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform