Oracle driver 64 bit issue

Posted on 2007-10-16
Last Modified: 2013-12-19

We have a VBS file which pulls the data from the Oracle database and loads into our local SQL Server database, and we were using the provider as OraOLEDB.Oracle and it was working fine until we moved to Windows 2003 server in 64 bit mode and aslo we have downloaded the 64bit ODBC provider for Oracle from their site but when we run the query and try to insert into our databse by looping we get only the first record eventhough the result of the select statment has more than record. I am sure is something to do with the 64 bit provider.
Please help to overcome this issue.
Question by:razik2781
    LVL 9

    Expert Comment

    Install a x86 oracle client on the 64bit box and use that provider.. we had an issue with DTS packages using DSN's after upgrading to 64bit and the way we resolved it was by installing an x86 client on our x64 box just for that purpose just make sure after you install your client to change ure ORACLE_HOME var

    Author Comment

    How to change the ORACLE_HOME var

    Author Comment

    But on the same box we have our web application running which is using the 64 bit Oracle provider.. Will that be a problem then.. and also can both 32 bit Oracle Provider and 64 bit Oracle provider exist on the same machine
    LVL 9

    Accepted Solution

    i don't know much about odbc, vbs ... but standard oracle distribution includes both 32 and 64 bil libraries. 64 bit version ones are in $ORACLE_HOME/lib, 32 bit version ones in $ORACLE_HOME/lib32 in 10g.
    64 bit version libraries are in $ORACLE_HOME/lib64 and 32 bit version ones are in $ORACLE_HOME/liv in 8i and older.
    10g express edition is only 32 bit version, so $ORACLE_HOME/lib stores only 32 bit version libraries, there are no 64 bit version ones.
    LVL 9

    Assisted Solution

    There is no issue of having an x86 home aswell as a x64 home on the same box.  After you install your x86 home the providers can be accessed from your x86 ODBC admin from "C:\WINDOWS\SysWOW64\odbcad32.exe"  After you install your new x86 home you have to to change your PATH var my computer->properties->advanced->environment variables->double click on PATH and move the x86 home to end if you dont then any programs that dont use the full path to an oracle .exe will use the x86 version.

    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.

    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…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    759 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

    12 Experts available now in Live!

    Get 1:1 Help Now