Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Turn ODBC connection pooling ON automatically
Message
From
21/10/2008 06:11:47
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01355129
Message ID:
01356004
Views:
33
>Check http://www.15seconds.com/issue/970531.htm

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 ?
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform