Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I check a SQL Server ODBC connection silently?
Message
De
30/03/2000 09:26:31
 
 
À
30/03/2000 09:24:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00352660
Message ID:
00352690
Vues:
12
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform