Home » SQL & PL/SQL » SQL & PL/SQL » CONNECTIN TO ACUCOBOL VIA ODBC
CONNECTIN TO ACUCOBOL VIA ODBC [message #240342] Thu, 24 May 2007 11:40 Go to next message
jfigueiredo
Messages: 4
Registered: May 2007
Junior Member
Hi,

I am trying to connect via odbc to acubol i can connect but when i do the select ruturn an error like this

SQL> desc control
ORA-01010: invalid OCI operation
Name Null? Type
------------------------------- -------- ----
CONTROL_KEY NUMBER(1)
CONTROL_LAST_VOUCHER NUMBER(10)

SQL> select * from control;
ERROR:
OCA-30027: error setting ODBC connection/statement option



no rows selected


Can anyone help me?

Thanks in advance
Pedro
Re: CONNECTIN TO ACUCOBOL VIA ODBC [message #240343 is a reply to message #240342] Thu, 24 May 2007 11:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ORA-01010: invalid OCI operation
Cause: One of the following: 1) You attempted an invalid OCI operation. 2) You
are using an Oracle client application linked with version 7.1 (or higher) libraries,
the environment variable ORA_ENCRYPT_LOGIN is set to TRUE, and you attempted to connect to a version 7.0 (or lower) Oracle Server. 3) You are
connected to a version 7.1 (or higher) Oracle Server, the initialization parameter
DBLINK_ENCRYPT_LOGIN is set to TRUE, and you attempted to use a database
link pointing to a version 7.0 (or lower) Oracle Server. 4) You are connected to a
version 9.0.2(or higher) Oracle Server and you attempted to use a database link
pointing to a version 9.0.1(or lower) Oracle Server for distributed autonomous
transaction.
Action: For the above causes: 1) Do not use the invalid OCI operation. 2) If you do
not wish to use encrypted connect passwords in your distributed database, set
ORA_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted connect
passwords, you must upgrade all Oracle Servers to version 7.1 (or higher). 3) If
you do not wish to use encrypted database links in your distributed database, set
DBLINK_ENCRYPT_LOGIN to FALSE. If you wish to use encrypted database
links, you must upgrade all Oracle Servers to version 7.1 (or higher). 4) Do not
attempt distributed autonomous transaction on version 9.0.1(or lower) Oracle
Server.
Re: CONNECTIN TO ACUCOBOL VIA ODBC [message #240348 is a reply to message #240343] Thu, 24 May 2007 11:54 Go to previous message
jfigueiredo
Messages: 4
Registered: May 2007
Junior Member
ok, i am connecting to a odbc driver so the part refering to the database versio does not apply, also i can do delete and insert only select and update do the error:

ERROR:
OCA-30027: error setting ODBC connection/statement option
Previous Topic: granting system privs to a role then user but nothing shows up
Next Topic: Trigger on a View
Goto Forum:
  


Current Time: Sat Dec 03 22:26:58 CST 2016

Total time taken to generate the page: 0.05017 seconds