RE: Error: Coldfusion & SAP ODBC

[Koetter, Thomas Theodor]

Hi Stefan   Why don't you use SAP DB's JDBC driver?   "Data truncated" is no error but an information, that data is not complete.   Please send me a driver manager trace and a driver trace (cmp http://sapdb.2scale.net/moin.cgi/ODBCTrace)     Regards  Thomas   ---------------------------------------------- Dr. Thomas Kцtter SAP DB, SAP Labs Berlin SAP DB is open source. Get it!    www.sapdb.org   -----Original Message----- From: Stefan d. Koning [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 30, 2002 5:52 PM To: [EMAIL PROTECTED] Subject: Error: Coldfusion & SAP ODBC Both ColdFusion 5.0 and and ColdFusionMX have no problems with connecting to the SAP database. It also can read out the table names, but it is unabled to launch any other queries though. These are the errors I get:   DreamWeaver MX: when trying to 'View Data' on a table: -1:[MERANT][SequeLink JDBC Driver][ODBC Socket][SAP AG][SQLOD32 DLL]Data truncated.   ColdFusion Studio 5.0: when trying to view the columns of a table: [MERANT][SequeLink JDBC Driver][ODBC Socket][SAP AG][SQLOD32 DLL] Invalid descriptor field identifier.     We are running the latest version of SAP DB, and the latest version of the SAP DB ODBC Driver. I've tried all optional settings of the ODBC Driver, but neither worked.   Someone else reported the same problem in September ( http://listserv.sap.com/pipermail/sapdb.general/2002-September/014100.html ), but I couldn't find a reply to his email. Perhaps somebody can help me out now?   Thanks in advance, Stefan de Koning