[Mono-bugs] [Bug 61180][Nor] Changed - Odbc: Connection Pooling does not work.

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 28 Jul 2004 12:22:05 -0400 (EDT)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by sebastien.robitaille@croesus.com.

http://bugzilla.ximian.com/show_bug.cgi?id=61180

--- shadow/61180	2004-07-28 12:00:13.000000000 -0400
+++ shadow/61180.tmp.11402	2004-07-28 12:22:05.000000000 -0400
@@ -93,6 +93,113 @@
 
 Yes, the problem is still there (with CVS sources of 26th of July).
 The problem may be related to freeTDS...
 
 Sébas
 
+
+------- Additional Comments From sebastien.robitaille@croesus.com  2004-07-28 12:22 -------
+Here is my unixODBC log file with the error at the end (invalid 
+handle):
+
+[ODBC][15034][__handles.c][421]
+		Exit:[SQL_SUCCESS]
+			Environment = 0x8136c98
+[ODBC][15034][SQLSetEnvAttr.c][178]
+		Entry:            
+			Environment = 0x8136c98            
+			Attribute = SQL_ATTR_ODBC_VERSION            
+			Value = 0x3            
+			StrLen = (nil)
+[ODBC][15034][SQLSetEnvAttr.c][345]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLAllocHandle.c][345]
+		Entry:
+			Handle Type = 2
+			Input Handle = 0x8136c98
+[ODBC][15034][SQLAllocHandle.c][463]
+		Exit:[SQL_SUCCESS]
+			Output Handle = 0x8137510
+[ODBC][15034][SQLConnect.c][3452]
+		Entry:            
+			Connection = 0x8137510            
+			Server Name = [<REMOVED SERVER NAME>][length 
+= 999 (SQL_NTS)]            
+			User Name = [<REMOVED USER NAME>][length = 
+999 (SQL_NTS)]            
+			Authentication = [<REMOVED PASSWORD>][length 
+= 999 (SQL_NTS)]
+		UNICODE Using encoding ASCII 'ISO8859-1' and 
+UNICODE 'UCS-2LE'
+
+		DIAG [] [FreeTDS][SQL Server]Changed database 
+context to 'tempdb'.
+
+
+		DIAG [] [FreeTDS][SQL Server]Changed database 
+context to '<REMOVED DATABASE NAME>'.
+
+
+[ODBC][15034][SQLConnect.c][4025]
+		Exit:[SQL_SUCCESS_WITH_INFO]
+[ODBC][15034][SQLDisconnect.c][204]
+		Entry:            
+			Connection = 0x8137510
+[ODBC][15034][SQLDisconnect.c][285]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLFreeHandle.c][268]
+		Entry:
+			Handle Type = 2
+			Input Handle = 0x8137510
+[ODBC][15034][SQLFreeHandle.c][317]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLFreeHandle.c][203]
+		Entry:
+			Handle Type = 1
+			Input Handle = 0x8136c98
+[ODBC][15034][__handles.c][421]
+		Exit:[SQL_SUCCESS]
+			Environment = 0x81bd608
+[ODBC][15034][SQLSetEnvAttr.c][178]
+		Entry:            
+			Environment = 0x81bd608            
+			Attribute = SQL_ATTR_ODBC_VERSION            
+			Value = 0x3            
+			StrLen = (nil)
+[ODBC][15034][SQLSetEnvAttr.c][345]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLAllocHandle.c][345]
+		Entry:
+			Handle Type = 2
+			Input Handle = 0x81bd608
+[ODBC][15034][SQLAllocHandle.c][463]
+		Exit:[SQL_SUCCESS]
+			Output Handle = 0x81bdb98
+[ODBC][15034][SQLConnect.c][3452]
+		Entry:            
+			Connection = 0x81bdb98            
+			Server Name = [<REMOVED SERVER NAME>][length 
+= 999 (SQL_NTS)]            
+			User Name = [<REMOVED USER NAME>][length = 
+999 (SQL_NTS)]            
+			Authentication = [******][length = 999 
+(SQL_NTS)]
+[ODBC][15034][SQLConnect.c][3581]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLDisconnect.c][204]
+		Entry:            
+			Connection = 0x81bdb98
+[ODBC][15034][SQLDisconnect.c][263]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLFreeHandle.c][268]
+		Entry:
+			Handle Type = 2
+			Input Handle = 0x81bdb98
+[ODBC][15034][SQLFreeHandle.c][317]
+		Exit:[SQL_SUCCESS]
+[ODBC][15034][SQLFreeHandle.c][203]
+		Entry:
+			Handle Type = 1
+			Input Handle = 0x81bd608
+[ODBC][15034][SQLFreeHandle.c][217]Error: HY010
+[ODBC][15034][SQLError.c][552]Error: SQL_INVALID_HANDLE
+