Yes,ive added.q<br><br><div class="gmail_quote">On Wed, Sep 30, 2009 at 4:51 PM, J Jayavasanthan <span dir="ltr"><<a href="mailto:jayavasanthan@gmail.com">jayavasanthan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>Hi,</div><div><br></div>You should also set the connection pooling attribute for your environment, I believe you have already done this,<div><br></div><div><div><span style="white-space:pre"> </span>SQLSetEnvAttr(henv_,</div>
<div><span style="white-space:pre"> </span>SQL_ATTR_CONNECTION_POOLING,</div><div><span style="white-space:pre"> </span>(SQLPOINTER)SQL_CP_ONE_PER_HENV,</div><div><span style="white-space:pre"> </span>SQL_IS_UINTEGER);</div>
<div>(or)</div><div>SQL_CP_ONE_PER_DRIVER</div><div><br></div><div>Regards,</div><div>Jay</div><div class="im"><br><div class="gmail_quote">On Wed, Sep 30, 2009 at 1:00 PM, w.h <span dir="ltr"><<a href="mailto:win.acc@gmail.com" target="_blank">win.acc@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks for you repaly ,how can i know or decice my entry points is unicode or ansi ?<div><div><br>
<br><div class="gmail_quote">On Wed, Sep 30, 2009 at 3:06 PM, Nick Gorham <span dir="ltr"><<a href="mailto:nick@lurcher.org" target="_blank">nick@lurcher.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>w.h wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I checked my source code my app is single process.<br>
Any more this is my odbc.ini is:<br>
[ODBC]<br>
Trace = Yes<br>
Trace File = /tmp/sql.log<br>
Pooling = Yes<br>
<br>
</blockquote></div>
That all looks right, it may be a problem due to that driver only seeming to use the unicode entry points, the pooling code (I will have to check) makes use of the ansi entry points at the moment,<div><div><br>
<br>
-- <br>
Nick<br>
_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><div><div>-- <br>All you best !<br>-----------------------------------------------<br> w.h<br><br>
</div></div><br>_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br></div>first me then home<br>first home then country<br>first country then world<br>fools always read inverse<br>
</div>
<br>_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>All you best !<br>-----------------------------------------------<br> w.h<br><br>