Skip to main content
B
biene22
Inspiring
June 6, 2011
Answered

How to connect to Oracle 11gR2 from CF9

  • June 6, 2011
  • 2 replies
  • 1723 views

Hi,

how to connect to Oracle 11gR2 64 bit Database from CF9?

In CF Administrator no Oracle Driver is available.

Do I have to install Oracle Client Software on Server Hardware where CF9 Server is installed?

If yes, is Oracle Instant Client is enough or do I have to install full oracle client?

Any idea?

regards Claudia

This topic has been closed for replies.
Correct answer Owainnorth

I assume you're using Standard Edition? Native drivers for Oracle only come with CF9 Enterprise, you'll need to download the JDBC drivers from Oracle's website.

2 replies

B
biene22Author
Inspiring
June 7, 2011

Yes it works.

Thank you!

Owainnorth
Owainnorth
Inspiring
June 7, 2011

Excellent, glad to hear it's sorted. Just be careful if you use any of the "advanced" features such as returning querysets from stored procedures or BLOBs, apparently there are differences between the JDBC and full DataDirect drivers in those cases.

However in 99% of cases you won't notice the difference.

Owainnorth
OwainnorthCorrect answer
Inspiring
June 6, 2011

I assume you're using Standard Edition? Native drivers for Oracle only come with CF9 Enterprise, you'll need to download the JDBC drivers from Oracle's website.

B
biene22Author
Inspiring
June 6, 2011

Yes, I have CF Standard Edition. I hoped that jdbc driver comes with oracle instant client installation,

but they didn't...

Okay I'll download the drivers and test again.

Thank you for fast reply!

Claudia

K
krankenversicherung
Participant
June 6, 2011

I also had the same problem and solved this when I download drivers from Oracle website!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices