Connecting to Oracle using 64bit ODP Client

2 posts, 0 answers
  1. Smithgar
    Smithgar avatar
    1 posts
    Member since:
    Dec 2009

    Posted 06 Jul 2010 Link to this post

    I am setting up a development machine for Sharepoint 2010.  The OS is Windows Server 2008 R2.  I have installed VS 2010 and the OpenAccess version 2010_1_624.

    I have tested the 64 bit client using Oracle tools and the ODP client is working.

    But when I attempt to reverse map I run into the error:

    Attempt to load Oracle client libraries threw BadImapgeFormatException.  This problem will occur when runinng in 64 bit mode with the 32 bit Oracle Client installed.

    The only ODP cleint I have installed is the 64 bit version.  I have tried to have the config files point to my ODP rather than the microsoft cleint so: 

    <

     

     

    connectionStrings>

     

     

     

     

    add name="DatabaseConnection1" connectionString="data source=myServer;persist security info=True;user id=myuser;password=mypass" providerName="Oracle.DataAccess.Client" />

     

    </

     

     

    connectionStrings>

     

    <

     

     

    openaccess xmlns="http://www.telerik.com/OpenAccess">

     

    <

     

     

    references />

     

    <

     

     

    connections>

     

     

     

     

    <connection id="DatabaseConnection1">

     

    <

     

     

    databasename>myServer</databasename>

     

    <

     

     

    servername>-</servername>

     

    <

     

     

    connectionParams>useOracleTnsNames=true</connectionParams>

     

    <

     

     

    user>studsys</user>

     

    <

     

     

    password>onthur#</password>

     

    <

     

     

    backendconfigurationname>oracleConfiguration</backendconfigurationname>

     

    </

     

     

    connection>

     

     

     

     

    </

     

     

    connections>

     

    <

     

     

    backendconfigurations>

     

    <

     

     

    backendconfiguration id="mssqlConfiguration" backend="mssql">

     

    <

     

     

    mappingname>mssqlMapping</mappingname>

     

    </

     

     

    backendconfiguration>

     

    <

     

     

    backendconfiguration id="oracleConfiguration" backend="oracle">

     

    <

     

     

    mappingname>oracleMapping</mappingname>

     

    </

     

     

    backendconfiguration>

     

    </

     

     

    backendconfigurations>

     

    <

     

     

    mappings current="oracleMapping">

     

    <

     

     

    mapping id="oracleMapping" />

     

    </

     

     

    mappings>

     

    </

     

     

    openaccess>

    But I can't get past the error.  My queston is first,  Will Open Access work in a 64 bit environment with Oracle?  Second, if it can, what am I missing as far as configuration?

     

  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 06 Jul 2010 Link to this post

    Hi Smithgar,
    OpenAccess works with oracle 64 bit clients. But the wizards inside VisualStudio does not. Visual Studio is a 32 bit application hosting only a 32 bit .NET VM. This is not nice for us developers. The problem is the path to the oracle native dlls. If you start VS you should point to the 32 bit directory, if you start the application in 64 bit mode you should point to the 64 bit folder. Maybe a script around the VS start does the job.

    We have decided to always use the 32 bit client on our developer machines and the 64 bit client on our test machines.

    All the best,
    Jan Blessenohl
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
Back to Top