Hi
pls read this article from MS and its links to help yu.
good luck
Mohamed
ftp://ftp.microsoft.com/developr/fox/kb/q169/4/70.txt
part of the article...
" Q. How do I enable connection pooling if the application is written in VisualBasic?
A. A Visual Basic or ODBC application can call the SQLSetEnvAttr function to
enable connection pooling. Connection pooling is a process-level attribute,
so any subsequent connection made through the ODBC driver manager in the
Visual Basic application will use connection pooling. A Visual Basic
application can use the function declaration and code to enable connection
pooling.
Declare Function SQLSetEnvAttr Lib "odbc32.dll" (ByVal henv As Long, ByVal Attribute As Long, ByVal Value As Long, ByVal StringLength As
Long) As Integer ' env attribute
Public Const SQL_ATTR_CONNECTION_POOLING = 201
Public Const SQL_ATTR_CP_MATCH = 202
' values for SQL_ATTR_CONNECTION_POOLING
Public Const SQL_CP_ONE_PER_DRIVER = 1
Public Const SQL_IS_UINTEGER = -5
nstatus = SQLSetEnvAttr(0, SQL_ATTR_CONNECTION_POOLING,
SQL_CP_ONE_PER_DRIVER, SQL_IS_UINTEGER) SQLAllocEnv...
SQLAllocConnect... SQLConnect... SQLDisConnect...
SQLFreeConnect... SQLFreeEnv...
"
more info ....
HOWTO: Enable ODBC Connection Pooling in VB ADO Application
ftp://ftp.microsoft.com/developr/fox/kb/q237/8/44.txt
Q228843 HOWTO: Implement Session Pooling from Visual Basic ADO Program
ftp://ftp.microsoft.com/developr/fox/kb/q228/8/43.txt