How to make a connection between Oracle 11 and ASP.NET?

Recommended Answers

Im not the best to provide advice concerning Oracle, but I had a small project where there was an Oracle DB rather than MS SQL and this was the connection string I used to connect to Oracle without any issue.

<connectionStrings>
  <add name="ORACLE" connectionString="Provider=MSDAORA;Data Source=dbName;Persist Security Info=True;User ID=userid; Password=pwd"/>
</connectionStrings> …
Jump to Post

All 2 Replies

Im not the best to provide advice concerning Oracle, but I had a small project where there was an Oracle DB rather than MS SQL and this was the connection string I used to connect to Oracle without any issue.

<connectionStrings>
  <add name="ORACLE" connectionString="Provider=MSDAORA;Data Source=dbName;Persist Security Info=True;User ID=userid; Password=pwd"/>
</connectionStrings>

Microsoft OLE DB Provider for Oracle

Hope this helps or points you in the right direction.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.