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

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

Connecting to Oracle on 64-bit (x64) machine

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

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

View Complete Post

More Related Resource Links

Connecting to Oracle on 64bit OS

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?

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.

Attempt to load Oracle client libraries threw BadImageFormatException from 64-bit machine.

We are receiving below error while connecting local ASP.NET site to Oracle server from 64-bit Win2k3 machine.  (System.InvalidOperationException: 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. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)) One strange thing is that from same machine, if we connect through local SharePoint site, it connects well to oracle.  Please help...

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.

Connecting to the server machine failed.


Hello, I got an error message while I log in to my VS 2005 app.

I was logging in to my app, but my app always takes me back to log on page, so I set a break point at 'If Not (HttpContext.Current.User Is Nothing) Then' to see if the HttpContext.Current.User is Nothing.

After I clicked log in button, my app was processing a while then pop up the error message.

The error message is:

Unable to automatically step into the server. Connecting to the server machine 'xxx' failed. The debugger cannot connect to the remote computer. This may be because the remote computer does not exist or a firewall may be preventing communication to the remote computer. Please see Help for assistance.

My app doesn't have any codes to ask connecting the server machine xxx  and it is not suppose to connect to a remote server; and I don't know what xxx is for.

Does anyone could give me a suggestion to solve this issue?

Thank you all.

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...

report builder without oracle client installation on client machine


I have a situation, i have SQL Server 2008 R2 and i need to run report builder 3.0 on client machine and need to use oracle data source but i don't have oracle client installation at client machine.

How we can use report builder without oracle client installation at client’s machine.

Problem connecting to report server from client machine


We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.
Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.
We are using SQL Server 2008 on Windows 7.
Thanks a lot

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



OLE DB provider : The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.



Getting following error while trying to connect to ORACEL database using OLEDB manager.

Please advice.


TITLE: Microsoft Visual Studio

Error at RADAR [Connection manager "RADAR_Updated"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider OraOLEDB.Oracle.1 is not registered. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Error at DFT LOAD AGGTYPE TABLE [RADAR AGG TYPE [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "RADAR_Updated" failed with error code 0xC0209302.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.


Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)



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 !    

Need help using control adapters at the machine level

Hi guys!

Let me explain our situation. I do web development at a university at which we have to meet strict accessibility guidelines. I've specially modified the adapters (as well as extended CompositeDataBoundControlAdapter to include GridView) for use on our site and to use with our global stylesheets as well as compiled the control adapters into a DLL.

The control adapters now all reside in the WebServices.CssFriendlyAdapters DLL.  (For example, WebServices.CssFriendlyAdapters.GridViewAdapter).

Currently, when someone drops an App_Browsers folder in to their site with the adapters specified, the adapters work. However, we'd like to be able to specify this in the C:\WINDOWS\Microsoft.NET\Framework\(version number)\CONFIG\Browsers directory so that the adapters work automatically without anyone having to move anything into App_Browsers for every site. To ensure that someone can still use the "old way" or will not be confused by their controls being adapted, I've written in code that uses the base rendering methods unless xhtmlConformance is set to "Strict" in the site's web.config file.

Anyway, on to the problem. When trying to compile the controlAdapters into the C:\WINDOWS\Microsoft.NET\Framework\(version number)\CONFIG\Browsers directory using aspnet_regbrowsers.exe (see http://msdn2.microsoft.com/en-us/library/ms229858.a

{ End Bracket }: The Emergence Of Machine Translation


Vikram Dendi looks at how machine translation is poised to change the world and why it is so important to deliver information in multiple languages.

Vikram Dendi

MSDN Magazine January 2009

{ End Bracket }: Microsoft Java Virtual Machine Update


In a settlement agreement reached in January 2001 to resolve a dispute over the Microsoft distribution of its Java implementation, Sun Microsystems and Microsoft agreed to limit the duration of the time Microsoft would use Sun's source code and compatibility test suites to support the Microsoft® Java Virtual Machine (MSJVM).

Brian Keller

MSDN Magazine October 2004

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