Member Avatar for Dukester

Having problems with connecting to an Oracle database, getting an error : Unrecognized attribute 'providerName' - Defined in web config : [<add key = "connection" value="Provider=MSDAORA;Data Source=TNSnames definition;Persist Security Info = True;Password=pass;user id =userid;" providerName="System.Data.OleDb"/>]

program imports:

[Imports System.Data.OracleClient
Imports System.Data
Imports System.Data.OleDb
Imports System.Configuration
Imports System.Object]

help please...:0)

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by apegram
Member Avatar for apegram

providerName is an attribute you can use on a connection string item in Web.Config. However, it looks like you are using appSettings instead.

<appSettings>
      <!-- your app settings -->
</appSettings>
<connectionStrings>
      <add name="theConnectionName" connectionString="yourConnectionString" providerName="yourProvider"/>
</connectionStrings>

(connectionStrings were introduced with 2.0, so if you're working with a 1.1 app, you'll need to stick with using appSettings.)

Be a part of the DaniWeb community

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