Installing Oraoledb.oracle
I am moving a simple.NET application from 32-bit windows to 64-bit windows. I already had a lot of fun setting up my connection to Oracle after installing the Oracle client 9i because it will not connect if there are parentheses in the PATH variable. So I am currently launching Visual Studio 2005 from DOS. Using server explorer I can set up a connection to the Oracle instance and see the contents just fine. I am connecting with OleDbConnection and send a Connection String beginning with 'Provider=MSDAORA; When I run I catch the following exception: System.InvalidOperationException: The 'MSDAORA' provider is not registered on the local machine.
Canon utilities camerawindow. That sounds like the driver was not installed. But then why can I use the driver in Server Explorer.
David Kaiser. I ran into the same problem - Recompiling the project with x86 will work.
Oracle Provider for OLE DB. OraOLEDB System Requirements. Instructions for Installing Oracle Provider for OLE DB. I'm trying to add an Oracle server as a linked server to SQL Server. I've downloaded and installed Oracle's instant client and ODAC software. However, OraOLEDB.Oracle.
Installing Oracle 11g
Oraoledb Download
My connection string - objConnection = New OleDbConnection objConnection.ConnectionString = 'Provider=MSDAORA.1;User ID=' & System.Configuration.ConfigurationManager.AppSettings( 'USERID' ) & ';PASSWORD=' & System.Configuration.ConfigurationManager.AppSettings( 'PASSWORD' ) & ';Data Source=' & System.Configuration.ConfigurationManager.AppSettings( 'DATASOURCE' ) & ' objConnection.Open let me know if you still have problems. Alternatively, oracle 8 (or 9i) has x64 based client drivers if you want your application to compile against x64 on x64. thanks sriram.