Page 1 of 1

DataDirect ODBC error running Oracle Stored Procedure

Posted: Tue Jun 08, 2004 12:26 pm
by lgharis
We have an ODBC job which executes an Oracle Stored Procedure that is failing in the ODBC driver with the following error.

DataStage Job 860 Phantom 19861
6066:
[DataDirect][ODBC 20101 driver]6060
DataStage Phantom Finished

There was a QEWSD= entry in the .odbc.ini file which I removed. When they reran the job the QEWSD= entry had reappeared and the job failed. Jobs that do not run stored procedures run successfully. Developer has verified the Oracle Id can run the stored procedure in SQLPlus.

Any ideas?

Leroy Gharis
JPMorganChase

Posted: Tue Jun 08, 2004 4:10 pm
by lgharis
From the Data Direct Forum I discovered the 6060 code is a licensing error. The IVODBC.LIC file had not been installed on the system that was failing. Copied the file from one of the working systems. All is working ok now.

Leroy
JPMorganChase

Posted: Tue Jun 08, 2004 6:38 pm
by ray.wurlod
Welcome aboard! :D
Thanks for posting the solution. Hopefully it will help someone else in the future.