Connecting to Oracle using 64bit ODP Client

[Smithgar]

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?

 

[Jan Blessenohl]

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