July 29, 2008 at 8:05 am
We are in a precarious situation where in we need to connect to oracle 8 from SQL Server 2005. We can acheive it using Linked server. But the issue is a bit wierd (for me). Here is the issue -
SQL Server resides in a 64 bit machine and we want to establish a connection to oracle 8 which is running on a 32 bit machine. Initially we thought of going for linked serevr but there is an issue. In order to fetch data from oracle we need to have oracle client installed. Unfortunately, 64 bit machine supports oracle 10.2 and above. There seems to be no driver ro establish the connectivity. Our DBA informed me that there is no driver which will support this requirement.
Alternatively, I wrote a normal c# code. But again we need a oracle driver to connect to oracle. Oracle seems to have ended the support for oracle 8 (as per the info I got). I dont want the interface to reside on some other machine. Is there any way out? Please advise me on what needs to be done. Banking on you guys!!!
July 29, 2008 at 8:21 am
The Oracle 10 client should be backward compatible with Oracle 8
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 8:36 am
Thanks Perry...
Will we be able to install a 32 bit client on a 64 bit machine? or installing a 64 bit oracle 10 client can access a Oracle 8 server in a 32 bit machine?
Thanks
July 29, 2008 at 8:46 am
You should install Oracle 10 64bit client.
You have to install a 64 bit client (or any app for that matter) on a 64 bit machine. It doesnt matter which server you connect to from there. What you install has to do with which processor you have on your machine.
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 29, 2008 at 8:58 am
Thanks... Very much appreciated!!
I'll get back after trying this out...
July 30, 2008 at 5:23 am
Windows 2003 x64 does allow some apps to install in 32bit mode for compatibilty but i'm not sure about the Oracle client, use the 64bit v10 if you have it. It should connect to a V8 instance without problems
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2008 at 5:20 am
We have been working with the 64 bit version of SQL Server 2005 for a few months now. We did have some issues connecting to Oracle.
We installed both the 32 bit and 64 bit clients for Oracle 10.2.0.1. Please make sure you patch these both to 10.2.0.3 or you will have some issues.
These are backward compatible to Oracle version 8, but I believe only to version 8.1. I have been told they will not work with Oracle 8.0.5. We have a couple of old Oracle DBs floating around at this version. Fortunately, we do not have to connect to them.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
July 31, 2008 at 11:01 pm
the 9 and 10 client will work for an 8 DB without an issue. I've done it no problems. the other thing you can do is set up a simple odbc connection to the oracle server too, just make sure the DB your spec is in the TSNnames.ora file.
cheers
October 30, 2008 at 5:21 pm
HI all,
I configured replication from SQL Server 2005 64 bit to Oracle 10g 32 bit.
There are no connectivity problems but while synchronizing i am getting syntax issues from oracle databases.
Help me out...
Regards,
Gayaz Ahamed Shaik
October 30, 2008 at 9:10 pm
I would check what the sytax relates to..is it a SQL2005 syntax error or oracle specific? also check the user you're connecting as to the Oracle DB has the rights etc to the Stored Procs and packages etc and make sure they are valid in the Oracle DB if that's whats erroring.
Michael
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply