May 20, 2015 at 11:06 am
Hey guys,
I am unable to connect to the older Oracle 8/8i servers through linked servers using 2008R2. I installed 11g 32-bit then 64-bit and was able to add Oracle v9 and higher linked server. After some googling it appears 11g does not support 8i but 10g does. So I install the 10g 32-bit client but still get the "ORA-03134: Connections to this server version are no longer supported" error. I think this could be that the OraOLEDB.Oracle provider is still trying to use 11g's. How do I switch that? What am I missing?
Thanks
May 20, 2015 at 4:27 pm
I think that might be tough. I had a similar issue a couple of years ago with a project to convert an old Oracle 8.0.5 db to SQL Server. The problem was every tool I wanted to use needed an Oracle client in order to provide connectivity. My eventual way around it was I had to get with our Oracle team who had a support contract with Oracle. They were able to get the Oracle 9i client for Windows which I believe had providers that things like linked servers and the SQL Server Migration Assistant could use.
Good luck.
Joie Andrew
"Since 1982"
May 21, 2015 at 8:18 am
Thanks Joie. My issue is I do have the 10g client installed that should be able to talk to 8 via linked server, not sure what I'm missing though.
May 21, 2015 at 8:36 am
8 or 8i? What specific version of Oracle are you trying to connect to and what version of the Oracle 10g client do you have?
Joie Andrew
"Since 1982"
May 21, 2015 at 11:47 am
Server - Oracle8i Enterprise Edition Release 8.1.7.4.0
Client 10g - 10.2.0
May 22, 2015 at 3:10 pm
Just to make sure, if you use an Oracle client utility like SQL*Plus can you connect to the Oracle 8i database?
Hard to say but you might be right about the linked server provider trying to use the provider from the 11g client.
This is not exactly related, but it there seems to be instances where outside products are not aware of multiple Oracle homes.
Oracle 10 and Oracle 11 clients coexistence
I wonder if you take a look at your path environment variable and see which client Oracle home comes first if that indicates it could be using the 11g client provider. If that is the case you could try putting the 10g client path first and see if that fixes it. Not sure if SQL would have to be restarted first.
Joie Andrew
"Since 1982"
May 25, 2015 at 8:47 am
Yes I am able to connect via SQL*Plus with the 10g client and it is the first one in the Path environment variable.
May 25, 2015 at 1:58 pm
I installed 11g 32-bit then 64-bit...
Is the SQL Server you have the clients installed on 64-bit or 32-bit? You mention installing both for the 11g client. I believe the client should be the same architecture as the version of SQL Server running. Did you install the 32-bit version of the 10g client as well? Your original post only mentions the 32-bit version.
Joie Andrew
"Since 1982"
May 26, 2015 at 11:51 am
Thanks Joie!
Yes I was missing the 10g 64-bit client as I'm running 2008R2 64-bit. I needed to use an older oracle version I found (10204_vista_w2k8_x64) and then edit the oraparam.ini to allow windows 6.1 (running windows server 2008 r2) and then ignore the prerequisite errors.
May 26, 2015 at 1:12 pm
Just to help me clarify:
You installed the missing 64-bit 10g client?
Is the linked server working now?
Joie Andrew
"Since 1982"
May 26, 2015 at 1:13 pm
Yes, I had 10g 32-bit and 11g 32-bit and 64-bit but not 10g 64-bit. Linked servers for Oracle 8 are working now.
May 26, 2015 at 1:58 pm
Great. Glad it is working for you. Also, I appreciate the follow-up.
Joie Andrew
"Since 1982"
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply