dbTalk Databases Forums  

SQLSetConnectOption() fails under stressfor {SQL Native Client} dr

microsoft.public.sqlserver.odbc microsoft.public.sqlserver.odbc


Discuss SQLSetConnectOption() fails under stressfor {SQL Native Client} dr in the microsoft.public.sqlserver.odbc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ghanashyam
 
Posts: n/a

Default SQLSetConnectOption() fails under stressfor {SQL Native Client} dr - 06-01-2010 , 02:43 AM






My application server is using {SQL Server} driver (sqlsrv32) for several
years and I am doing compatibity testing with {SQL Native Client} driver
(sqlncli) .

So the existing code and call to ODBC API works fine when I connect using
driver (sqlncli). However in stress condition (Many users/threads connecting)
the call to SQLSetConnectOption() API returns SQL_ERROR .And to obtain
SQL_STATE and exetended error information SQLError() returns
SQL_NO_DATA_FOUND.

However this issue never happens with driver (sqlsrv32).Any input in this
regard will be of great help.

Thanks.

Ghanashyam

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.