i have an app in asp.net which is connecting to a oracle database with a oledbconnection Dim m As New OleDb.OleDbConnection("Data Source=...;Persist Security Info=True;User ID=...;Password=.........;Unicode=True;Provider=MSDAORA")
I developed with visual studio on a 32bit windows xp and when i debug my application everything is working fine.
Now i moved my app on a windows server 2008 64 bit version and implemented my app with iis 7.0
Now the problem is, everytime i start the app in my browser i get the following error: System.InvalidOperationException: The 'MSDAORA' provider is not registered on the local machine
The connection to oracle can't be the fault. I can connect to oracle with sqlplus.
What is the error? What am I doing wrong?
Thanks for the help
Edited by: user8846585 on 29.01.2010 03:30
MSDAORA doesnt have a 64 bit version. You'll need to either switch the app to 32 bit and use a 32 bit Oracle client, or use a 64 bit client and oledb provider instead (Ie, Oracle's provider - ORAOLEDB.ORACLE)
Hope it helps,
You can download from here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
The simplest change is in the connection string for your application. If you're lucky, no other changes will be required. Need to do testing to verify that for your code though. :)