I'm hoping someone can give me some pointers here. The setup I'm using is as follows:
Windows 7 Pro x64 SP1
Office 2010 x64
Oracle 10g 10.2.0 32 bit client
Oracle 10g 32 bit database
Java 7 Update 25 (64 bit), version 7.0.250
Java SE Development Kit 7 Update (64 bit), version 184.108.40.206
(Also just downloaded SQL Developer 4, but that's a different story)
...and I'm trying to create an ODBC connecton in Excel. Now - obviously I can't use 32 bit ODBC in 64 bit Excel, as it's the wrong architecture type. I've been searching around and trying to answer the following questions:
Can I have separate 64 bit ORacle drivers just sitting in a folder by themselves, and use those to communicate with a 32 bit Oracle DB?
If so, do they exist anywhere for download?
I've tried downloading ODAC10203x64.zip, but when unpacked and opened, I get an error saying "Java 2 platform standard edition binary has stopped working", and I get no further. Further questions are:
What does that error mean? Can it be remedied?
If not, is it possible just to unpack all the jar files, find the drivers in there, register them and use them that way?