Oracle

[Richard James]

Ihave tried to connect using an Oracle database using the Oracle type, but I get"[iODBC][Driver Manager]Specified driver could not be loaded". I can conect via ODBC, but it is very slow. I get the same results if I use the Query Builder.

put revOpenDatabase("odbc",,"TestDB","PS","Password") into mydbid

[Richard James]

I'm suing a Mac running leopard 10.5.5.

I have tried connecting in and out of Rosetta. The ODBC cnnection that I can make is in Rosetta only.

My driver is from Actual Technologies.

[Mark]

Hi Richard,

That's right, the Oracle driver is available for PowerPC only. I believe this is not a Rev problem but rather an Oracle problem.

Best,

Mark

[mikele]

Hi everyone,
looks like there's not much activity on the "runrev oracle front"...
Hence my questions :

1) as of Jan 2010, what is the current status for runrev enterprise users running Mac OS X 10.6.2 on an intel Mac
and willing to connect "natively" to an oracle database (i.e. not through odbc)

2) Hasn't oracle released some native x86 "instant client" software for Mac OS X in april / may of 2009 ? and is this actually relevant for question #1 ?

FYI, I'm just starting a system monitoring project that needs to connect to an oracle 10g database on a big unix box and I was trying to use runrev for it...
I actually upgraded from Studio to Enterprise mostly for this native oracle feature... only to discover that there may be an issue on intel macs !

http://quality.runrev.com/qacenter/show_bug.cgi?id=7102

Thanx in advance for your help
Mikélé

[bn]

Hi Mikélé,
long time no see...
I don't know anything about Oracle but did a quick search for Oracle on the list:
http://n4.nabble.com/forum/Search.jtp?f ... ery=oracle
It seems that Jan Schenkel knows something about Oracle and Rev. He is regularly on this forum, but not daily. Maybe he chimes in.
Not more that I can do, but you might also ask for support at runrev, since it is a feature they promote.
regards
Bernd

[Janschenkel]

The tricky part is that Oracle has to provide a proper library for the RunRev driver to use. And Oracle hadn't provided anything for Intel Macs for a very long time.
See also this quality center entry, where I posted a link to the Oracle-on-Mac OS X Technology Center, which seems to contain updated stuff for Intel Macs. I hope Mark Schonewille will reopen the report and that the RunRev engineers take another look at this.

Best of luck,

Jan Schenkel.

[mikele]

Hi Bernd & Jan, thanks guys for your answers !

Essentially, my point is that oracle released an intel "instant client" version for oracle 10g on intel macs... in april 2009 !
I've enclosed a screenshot of the content which shows the presence of some Java JAR files (probably for JDBC connectivity) but also some dynamic libraries (.dylib), presumably with intel code !
Now I understand that these are definitely not the files to put directly in the dboracle.bundle (folder) in the "./Externals/Database Drivers" folder of my enterprise runrev application, but I have the idea that they could be the ones mentioned as "not yet released" in the september 2008 closure message of the QA report #7102...

Since then, Jan has apparently added that same question and asked for a reopening ! thank you Jan !
I was about to do the same but since I'm new on this runrev oracle "plugin", I wanted to first make sure that I did not forget something obvious and so preferred to ask first on the forum. I'm just surprised that not (m)any enterprise runrev customers are annoyed by this situation...
Are they all using PowerPC macs or maybe only mysql or sqlite ? I'm confused !

Cheers - Mikélé

PS : Bernd, yeah, I'm very busy as you can guess !
I'll probably go back to you soon on some other ideas I have for video processing !
Take care !

Finder-Snapz-001.jpg (53.16 KiB) Viewed 6668 times

[mikele]

One more thing : I hope the "april fool" dates in the oracle folder are not a bad indication...