Post reply

Connecting SQl Server 2005(64 bit m/c) to Oracle 8 (32 bit m/c)

  • July 29, 2008 at 8:05 am

    #123641

    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

    #849827

    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

    #849835

    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

    #849845

    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

    #849864

    Thanks... Very much appreciated!!

    I'll get back after trying this out...

  • July 30, 2008 at 5:23 am

    #850374

    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

    #851168

    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

    #851650

    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

    #892122

    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

    #892154

    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