0

I am trying to add database through server explorer. I have installed DDEX and ADO.NET, then in Visual studio in project I added SqlClient via NuGet. When I go to Server Explorer > Connect to Database > Firebird Data Source, and then I start typing, on first input the window just closes.

I tried changing versions in machine.config, deleting multi lines in machine.config but nothing is working. I also tried reinstalling everything (except Visual Studio) but it is still not working.

Here is my spec:

  • Windows 10
  • Visual Studio 2015
  • Firebird 3.0
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Parpil
  • 129
  • 2
  • 10

2 Answers2

2

This happens when you have several Firebird .net provider entries in the machine.config. The Installer doesn't remove them.

So run noptepad as admin, open the file C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

and make sure that under the <DbProviderFactories> node you only see 1 entry:

<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=5.6.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

It can also happen if you have a version missmatch from the referenced Firebird provider version and the one you have installed via MSI. Both must be the same version. If you have installed 5.6 via MSI installer, also install the 5.6 packages via NuGet.

magicandre1981
  • 27,895
  • 5
  • 86
  • 127
-1

I do not know what was the problem. I reinstalled windows and it is working now :)

Thanks anyway :)

Parpil
  • 129
  • 2
  • 10