Tue May 11 13:41:58 2010: SWANDBSRVC_OdbcError entry Tue May 11 13:41:58 2010:SQLColAttribute SQL_DESC_CATALOG_NAME sqlRc = 1 Tue May 11 13:41:58 2010: SWSOC_CursorVar_DescribeCol entry descIx = 155 ** ColdFusion 9 ODBC Server debug log failure ** Survey Research Operations – University of Michigan 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. Following is a successful example where only 4 columns are retrieved. This statement is doing a select * and returning 155 columns. In Sybase 6, the Catalog Name is blank as well, but there are no warnings either. 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 the ColdFusion 9 ODBC Server debug log we see the following warnings as it is trying to run GetDescribe. Connections are setup using the ODBC Socket in CF Administrator. I have been testing in CF9 since it actually gives an error message, where CF6.1 just boots me out to the login page. In both environments, the ColdFusion ODBC Server enters a state where it is hung and the ColdFusion Application Server needs to restart. We are also hoping to move from ColdFusion MX 6.1 to ColdFusion 9 in the near future. We have recently upgraded our database from Sybase 6 to Sybase 11.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |