Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Turn ODBC connection pooling ON automatically
Message
 
 
To
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:
01356006
Views:
25
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform