Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlStringConnect()
Message
 
 
To
06/03/2001 12:18:29
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00482290
Message ID:
00482354
Views:
8
>Marc,
>Try:
>
>SQLSetProp(0, 'DispLogin', 3)      && prevent ODBC login dialog if we cannot connect
>SQLSetProp(0, 'DispWarnings', .f.) && prevent ODBC error messages
>
>HTH
>>In my application, I use the command SqlStringConnect() to access
>>a SQL Server database. However, when the connection failed, I get
>>a window to enter UserId and Password. Is it possible to NOT display
>>that window?

FYI, DispWarnings only has an effect on the information returned in AError. If it is set to .T. and warnings occur on SQL Server along with at least one error (i.e. severity level 11+) then the warnings will also be returned with AError(). If set to .F., only the error will be returned.

If warnings occur with no error, then nothing will be returned by AError() no matter what it is set to.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform