I have to be incompetent. It can't possibly be Oracle software being utter tulipe. I accept my incompetence for what it is and humbly beg your help.
Here is what I must accomplish before I leave today (in 3 hrs).
I need to install Oracle instant client 64 and 32 bit on a server, create a tnsnames.ora file in both clients and create an ODBC connection in the 32 bit client only to use this tnsnames entry.
This needs to be done because the vendor stipulates it.
Actually what the vendor says is
Install 64 bit instant client.
Install 32 bit instant client.
Install ODAC.
What they fail to mention is that when installing ODAC, you need to install it to the 32 bit directory of the 32 bit instant client. That was last nights fun and games figuring out that little challenge. In fact I fail to see why you need to install ODAC after having installed the 32 bit instant client, but let's leave that for now.
So back to my sheer incompetence.
Last night in the hotel I completed the above tasks, and when trying to create an ODBC connection (using the 32 bit ODBC administrator from SysWOW64) I could not as the tns entry was not appearing in the drop down list. After much foogling I found one solution which was to create a new registry value in the Oracle 32 bit section of the registry called TNS_ADMIN. I hate registry hacking and was really uncomfortable doing this, especially with me having sporks for hands and all.
But it worked and I was able to create an ODBC connection in the 32 bit client. So I documented all that I did and went to bed.
I skipped to work this morning, full of the joys of spring, safe in the knowledge that I had basic reproduceable steps documented on my lappy. How utterly naive of me.
64 bit client installed ok.
32 bit client installed ok.
ODAC 32 installed ok.
Create TNS entry. Test. Ok.
TNSPing this entry. Ok.
SQLPlus (32 bit) log in using this TNS entry, ok.
Open 32bit ODBC Admin, new ODBC Connection - using 32bit driver. No TNS entries in the list. Ah hah! My magic registry hack! Smugly done, and still doesn't fracking work
As I say, the very epitome of incompetence, flame away, but please for all the flaming, at least one post showing me the error of my ways.
TIA
Suity SporkHands
Here is what I must accomplish before I leave today (in 3 hrs).
I need to install Oracle instant client 64 and 32 bit on a server, create a tnsnames.ora file in both clients and create an ODBC connection in the 32 bit client only to use this tnsnames entry.
This needs to be done because the vendor stipulates it.
Actually what the vendor says is
Install 64 bit instant client.
Install 32 bit instant client.
Install ODAC.
What they fail to mention is that when installing ODAC, you need to install it to the 32 bit directory of the 32 bit instant client. That was last nights fun and games figuring out that little challenge. In fact I fail to see why you need to install ODAC after having installed the 32 bit instant client, but let's leave that for now.
So back to my sheer incompetence.
Last night in the hotel I completed the above tasks, and when trying to create an ODBC connection (using the 32 bit ODBC administrator from SysWOW64) I could not as the tns entry was not appearing in the drop down list. After much foogling I found one solution which was to create a new registry value in the Oracle 32 bit section of the registry called TNS_ADMIN. I hate registry hacking and was really uncomfortable doing this, especially with me having sporks for hands and all.
But it worked and I was able to create an ODBC connection in the 32 bit client. So I documented all that I did and went to bed.
I skipped to work this morning, full of the joys of spring, safe in the knowledge that I had basic reproduceable steps documented on my lappy. How utterly naive of me.
64 bit client installed ok.
32 bit client installed ok.
ODAC 32 installed ok.
Create TNS entry. Test. Ok.
TNSPing this entry. Ok.
SQLPlus (32 bit) log in using this TNS entry, ok.
Open 32bit ODBC Admin, new ODBC Connection - using 32bit driver. No TNS entries in the list. Ah hah! My magic registry hack! Smugly done, and still doesn't fracking work
As I say, the very epitome of incompetence, flame away, but please for all the flaming, at least one post showing me the error of my ways.
TIA
Suity SporkHands
Thanks bud 
Comment