Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Turn ODBC connection pooling ON automatically
Message
 
 
À
21/10/2008 06:11:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01355129
Message ID:
01356006
Vues:
24
See SQLSMO for SQL server 2005 Message #1162881 or http://news2news.com/vfp/?group=-1&function=447. Just plug your values

>
>Thank you. I understand from this and from http://support.microsoft.com/kb/169470
>than only way to turn pool on is to use code
>
>
	Private Declare Function SQLSetEnvAttr Lib "odbc32.dll" (ByVal henv As
>	Any, ByVal Attr As Long, ByVal ValPtr As Any, ByVal StrLen As Long) As
>	Long
>	Private Const SQL_ATTR_CONNECTION_POOLING As Long = 201
>	Private Const SQL_CP_OFF As Long = 0
>	Private Const SQL_CP_ONE_PER_DRIVER As Long = 1
>	Private Const SQL_CP_ONE_PER_HENV As Long = 2
>	 
>	Dim ReturnCode As Long
>	ReturnCode = SQLSetEnvAttr(vbNullString, SQL_ATTR_CONNECTION_POOLING,SQL_CP_ONE_PER_DRIVER, 0)
>
>
>How to convert this code to VFP ?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform