MX 7 to Oracle 8.1.6

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russian - 28 Dec 2005 21:51 GMT

Hi all,
I just installed CF MX 7 and trying to connect to Oracle 7.3.4 database using
Oracle thin driver.
I am getting an error:
-----------------------------
Connection verification failed for data source: PANDORA
java.sql.SQLException: ORA-01010: invalid OCI operation
The root cause was that: java.sql.SQLException: ORA-01010: invalid OCI
operation
------------------------

How do I connect MX 7 to Oracle 7.3.4???

Thanks,

Reply to this Message

Umbrae - 29 Dec 2005 13:34 GMT

Could you not get this to work with the ColdFusion Default Oracle Drivers? You
are getting an OCI error, which is usually related to the native Oracle
drivers; not JDBC Thin drivers. However, I have never used Oracle 7.3.4.

Reply to this Message

Russian - 29 Dec 2005 16:00 GMT

Do you suggest using an ODBC driver and not a thin driver?

Reply to this Message

Umbrae - 29 Dec 2005 16:20 GMT

I would not use ODBC at all.

You should try them in this order:
1. ColdFusion Default Driver (select Oracle from the drop down).
2. Oracle JDBC Thin Driver (download from Oracle's website find MM technote on
config).
3. Oracle Native Driver (not even sure HOW to do this with MX. Probably a
technote for it).

Reply to this Message

Russian - 29 Dec 2005 16:47 GMT

Problem is: I don't have Oracle driver to select from the drop down. I only have "other", so I've done that.

Reply to this Message

Umbrae - 29 Dec 2005 18:39 GMT

Then you have a bigger problem. There should be 9 items excluding Other. I
would suggest reinstalling ColdFusion since it sounds like the product is not
installed properly.

You can use the Other, but if your install of CF is messed up it won't help
you.

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / December 2005

MX 7 to Oracle 8.1.6