Apparently VS 2008 and 2010 do not support MSDORA.1 in the 64-bit environment, so I need to move the the Oracle Provider. I've downloaded and installed the Oracle 11g provider packages successfully, but am unsure as to how to incoroporate it into the VB connection string. The following is the 32-bit Microsoft provider code:
Public strConnection As String = "Provider=MSDAORA.1;password=xxxx;user id=xxx;data source=xxxxxxx"
Public cnConn As OleDbConnection = New OleDbConnection(strconnection)
Public dscmd As New OleDbDataAdapter(strSelect, cnConn)
Public cmdresults As Boolean
Just replacing "MSDAORA.1" with "OraOLEDB" does not work.
[OS is Windows 7 Pro 64x, Visual Studio 2008 and 2010]
VS2008 doesn't install MSDAORA btw, it comes with the operating system, and only comes in 32 bit flavor (there is no 64 bit msdaora).
Anyway, what do you have targetCPU set to in the project properties? VS2008 defaults to AnyCPU, VS2010 defaults to x86.
If it's AnyCPU, it will run as a 64 bit process, so you'll need 64 bit oracle client software installed. Or, switch it to x86 and it will run as a 32 bit process and work with your 32 bit client install (and msdaora for that matter).