DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VB.Net and Oracle Provider

445763Oct 5 2011 — edited Oct 11 2011

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]

Any help for this woud be appreciated.

Larry

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2011

Added on Oct 5 2011

#oracle-provider-for-ole-db, #windows-and-net

4 comments

2,922 views