Oracle ODBC driver 64 BIT install

Posted on 2011-10-18
Last Modified: 2012-05-12
Hi Experts

I have a linked SQL server running of 32bit Windows 2003, Im using the Ms OLE DB provider for oracle, I want to migrate this to 64 Bit windows 2008, Iv done some research and there does appear an Oracle drive for the job, however I havent got the foggest on how to install this does any one have guide or an point me in the right direction?
Question by:MrDavidThorn
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    If you downloaded the driver from, ther will be a read me or installation guide that comes with it.

    I suggest the Oralce Instant Client with ODBC:

    Basic first then the ODBC add on

    Author Comment

    ok iv download from the links but cant find any installation guide,

    I did look at installing from link

    but that may no sense either.
    LVL 76

    Accepted Solution

    It is a little obscure but on the instant Client download link above, scroll all the way to the bottom: Installation Steps

    With the Instant Client there really isn't an install.  Just unzip, create the network/admin/tnsnames.ora file and you are done.

    With the ODBC add-on, just copy the contents in that zip to the same folder as the instant client.

    With the ODAC, there should be a read me of some type.  It has been a while since I installed this but with the XCOPY version I remember something like an install.bat.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now