| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| DB error http://teleflow.org/phpbb/viewtopic.php?f=10&t=202 |
Page 1 of 1 |
| Author: | netscon [ Mon Nov 22, 2004 10:36 am ] |
| Post subject: | |
I'm developing an application to connect to a clarion data base but <br>I have this following error. <br> <br> Initialization done <br> <br>Nov 22 10:10:30.89: ==>prueba <br>Nov 22 10:10:30.89: [1] START <br>Nov 22 10:10:30.89: [3] DB Connect <br>Nov 22 10:10:30.90: ConnectString: DSN=netsco-caltv <br>Nov 22 10:10:33.00: SQL Error State: HY092 <br> Native Error Code: 43C <br> ODBC Error: [TopSpeed Corp.][TopSpeed ODBC Driver]Invalid attribute identifier. <br>Nov 22 10:10:33.01: [5] SQL Begin Transaction <br>Nov 22 10:10:33.01: ERROR: Attempt to set manual-commit mode failed. <br>Nov 22 10:10:33.01: FAILURE <br>Nov 22 10:10:33.01: ERROR: Missing next step <br>Nov 22 10:10:33.01: FATAL <br>Nov 22 10:10:33.01: Attempting to jump to Fatal Error Global Event label: '' <br>Nov 22 10:10:33.01: Fatal label undefined! <br>Nov 22 10:10:33.01: Shutting down... <br>Nov 22 10:10:33.01: XMLList destructor done <br>Nov 22 10:10:36.01: <br> <br> <br>Nov 22 10:10:36.01: All memory released. Exiting... <br> <br> <br>I havent worked with clarion, do you know if its an error related with clarion? or is something I need to <br>do first on Teleflow? <br> <br>Thank you |
|
| Author: | Chris [ Wed Nov 24, 2004 4:49 pm ] |
| Post subject: | |
The DB Connect step successfully connects to the database, despite the warning. <br> <br>I would suggest that you simply try using a SQL Statement, and do without transactions. Since the database connection was a success, you can likely work with the database using the "SQL Statement" step to select, update, insert, and delete data. |
|
| Author: | admin [ Wed Nov 24, 2004 4:54 pm ] |
| Post subject: | |
The messages returned by ODBC are displayed by TeleFlow. Start without Transactions first, and go strictly with SQL Statement / SQL Fetch. Once that works, then come back to the Transactions. |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|