0

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
3
Views
7 Years
Discussion Span
Last Post by apegram
0

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.)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.