Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timeout for SQLStringConnect()
Message
De
19/03/2003 14:24:10
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00767717
Message ID:
00767752
Vues:
10
>No, I don't. Is your aplication using TCP/IP to communicate witrh Sql Server? You can add "Network=DBMSSOCN" to connection string to make sure that it does.

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.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform