Error creating the forms database - ADO.NET provider with invariant name 'System.Data.SqlClient' is either not registered

replied on February 21, 2017

Please check whether this post helps: http://www.san2debug.net/post/Resolved-Unable-to-find-the-requested-Net-Framework-Data-Provider.aspx, try modify following two config files.

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

1 0

replied on February 22, 2017

Thank-you for the information. I opened both config files and neither had an entry <DbProviderFactories/>. So I'm not sure where in the file I should add the following lines. Does it matter where in the file I paste this? Thanks

</DbProviderFactories>

0 0

replied on February 22, 2017

Look for a section like this:

    <system.data>
        <DbProviderFactories/>
    </system.data>

and replace <DbProviderFactories/> with the snippet in your post.

0 0

replied on February 22, 2017

Thanks Miruna,

I found the section and it already contains:

Should I do it this way?

<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" />
</DbProviderFactories>

</DbProviderFactories>

</system.data>

OR

<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" />

</DbProviderFactories>

</system.data>

OR Replace? And if I replace it could I be breaking something else?

<system.data>
<DbProviderFactories>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089""/>

</DbProviderFactories>

</system.data>

Thanks Sandy

0 0

SELECTED ANSWER

replied on February 22, 2017

The middle one, just add a new provider into DBProviderFactories.

0 0

replied on February 22, 2017

Thank-you!

0 0

Question

Question

Error creating the forms database - ADO.NET provider with invariant name 'System.Data.SqlClient' is either not registered

Answer

Replies

Sign in to reply to this post.