Oracle ODBC on 64-bit server

Posted on 2006-05-11
Last Modified: 2008-02-01
I have a server running Windows Server 2003 64-bit edition.  I have a 32-bit version of the Oracle 10g client installed (apparently my 32-bit app will not run correctly with the 64-bit version installed).

I have a VBS script that uses the MSDAORA provider to connect to the database; it worked on a 32-bit server but gives "Provider cannot be found" when run on the 64-bit server.

I see that the MSDAORA is listed in the WOW part of the registry but not the main part (as I would expect considering a 64-bit Oracle is not installed).  Is there a way to make my VBS script look for 32-bit providers using WOW?
Question by:etude
    LVL 7

    Expert Comment

    i had the same problem on sql asp on 64 bit
    follow this thread ...something with the persists.

    Author Comment

    Thanks for the post; it seems to be a similar issue, but the fix was making an SQL Server specific change to the connection string so that doesn't seem to apple.  Here is the connection string I'm using:

    "Provider=MSDAORA;Data Source="&database&"; User ID=username; Password=password;"

    Where database = our TNSNames instance name

    The issue seems to be that MSDAORA isn't available in the 64-bit application space; only the 32-bit WOW space.

    Is there perhaps a way to force my VBS script to run under WOW so it can use the MSDAORA that seems to only work in WOW?

    I guess I could probably install the 64-bit Oracle client along side the 32-bit, but that seems like a messy approach just for running a VERY simply VBS script.
    LVL 7

    Accepted Solution

    not on the mdac 2.8 ?
     if they are not available then the 64 bit will not work .

    I not familar with the msdaroa....

    can u connect to SQL through the ODBC and then tried connecting through dns less..sql..dll..

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
    I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    755 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

    17 Experts available now in Live!

    Get 1:1 Help Now