By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

ADO Connection Pooling Using CPP.

P: n/a
Hi ,

i want to manage connection pooling using C++ code, below is the code i
am using so can any body tell me if this code is correct or not ? if
not plz send me a snap shot !!!
if the code is correct i am having some queries:
1) my connection string is correct or not ? In my code it
is not throwing any exception & working properly
2) in connection string i am using pooling = true/false
but it is not creating new connection. i hope it is using pooling
concept implicitly but in false case it has to create a new conection
each iteration.
3) m_pConnection->Close(); is not loosing the connection
i am seeing in the Perfmon.msc ->(SQL Server:General Statistics,User
Connections) but it is not loosing the connection(graph is not
falling).

I was very confused to Debug and analyze according to theory concepts
so plz some body help.
int main()
{
CoInitialize(NULL);
_ConnectionPtr m_pConnection;
_ConnectionPtr rasheed;
m_pConnection.CreateInstance(__uuidof(Connection)) ;
for(int i = 0; i < 100; i++)
{
try
{
//Connection String and Connection
Creation........
m_pConnection->Open("Provider='SQLOLEDB';
Persist Security
Info=False;UserID=sa;Password=sa;
Data Source=(local);Initial
Catalog='databasename';Integrated
Security='SSPI';Min Pool
Size=0;Max Pool Size=10;OLE DB Services= -
1; pooling = true","","",
adConnectUnspecified );

//Connection Close........
m_pConnection->Close();
}//End of Try block

catch(_com_error & conn)
{

printf("%s",conn.ErrorMessage);
}//End of Catch block
}//End of loop

CoUninitialize();
return 0;
}

Sincerly,
Rasheed

Dec 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<sk**************@gmail.comwrote in message
news:11**********************@80g2000cwy.googlegro ups.com...
Hi ,

i want to manage connection pooling using C++ code, below is the code i
am using so can any body tell me if this code is correct or not ? if
not plz send me a snap shot !!!
You'll need to ask in a newsgroup related to ADO, databases, or the like.
There is nothing in the C++ language (which is what we discuss here) which
directly supports database connections. You might try a Google search to
see what groups have responded to ADO questions in the past.

-Howard
Dec 8 '06 #2

P: n/a
Thanks Howard,

U saved my valuable time............by suggesting good group.....
Howard wrote:
<sk**************@gmail.comwrote in message
news:11**********************@80g2000cwy.googlegro ups.com...
Hi ,

i want to manage connection pooling using C++ code, below is the code i
am using so can any body tell me if this code is correct or not ? if
not plz send me a snap shot !!!

You'll need to ask in a newsgroup related to ADO, databases, or the like.
There is nothing in the C++ language (which is what we discuss here) which
directly supports database connections. You might try a Google search to
see what groups have responded to ADO questions in the past.

-Howard
Dec 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.