Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check a SQL Server ODBC connection silently?
Message
From
30/03/2000 09:24:13
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00352660
Message ID:
00352688
Views:
11
Mark,

Having told me this, I figure there must be a setup option to turn off/on which was not obvious when I looked before. It is the SQLSETPROP option for DispLogin. Thanks, I appreciate the shove in the right direction.

Regards,
-Isaac

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform