Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoid the SQL server ODBC screen if no connection?
Message
From
20/12/2001 05:30:43
 
 
To
20/12/2001 04:49:21
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00596604
Message ID:
00596627
Views:
18
Peter,
Try:
SQLSETPROP(0, 'DispLogin', 3)      && prevent ODBC login dialog if we cannot connect
SQLSETPROP(0, 'DispWarnings', .f.) && prevent ODBC error messages
HTH
>If a lnHandle=SQLCONNECT("SomeDB") fails, the SQL Server ODBC driver pops up a nice little screen, giving the ability to retry.
>
>Very cute, but in a huge installation with 100+ servers running some VFP-program unattended, this is not very practical, because the program in effect stops, and nobody'll notice it.
>
>I'd like to handle this situation by simply writing the errror info obtained with AERROR() into the event log and gracefully exit the application.
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform