| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| Oracle DB Conection http://teleflow.org/phpbb/viewtopic.php?f=10&t=249 |
Page 1 of 1 |
| Author: | mars2508 [ Wed May 18, 2005 10:31 am ] |
| Post subject: | |
I'm trying to connecto to a Oracle DB vía OBDC but I have the next error: <br> <br>May 18 11:10:29.52: [9] DB Connect <br>May 18 11:10:29.52: ConnectString: DSN=OPENBANK;UID=ivr;PWD=ivrd <br>May 18 11:10:31.04: SQL Error State: 01000 <br> Native Error Code: 0 <br> ODBC Error: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). <br>May 18 11:10:31.06: SQL Error State: HYC00 <br> Native Error Code: 0 <br> ODBC Error: [Oracle][ODBC Oracle Driver]Driver not capable. |
|
| Author: | Chris [ Wed May 18, 2005 10:42 am ] |
| Post subject: | |
Does the next line say 'FAILURE'? <br> <br>If it doesn't, don't worry about it. These "errors" are returned from the ODBC driver, but are not necessarily indicative of a major problem. If you can successfully query the database in spite of these errors, continue working with you application and don't worry about it. |
|
| Author: | mars2508 [ Wed May 18, 2005 10:50 am ] |
| Post subject: | |
You are right, the next line doesn't say 'FAILURE', but I'm invoking a Stored Procedure into a Fetch Step and I also have this error: <br> <br>May 18 11:49:57.60: [11] SQL Fetch <br>May 18 11:49:57.60: ERROR: No SQL statement defined <br>May 18 11:49:57.60: FATAL <br>May 18 11:49:57.60: Attempting to jump to Fatal Error Global Event label: '' <br>May 18 11:49:57.60: Fatal label undefined! <br>May 18 11:49:57.62: Shutting down... |
|
| Author: | mars2508 [ Wed May 25, 2005 3:29 pm ] |
| Post subject: | |
I didn't find any response from you... Could you help me with my problem? |
|
| Author: | admin [ Wed May 25, 2005 4:00 pm ] |
| Post subject: | |
Hi mars2508, <br> <br>Please see the forum discussion here: <a href="http://devnet.engenic.com/index.php?action=vthread&forum=10&topic=248 " target="_new">http://devnet.engenic.com/index.php?action=vthread&forum=10&to pic=248 </a><br> <br>It discusses the correct way to call a stored procedure within a SQL Statement. |
|
| Author: | mars2508 [ Thu May 26, 2005 8:48 am ] |
| Post subject: | |
It still doesn't work... I write it in this way: <br> <br>EXECUTE my_procedure (@USUARIO,@CUENTA,@RESULTADO,@SALDO); <br> <br>Where @USUARIO,@CUENTA,@RESULTADO,@SALDO are local variables… <br> <br>Do I have to use something else apart of a DB Connect, a SQL Statement, a SQL Fetch and a SQL End? |
|
| Author: | admin [ Thu May 26, 2005 8:51 am ] |
| Post subject: | |
Have you quoted string values? |
|
| Author: | mars2508 [ Wed Jun 08, 2005 1:42 pm ] |
| Post subject: | |
Yes I have... |
|
| Author: | Chris [ Wed Jun 08, 2005 3:19 pm ] |
| Post subject: | |
Does the SQL Fetch step have the same handle number as the SQL Statement step you are using to define the stored procedure? They should have a number from 1-9, and they should be the same number. <br> <br>Does your stored procedure return its data in fields? |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|