Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timeout for SQLStringConnect()
Message
 
 
To
19/03/2003 14:24:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00767717
Message ID:
00767777
Views:
11
>
>I added it but not sure if it changes anything. The timeout usually takes about 7 seconds. To simulate it, I entered a bad server value such as:
>
>
>lnHandle=SQLStringConnect('Driver=SQL server;Server=BadPC; Database=Universal Thread; '+;
> 'Network=DBMSSOCN;')
>
>
>So, this server doesn't exist. Maybe when the server doesn't exist, it checks for additional things before the timeout get effective. That would mean, it takes about 5 additional seconds at first to check for something else and then the 2 seconds will apply.

It takes 2.3 sec to timeout on my PC with ConnectTimeOut set to 1 sec and none-existing server in the connection string. Mabe it's your's DNS lookup gives such delay?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform