.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Connecting to Oracle on 64bit OS

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
We have a 64-bit implementation of MOSS 2007. I recently installed the SharePoint SDK to use the Application Definition Designer to connect to Oracle. I enter the connection string and then I get this:

Attempt to load Oracle client libraries threw BadImageFormatException. The problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

I have verified that the server contains the 64 bit version of the Oracle client installed both with the instantclient and with system.data.oracleclient.dll. The only thing I can think of is that the tool was compiled as a 32bit application.  Is there a 64bit version available? Is there something else that I'm missing?

View Complete Post

More Related Resource Links

Timeout When Connecting From SSIS to Oracle

Hello Forum I've been tasked with building a replacement SQL Server that extracts data from Oracle and publishes it to a Third Party.  The new Server is of a higher spec than the existing SQL Server and the Server in question is not performing any other role. The Network config between the two SQL Servers is identical; Firewalls are also configured correctly.  Both Servers are using the same Switch. However when I attempt to replicate the DTS Packages and SSIS, i'm getting a Timeout problem when Management Studio is attempting to populate the list of Objects from Oracle.  Is there anything from a SQL Perspective that could be causing the issues? New Server is SQL Server 2005 Standard Edition SP3.  Old Server is SQL Server 2000 Standard Edition SP4.Tony C

SSAS Connecting with Oracle.

Hi. I am running SQL Server 2008 on Windows 7 laptop.  I want to use it to connect to an Oracle database so that I may build cubes etc. So I downloaded and installed the ODAC from Oracle's download site - it included ODP.Net and the Instant Client. I have not configured anything any further but just open up BIDS, right click "Data Sources" -> "New Data Source". I have 4 options here when I click "New.." but each of them end up in the same error. OracleClient Data Provided Oracle Data Provider for .NET Microsoft OLE DB Provider for Oracle Oracle Provider for OLE DB When I click "Test Connection" the error pops up "Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified". I can't get any further than this. Can anyone see what I am doing wrong? David.

64bit MSDAORA.DLL for Oracle Connectivity

Hi, I have an 64 bit machine with 2008R2 Enterprise Edition SQL Server. InOrder to connect to Oracle, I need MSDAORA 64 bit version DLL to get registered. Where can i download this DLL and how to register it. Please let me know ASAP, Thanks in Advance. Srini..

Connecting to Oracle on 64-bit (x64) machine


Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine?

"Test connection failed because of an error in initializing provider. ORA-06413: Connection not open"

The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully.

On both machines I have SSIS RTM, Oracle 9.2 and using the Microsoft Ole Db Provider for Oracle.

- Joel

MS Access on windows 7 not connecting to ODBC oracle driver


1.I added oracle driver using odbc admin. This dsn is displaying in MS access windows 7 , but failed in connecting.The following message displayed

ODBC - call failed.

[microsoft)[odbc driver manager] data source name not found and default driver not specified(#0).

2. why the oracle 11g driver is not displayed in create new data source driver's list when exporting from MsAccess on windows 7.


 in advance.



Problems Connecting Excel Services to Oracle Database


I am just beginning to experiment with using Excel Services with BI Dashboards in SharePoint 2010.  I created a Excel Workbook that has a data connection using connection type of OLE DB Query with a connection string of "Provider=MSDAORA.1;User ID=<username>;Data Source=<oracleEnvironment>".  I have the Excel Services Authentication Settings set up for a specific SSS ID <mySSSID>.


This Excel Workbook has been Saved to SharePoint with an entire sheet published.  The Excel Web App is displaying the sheet and the Slicers are functioning just like they do in the Excel client.  When I refresh the data on the client I get prompted for a password and it works fine.  When I refresh on the Web App I have received a variety of errors depending on what I try but nothing has helped me track down what I have missed.

VisualStudio 2008 64bit in windows 2008 r2 64 bit oracle does not connect to databas



I am currently using visualstudio 2008 with 3.5 framework sp1 release.

We want to migrate our applications to the new server everything as a 64 bit. which is having the following configuration 

windows 2008 server  R2 64 bit with Oracle as backend.

We donot have any 32 bit oracle client tools installed.I am able to connect to the database by using a console/windows/class library applications

When I try to simply connect to the database(open and close the connection) using either a website or a webapplication.I am getting the following different types of exceptions

Oracle client and networking components were not found. These components
are supplied by Oracle Corporation and are part of the Oracle version
7.3.3 or later client software installation.

Provider is unable to function until these components are installed.
Attempt to load Oracle client libraries threw BadImageFormatException.
This problem will occur when running in 64 bit mode with the 32 bit
Oracle client components installed.

Sql Server 2008 (64bit) on Windows Server 2008 with a connection to Oracle 10g (64bit)



I know there are similar questions posed but none that provided a solution to my particular problem.

I am upgrading a SSIS package from Sql Server 2005 (32bit) to Sql Server 2008 (64bit) on Windows Server 2008 R2. It worked on the Sql Server 2005 machine. This package connects to an Oracle 10g (64bit) database.

The Oracle 11g client and networking tools are installed (by the Oracle DBA). I tested my connection on the sql server 2008 machine using SqlPlus and doing a tnsping. I can also create a Windows ODBC datasource connection to the Oracle 10g database.

The package executes properly on my local computer XP (32bit) running bids 2008.

The package fails on the server in SSIS. I need to be able to schedule the package in a job so it must run in SSIS.

I have also tired to create a connection manager to the Windows ODBC oracle connection without success. It is blank and does not allow me to select or refresh to view the Windows ODBC datasources.

Any assistance would be greatly appreciated. I have seen other forums where installing the Oracle 11g ODAC and Oracle Developer Tools for Visual Studio might assist in creating the package. But I need assistance in running the package from SSIS and not BIDS.






Problem in connecting to oracle database,which is using Provider=MSDAORA.1


Hi I am Naveen, I am upgrading a internal website from .Net 1.1 to .Net2.0 in Vb.

The database is deployed in the server, but i could not connect to that database.

i have to connect database to few drop down lists,

my manager has given connection string to me... i have placed it in web.config and given that link properly in the code..

but the database is not connecting.. the list is showing empty..

my conn string is

<add key="D2" value="Provider=MSDAORA.1;Data Source=baan; User ID=xxxx; Password=xxxx;Persist Security Info=True"/>

can anyone help me,,, thanks in advance...

problem in connecting .net 2010 to oracle 10g via ODAC 11


hello everyone!!
i m trying to use ODAC 11 with vs2010 and oracle 10G. After installation i am able to connect the vs2010's server explorer with oracle 10G using ODAC. the thing is when i try to drag the table directly on windows application or web form, it does nothing. there is no way possible to connect any application to the database. i strongly feel that my installation is incomplete. I changes the parameters in tnsname.ora. the only thing i left in installation is executing some sql scripts after installation that are present in "C:\app\dellid\product\11.2.0\client_1\ASP.NET\SQL" folder.
Plz help



Connecting to MS SQL Server database using webmatrix.



I am novice  user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.

The connection string that i setup as follows.

<?xml version="1.0"?>


        <compilation debug="false" targetFramework="4.0" />
    <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />


And i am using websecurity helper as well and the setup is as follows.

WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);

When i am trying to insert the user details into database i am getting the below error.

Format of t

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

Help with connecting to SqlExpress 2005 remotely


So I've intalled SQL 2005 Express and Sql Server Management Studio Express (SSMSE). I don't have any problems connecting to it using Windows authentication. But I would like to set it up so that I can log in using Sql Server Authentication with a username and password.

My Problem

But I'm getting an error message of "A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0- No process is on the other end of the pipe) (Microsoft SQL Server, Error: 233).

What I've done

I've created a new "Login" in the Security node. Provided all necessary role access level. Granted permission to connect to database and enabled login.

I've used the Sql Server Surface Area Configuration to set the Remote Connection type to "Using TCP/IP only" or "Using Both TCP/IP and named pipes" (tried both, but in either situation I get the same error message when attempting to login to SSMSE with the user name and password). I also made sure to restart the service.

What do I need to do to fix this problem? 

ASP.Net connect to Oracle.


 We have an application which uses  'System.Data.OracleClient'. On the box it was developed we can change the TNSNAMES.ORA entries to connect to different oracle databases. Moving the code to a  Microsoft Server 2008 box it would appear that the application ignores the TNSNAMES.ORA file. It has cached the first Oracle connection and will now work without any TNSNAMES.ORA file. Where is it getting the connection? We have set tns_admin to point at the TNSNAMES.ORA file. We can tnsping the connection OK.

access Oracle database


Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?

Thank you.

Problems connecting stored procedure to Crystal Reports


I am working on updating a reporting system that uses Crystal Reports.  All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location.  All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location.  The reason I need to update the location is so that the .NET application will use the correct driver.  Everything has worked fine up until I got to one stored procedure.  The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.

First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report.  It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure.  Then I get the following error:

Query Engine Error: 'ADO Error Code: 0x
Source: OraOLEDB
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'

The proce

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend