<addname="Odbc
Data Provider"invariant="System.Data.Odbc"description=".Net
Framework Data Provider for Odbc"type="System.Data.Odbc.OdbcFactory,
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<addname="OleDb
Data Provider"invariant="System.Data.OleDb"description=".Net
Framework Data Provider for OleDb"type="System.Data.OleDb.OleDbFactory,
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<addname="OracleClient
Data Provider"invariant="System.Data.OracleClient"description=".Net
Framework Data Provider for Oracle"type="System.Data.OracleClient.OracleClientFactory,
System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<addname="SqlClient
Data Provider"invariant="System.Data.SqlClient"description=".Net
Framework Data Provider for SqlServer"type="System.Data.SqlClient.SqlClientFactory,
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<addname="IBM
DB2 .NET Data Provider"invariant="IBM.Data.DB2"description="IBM
DB2 Data Provider for .NET Framework 2.0"type="IBM.Data.DB2.DB2Factory,
IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<addname="IBM
Informix .NET Data Provider"invariant="IBM.Data.Informix"description="IBM
Informix Data Provider for .NET Framework 2.0"type="IBM.Data.Informix.IfxFactory,
IBM.Data.Informix, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<addname="IBM
DB2 .NET Data Provider 9.5.0"invariant="IBM.Data.DB2.9.5.0"description="IBM
DB2 Data Provider 9.5.0 for .NET Framework 2.0"type="IBM.Data.DB2.DB2Factory,
IBM.Data.DB2.9.5.0, Version=9.5.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<addname="IBM
Informix .NET Data Provider 9.5.0"invariant="IBM.Data.Informix.9.5.0"description="IBM
Informix Data Provider 9.5.0 for .NET Framework 2.0"type="IBM.Data.Informix.IfxFactory,
IBM.Data.Informix.9.5.0, Version=9.5.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<addname="SQL
Server CE Data Provider"invariant="Microsoft.SqlServerCe.Client"description=".NET
Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition"type="Microsoft.SqlServerCe.Client.SqlCeClientFactory,
Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<addname="Microsoft
SQL Server Compact Data Provider"invariant="System.Data.SqlServerCe.3.5"description=".NET
Framework Data Provider for Microsoft SQL Server Compact"type="System.Data.SqlServerCe.SqlCeProviderFactory,
System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
</system.data>
My Machine.config.txt under 4.0 framework has this:
<addname="IBM
DB2 for i5/OS .NET Provider"invariant="IBM.Data.DB2.iSeries"description=".NET
Framework Data Provider for i5/OS"type="IBM.Data.DB2.iSeries.iDB2Factory,
IBM.Data.DB2.iSeries, Version=12.0.0.0, Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26"/>
<addname="Microsoft
SQL Server Compact Data Provider"invariant="System.Data.SqlServerCe.3.5"description=".NET
Framework Data Provider for Microsoft SQL Server Compact"type="System.Data.SqlServerCe.SqlCeProviderFactory,
System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
<DbProviderFactories/>
Can anyone explain the decrepancy here? Is 2.0 conflicting with 4.0? Can really use the help, thanks!
It turns there was a extra <DbProviderFactories/> closing Node, not sure why this was generated this way. But from what I understand this is a common error migrating from .NET 2.0 to 4.0. This issue is resolved, now I just got figure out why my the connection
is failing when I try to create a database. It seems to be timing out...
I'm curious about this problem and I know it's almost a year that has gone by but wondering if you can point me to where you found other examples of this machine.config problem. Thanks! I'll keep looking in the meantime.
Pito289
Member
16 Points
9 Posts
Error: The DBProviderFactories section can only appear once per config file.
Dec 09, 2011 09:52 PM|LINK
I've been looking into this issue for awhile, and I can't seem to find the underlying issue.
My Machine.config.txt for framework 2.0 has this:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</DbProviderFactories>
</system.data>
The Machine.config.xml under 2.0 framework:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="IBM DB2 .NET Data Provider" invariant="IBM.Data.DB2" description="IBM DB2 Data Provider for .NET Framework 2.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<add name="IBM Informix .NET Data Provider" invariant="IBM.Data.Informix" description="IBM Informix Data Provider for .NET Framework 2.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<add name="IBM DB2 .NET Data Provider 9.5.0" invariant="IBM.Data.DB2.9.5.0" description="IBM DB2 Data Provider 9.5.0 for .NET Framework 2.0" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2.9.5.0, Version=9.5.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<add name="IBM Informix .NET Data Provider 9.5.0" invariant="IBM.Data.Informix.9.5.0" description="IBM Informix Data Provider 9.5.0 for .NET Framework 2.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix.9.5.0, Version=9.5.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
</system.data>
My Machine.config.txt under 4.0 framework has this:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.data>
<DbProviderFactories />
</system.data>
My Machine.config.xml under 4.0 framework has this:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.data>
<DbProviderFactories>
<add name="IBM DB2 for i5/OS .NET Provider" invariant="IBM.Data.DB2.iSeries" description=".NET Framework Data Provider for i5/OS" type="IBM.Data.DB2.iSeries.iDB2Factory, IBM.Data.DB2.iSeries, Version=12.0.0.0, Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26"/>
<add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/></DbProviderFactories>
<DbProviderFactories/>
Can anyone explain the decrepancy here? Is 2.0 conflicting with 4.0? Can really use the help, thanks!
Pito289
Member
16 Points
9 Posts
Re: Error: The DBProviderFactories section can only appear once per config file.
Dec 09, 2011 10:05 PM|LINK
It turns there was a extra <DbProviderFactories/> closing Node, not sure why this was generated this way. But from what I understand this is a common error migrating from .NET 2.0 to 4.0. This issue is resolved, now I just got figure out why my the connection is failing when I try to create a database. It seems to be timing out...
jlermanvt
Member
42 Points
7 Posts
Re: Error: The DBProviderFactories section can only appear once per config file.
Nov 28, 2012 07:10 PM|LINK
Hey Pito,
I'm curious about this problem and I know it's almost a year that has gone by but wondering if you can point me to where you found other examples of this machine.config problem. Thanks! I'll keep looking in the meantime.