Hi there, We have recently upgraded our database from Sybase 6 to Sybase 11. We are also hoping to move from ColdFusion MX 6.1 to ColdFusion 9 in the near future. In both environments, the ColdFusion ODBC Server enters a state where it is hung and the ColdFusion Application Server needs to restart. I have been testing in CF9 since it actually gives an error message, where CF6.1 just boots me out to the login page. Connections are setup using the ODBC Socket in CF Administrator.
In the ColdFusion 9 ODBC Server debug log we see the following warnings as it is trying to run GetDescribe. It appears that it is unable to retrieve Catalog Name, but I donât know why this would cause the ODBC Server to die. In Sybase 6, the Catalog Name is blank as well, but there are no warnings either. This statement is doing a select * and returning 155 columns. Following is a successful example where only 4 columns are retrieved. I could (and have) gone through and chop my select statements, but since this worked in Sybase 6 I wonder if there is a handshaking problem? I would appreciate any advice on setting up my DSN or ODBC server that may help this issue. Thank you for your help! Holly Ackerman Applications Programmer Survey Research Operations â University of Michigan ** ColdFusion 9 ODBC Server debug log failure ** Tue May 11 13:41:58 2010: SWSOC_CursorVar_DescribeCol entry descIx = 155 Tue May 11 13:41:58 2010:SQLColAttribute SQL_DESC_CATALOG_NAME sqlRc = 1 Tue May 11 13:41:58 2010: SWANDBSRVC_OdbcError entry Tue May 11 13:41:58 2010: SWSOC_OdbcErrorWithState entry Tue May 11 13:41:58 2010:Diagnostics (Warning) added: message:[01004][ODBC Socket][Sybase][ODBC Driver]Data truncated;code:0;component:6;function:10;row:0;column:0 Tue May 11 13:41:58 2010: SWSOC_OdbcErrorWithState exit Tue May 11 13:41:58 2010: SWANDBSRVC_OdbcError exit Tue May 11 13:41:58 2010: SWSOC_CursorVar_DescribeCol exit Tue May 11 13:41:58 2010:SWANDB_GetDescribe exit Tue May 11 13:41:58 2010:The active request for session 8 is interrupted due to an unexpected exception Tue May 11 13:41:59 2010:SWANDB_FreeVariables entry Tue May 11 13:41:59 2010:SWANDB_FreeVariables exit Tue May 11 13:41:59 2010:SWANDB_Close entry Tue May 11 13:41:59 2010:SWANDB_Close exit Tue May 11 13:41:59 2010:SWANDB_Logoff entry Tue May 11 13:41:59 2010:Abnormal logoff detected (caused by crash, kill, ....) Tue May 11 13:41:59 2010:Logoff behaviour not set, using database default Tue May 11 13:41:59 2010:SWANDB_Logoff exit ColdFusion 9 ODBC Server dump file: //===================================================== Tuesday, May 11, 2010 1:41:58 PM ACCESS_VIOLATION Stack Dump: PC:7C82CAC2-Seg:1;Off:0002BAC2-RtlDeleteCriticalSection+11A PC:7C833A52-Seg:1;Off:00032A52-RtlGetFullPathName_UstrEx+16D PC:7C82B61B-Seg:1;Off:0002A61B-wcscpy+180 PC:0046F5AB-Seg:1;Off:0006E5AB PC:0046F5CD-Seg:1;Off:0006E5CD //===================================================== When I look at the ODBC Server debug log for other GetDescribe statements on the same table, the same warnings appear, and the catalog name is blank, but it seems to proceed fine from there. In the example below, I limit the select to 4 columns. ** ColdFusion 9 ODBC Server debug log success ** Tue May 11 13:41:37 2010: SWSOC_CursorVar_DescribeCol entry descIx = 4 Tue May 11 13:41:37 2010:SQLColAttribute SQL_DESC_CATALOG_NAME sqlRc = 1 Tue May 11 13:41:37 2010: SWANDBSRVC_OdbcError entry Tue May 11 13:41:37 2010: SWSOC_OdbcErrorWithState entry Tue May 11 13:41:37 2010:Diagnostics (Warning) added: message:[01004][ODBC Socket][Sybase][ODBC Driver]Data truncated;code:0;component:6;function:10;row:0;column:0 Tue May 11 13:41:37 2010: SWSOC_OdbcErrorWithState exit Tue May 11 13:41:37 2010: SWANDBSRVC_OdbcError exit Tue May 11 13:41:37 2010: SWSOC_CursorVar_DescribeCol exit Tue May 11 13:41:37 2010:SWANDB_GetDescribe exit Tue May 11 13:41:37 2010:SSP OUTPUT =================================== sspVersion:9 error :1 -------------------------------------------- CHAIN num:4 subPacketError:0 OPEN stmtRefnum:3 EXECDIRECT row count :-1 result available :1 transaction :0 output available :no GETDESCRIBE numDescs:4 (logging describe cursorvar:1) auto unique :no case sensitive:no catalog name : money :no label :npreferenceid length :5 name :npreferenceid nullable :no scale :0 schema name :DBA searchable :searchable table name :<table name successfully displayed here> type :numeric type name :numeric unsigned :no updatable :yes encoding : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm