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:26:31
 
 
To
30/03/2000 09:24:13
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00352660
Message ID:
00352690
Views:
11
BTW, I also meant to say that it can be set via tools--options--remote data--show login (set to never).

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

Click here to load this message in the networking platform