firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

Okay I think you were talking about the machine.config entry in system.data.DbProviderFactories:

I have the following entry in it:
<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=3.2.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

I have tried to replace this with the FbProviderServices like you said to do so in my app.config, but it didnt make a difference still the same error message.

From: ran...@ou...
To: fir...@li...
Date: Tue, 22 Oct 2013 11:31:46 +0000
Subject: Re: [Firebird-net-provider] DbProviderServices




Sorry for my late reply.

I have exchanged the config line as you mentioned,

so instead of
<provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/>

I have:
<provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />

But I am now getting the same error just mentioning the "FbProviderServices":

The 'Instance' member of the Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

You said:
And I suppose you have proper record in DbProviderFactories.

Didnt really understand, what you mean ?

If you meant the appconfig, that I am missing something here is my full app.config:

<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1"/>
  </startup>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>
</configuration>

Thanks for your help up till now.


> Date: Tue, 22 Oct 2013 12:50:20 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> On Tue, Oct 22, 2013 at 11:25 AM, Rand Random <ran...@ou...> wrote:
> > <provider invariantName="FirebirdSql.Data.FirebirdClient"
> > type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
> > FirebirdSql.Data.FirebirdClient" />
> 
> Now I see it. This line is wrong. It should be
> <provider invariantName="FirebirdSql.Data.FirebirdClient"
> type="FirebirdSql.Data.FirebirdClient.FbProviderServices,
> FirebirdSql.Data.FirebirdClient" />
> 
> And I suppose you have proper record in DbProviderFactories.
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider 		 	   		  

Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

Sorry for my late reply.

I have exchanged the config line as you mentioned,

so instead of
<provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/>

I have:
<provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />

But I am now getting the same error just mentioning the "FbProviderServices":

The 'Instance' member of the Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

You said:
And I suppose you have proper record in DbProviderFactories.

Didnt really understand, what you mean ?

If you meant the appconfig, that I am missing something here is my full app.config:

<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.1"/>
  </startup>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>
</configuration>

Thanks for your help up till now.


> Date: Tue, 22 Oct 2013 12:50:20 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> On Tue, Oct 22, 2013 at 11:25 AM, Rand Random <ran...@ou...> wrote:
> > <provider invariantName="FirebirdSql.Data.FirebirdClient"
> > type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
> > FirebirdSql.Data.FirebirdClient" />
> 
> Now I see it. This line is wrong. It should be
> <provider invariantName="FirebirdSql.Data.FirebirdClient"
> type="FirebirdSql.Data.FirebirdClient.FbProviderServices,
> FirebirdSql.Data.FirebirdClient" />
> 
> And I suppose you have proper record in DbProviderFactories.
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

Re: [Firebird-net-provider] DbProviderServices

[Jiri C. <di...@ci...>]

On Tue, Oct 22, 2013 at 11:25 AM, Rand Random <ran...@ou...> wrote:
> <provider invariantName="FirebirdSql.Data.FirebirdClient"
> type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
> FirebirdSql.Data.FirebirdClient" />

Now I see it. This line is wrong. It should be
<provider invariantName="FirebirdSql.Data.FirebirdClient"
type="FirebirdSql.Data.FirebirdClient.FbProviderServices,
FirebirdSql.Data.FirebirdClient" />

And I suppose you have proper record in DbProviderFactories.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DbProviderServices

[Jiri C. <di...@ci...>]

Check gacutil. And also procmon will tell you what's loading and from where.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

Cant get it running...

I have cleared all debug folders from ddls, done a clean solution, replaced the dlls that gets installed from the .msi package under C:\Program Files (x86)\FirebirdClient with the once downloaded from there NETProvider-3.2.0.0-NET45_EF6.7z, also replace the dlls from the nuget package and still the same result.
Also looked in C:\windows\assembly and there is no firebirdclient ddl registered.

So currently I am kinda clueless, what to check next... do you have some hints?
Or would you rather have a teamviewer session and have a look for yourself?

> Date: Tue, 22 Oct 2013 12:00:33 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> On Tue, Oct 22, 2013 at 11:52 AM, Rand Random <ran...@ou...> wrote:
> > I have the NETProvider-3.2.0.0.msi and DDEXProvider-3.0.0.0.msi installed,
> > is it recommended to deinstall them and losing the feature of modeling the
> > EDMX in VS?
> 
> If you're using VS2013 and EF6 you need EF6 provider. DDEX can be left
> untouched.
> 
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

Re: [Firebird-net-provider] DbProviderServices

[Jiri C. <di...@ci...>]

On Tue, Oct 22, 2013 at 11:52 AM, Rand Random <ran...@ou...> wrote:
> I have the NETProvider-3.2.0.0.msi and DDEXProvider-3.0.0.0.msi installed,
> is it recommended to deinstall them and losing the feature of modeling the
> EDMX in VS?

If you're using VS2013 and EF6 you need EF6 provider. DDEX can be left
untouched.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

I have the NETProvider-3.2.0.0.msi and DDEXProvider-3.0.0.0.msi installed, is it recommended to deinstall them and losing the feature of modeling the EDMX in VS?

> Date: Tue, 22 Oct 2013 11:42:49 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> On Tue, Oct 22, 2013 at 11:35 AM, Rand Random <ran...@ou...> wrote:
> > And how can I load the EF6 version of provider, when I look at my references
> > in solution its telling me the correct path to the NuGet Package.
> 
> Probably you have other version somewhere. Maybe GAC, bin, ...
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

Re: [Firebird-net-provider] DbProviderServices

[Jiri C. <di...@ci...>]

On Tue, Oct 22, 2013 at 11:35 AM, Rand Random <ran...@ou...> wrote:
> And how can I load the EF6 version of provider, when I look at my references
> in solution its telling me the correct path to the NuGet Package.

Probably you have other version somewhere. Maybe GAC, bin, ...

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

And how can I load the EF6 version of provider, when I look at my references in solution its telling me the correct path to the NuGet Package.

"...\packages\FirebirdSql.Data.FirebirdClient-EF6.3.2.0.0\lib\net45\FirebirdSql.Data.FirebirdClient.dll"

> Date: Tue, 22 Oct 2013 11:32:26 +0200
> From: di...@ci...
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] DbProviderServices
> 
> You're not loading EF6 version of provider.
> 
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

Re: [Firebird-net-provider] DbProviderServices

[Jiri C. <di...@ci...>]

You're not loading EF6 version of provider.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] DbProviderServices

[Rand R. <ran...@ou...>]

I was asked by Jiri Cincura to write my question here on the list, so here am I now:

(From here on its a copy from my initial issue on the tracker from firebird - notice that the link to the tracker doesnt work because the related issue got deleteb by Jiri)

Key: DNET-525
                 URL: http://tracker.firebirdsql.org/browse/DNET-525
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.2.0.0
         Environment: Win7 - EF 6 - .Net Provider 3.2.0.0 - Firbird 2.5 - Visual Studio 2013
            Reporter: Rand Random
            Assignee: Jiri Cincura


I am getting following error message:

The 'Instance' member of the Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

I probably did something wrong but dont know what...

I am currently trying to update my VS 2012 + EF 5 Solution to the latest VS 2013 and EF 6.0.0.1 Versions, everything went smoothly and I am able to build the solution.
During the update I noticed that the .Net Provider is also availabe in a NuGet package, and got my latest version for EF 6 from there. (Yeah I noticed that there are 2 different NuGet packages and picked the one saying "Firebird ADO.NET Data provider (Entity Framework 6).

When I tried to run the application a very simple linq query resulted to an exception telling me that the provider isnt configured in the app.config.
So I extended the default config from

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>

to 

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>

After this the excpetion was gone and a new one appeard - the one mentioned at the very top.

So what am I doing wrong and how can I tell my solution to use the DLL for EF 6?
 		 	   		  

[Firebird-net-provider] [FB-Tracker] Created: (DNET-525) DbProviderServices

[Rand R. (JIRA) <tr...@fi...>]

DbProviderServices
------------------

                 Key: DNET-525
                 URL: http://tracker.firebirdsql.org/browse/DNET-525
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.2.0.0
         Environment: Win7 - EF 6 - .Net Provider 3.2.0.0 - Firbird 2.5 - Visual Studio 2013
            Reporter: Rand Random
            Assignee: Jiri Cincura


I am getting following error message:

The 'Instance' member of the Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c' did not return an object that inherits from 'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework providers must inherit from this class and the 'Instance' member must return the singleton instance of the provider. This may be because the provider does not support Entity Framework 6 or later; see http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

I probably did something wrong but dont know what...

I am currently trying to update my VS 2012 + EF 5 Solution to the latest VS 2013 and EF 6.0.0.1 Versions, everything went smoothly and I am able to build the solution.
During the update I noticed that the .Net Provider is also availabe in a NuGet package, and got my latest version for EF 6 from there. (Yeah I noticed that there are 2 different NuGet packages and picked the one saying "Firebird ADO.NET Data provider (Entity Framework 6).

When I tried to run the application a very simple linq query resulted to an exception telling me that the provider isnt configured in the app.config.
So I extended the default config from

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>

to 

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </providers>
  </entityFramework>

After this the excpetion was gone and a new one appeard - the one mentioned at the very top.

So what am I doing wrong and how can I tell my solution to use the DLL for EF 6?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Pierre A. <pie...@op...>]

It is a good thing to know that it should work :-)

And yes: I have access to the database file, and it is being used concurrently by other application threads.

I will continue to investigate the issue when I get back to the office in a few days. Thanks for your support.

Pierre

> Le 21 oct. 2013 à 09:47, Jiri Cincura <di...@ci...> a écrit :
> 
>> On Sun, Oct 20, 2013 at 10:40 PM, Pierre Arnaud <pie...@op...> wrote:
>> It's an FbException wrapping an IscException with the following message:
>> 
>>  I/O error during "CreateFile (open)" operation for file
>>  "C:\PROGRAMDATA\FOO\BAR.FIREBIRD"
>>  Error while trying to open file
> 
> Well, this is more or less generic error. Do you have access to that path?
> 
>> and if I watch what happens with ProcMon.exe, I see that there is an
>> attempt to open the database file, which fails because of a sharing
>> issue.
> 
> I don't know what you mean by "sharing", but once you have results
> from procmon you can see why exactly the operation failed.
> 
>> What I find suspect, is the fact that calling FbBackup the first time
>> seems to load fbembed.dll and various other related files; however, all
>> these files have already been loaded previously.
> 
> It doesn't matter. But you can always try to do backup (just for test)
> before any other operation.
> 
>> Should this work with the embedded server? Might I have an issue of DLL
> 
> Yes.
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Jiri C. <di...@ci...>]

On Sun, Oct 20, 2013 at 10:40 PM, Pierre Arnaud <pie...@op...> wrote:
> It's an FbException wrapping an IscException with the following message:
>
>   I/O error during "CreateFile (open)" operation for file
>   "C:\PROGRAMDATA\FOO\BAR.FIREBIRD"
>   Error while trying to open file

Well, this is more or less generic error. Do you have access to that path?

> and if I watch what happens with ProcMon.exe, I see that there is an
> attempt to open the database file, which fails because of a sharing
> issue.

I don't know what you mean by "sharing", but once you have results
from procmon you can see why exactly the operation failed.

> What I find suspect, is the fact that calling FbBackup the first time
> seems to load fbembed.dll and various other related files; however, all
> these files have already been loaded previously.

It doesn't matter. But you can always try to do backup (just for test)
before any other operation.

> Should this work with the embedded server? Might I have an issue of DLL

Yes.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Pierre A. <pie...@op...>]

> > Calling FbBackup.Execute throws the exception because of the sharing
> > violation.
> 
> What's the message exactly?

It's an FbException wrapping an IscException with the following message:

  I/O error during "CreateFile (open)" operation for file
  "C:\PROGRAMDATA\FOO\BAR.FIREBIRD"
  Error while trying to open file

and if I watch what happens with ProcMon.exe, I see that there is an
attempt to open the database file, which fails because of a sharing
issue.

What I find suspect, is the fact that calling FbBackup the first time
seems to load fbembed.dll and various other related files; however, all
these files have already been loaded previously.

Should this work with the embedded server? Might I have an issue of DLL
hell where two instances of the embedded server somehow get loaded?

Pierre

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Jiri C. <di...@ci...>]

On Sun, Oct 20, 2013 at 9:02 PM, Pierre Arnaud <pie...@op...> wrote:
> Calling FbBackup.Execute throws the exception because of the sharing
> violation.

What's the message exactly?


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Pierre A. <pie...@op...>]

> You mean FbBackup?

Ah, yes, sorry. The interface IDbServiceTools.Backup is not part of
the .NET Provider, but part of one of our DB layers.

We are calling FbBackup.Execute with just one path in BackupFiles, a
ConnectionString which specifies the Embedded server type and as the
Options, just 'IgnoreLimbo', verbose set to true and a callback set
on the ServiceOutput event.

Calling FbBackup.Execute throws the exception because of the sharing
violation.

Pierre


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

----------------------------------------------------------------------------
--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Backup with fbembed cannot open database file

[Jiri C. <di...@ci...>]

You mean FbBackup?


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] Backup with fbembed cannot open database file

[Pierre A. <pie...@op...>]

Hello,

We had been using successfully IDbServiceTools.Backup with the Embedded
Firebird DLL. For some time now, and with no apparent reason (i.e. we
cannot figure out what changed in our source control tracking system),
the backup fails with a sharing violation, when the backup tries to
open the database file.

Has anything changed with respect to how the database file is opened
by the .NET Provider? Or how the backup opens the file itself?

What information could help me track the source of this issue?

Environment:

- .NET Provider 3.2.0.0
- Firebird SQL Server (Embedded) 2.5.2.26539
- .NET 4.0
- Windows x64 (7 or Server 2013)

Pierre

Re: [Firebird-net-provider] NullReferenceException in my web service application

[Jiri C. <di...@ci...>]

You should first update to 3.2.0.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] NullReferenceException in my web service application

[Halim B. <hbo...@id...>]

We are getting the following error which causes our web service application
to crash.

We use c# with Visual Studio 2012. Our Firebird Client ADO.NET provider
version is 3.0.2.0.

. I found several topics regarding this error and made me more confused.

Could you help me figure it out please or at least keep my application from
crashing? Thank you,



Exception: System.NullReferenceException



Message: Object reference not set to an instance of an object.



StackTrace:    at
FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction() in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
789

   at FirebirdSql.Data.FirebirdClient.FbCommand.Release() in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
827

   at FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing)
in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
395

   at System.ComponentModel.Component.Finalize()

[Firebird-net-provider] NullReferenceException in my web service application

[Halim B. <hal...@ho...>]

We are getting the following error which
causes our web service application to crash.

We use c# with Visual Studio 2012. Our
Firebird Client ADO.NET provider version is 3.0.2.0.

. I found several topics regarding this
error and made me more confused.

Could you help me figure it out please or
at least keep my application from crashing? Thank you,

 

Exception: System.NullReferenceException

 

Message: Object reference not set to an
instance of an object.

 

StackTrace:    at
FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction() in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
789

   at
FirebirdSql.Data.FirebirdClient.FbCommand.Release() in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
827

   at
FirebirdSql.Data.FirebirdClient.FbCommand.Dispose(Boolean disposing) in
c:\Users\Jiri\Documents\devel\NETProvider\working\trunk\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
395

   at
System.ComponentModel.Component.Finalize() 		 	   		  

Re: [Firebird-net-provider] Provider 3.2.0.0 EF6 Exception

[Jiri C. <di...@ci...>]

On Mon, Oct 14, 2013 at 5:03 AM, Muthu Annamalai
<pea...@ho...> wrote:
> Make sure that the assembly-qualified name is used and that
> the assembly is available to the running application.

The runtime is unable to load the assembly. See ^. It should be in
GAC, near application etc.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] Provider 3.2.0.0 EF6 Exception

[Muthu A. <pea...@ho...>]

I have installed the correct EF6 Provider using nugget. But still I am
getting this error in DbContext type initialization

Here is the stack trace error,

Message=The Entity Framework provider type 'FirebirdSql.Data.FirebirdClient,
EntityFramework.SqlServer' registered in the application config file for the
ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient' could
not be loaded. Make sure that the assembly-qualified name is used and that
the assembly is available to the running application. See
http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
Source=EntityFramework

Here is my config file, I don't know which one is wrong,

<configSections>
    <section name="entityFramework"
type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection,
EntityFramework, Version=6.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <section name="firebirdsql.data.firebirdclient"
type="System.Data.Common.DbProviderConfigurationHandler, System.Data,
Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
 </configSections>
  <entityFramework>
    <defaultConnectionFactory
type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory,
EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="FirebirdSql.Data.FirebirdClient"
type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c" />
      <provider invariantName="System.Data.SqlClient"
type="System.Data.Entity.SqlServer.SqlProviderServices,
EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="FirebirdSql.Data.FirebirdClient" />
      <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=3.2.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c" />
    </DbProviderFactories>
  </system.data>

--------Previous mail----------------

After I installed the 3.2.0.0 EF6 Version, I am getting this exception, any
help is appreciated,

Thanks,
Annam Muthu

System.TypeInitializationException was unhandled
  HResult=-2146233036
  Message=The type initializer for 'Pearlpos.Data.Models.Entities' threw an
exception.
  Source=Pearlpos.Data
  TypeName=Pearlpos.Data.Models.Entities
  StackTrace:
       at Pearlpos.Data.Models.Entities..ctor(DbConnection entityConnection)
       at Pearlpos.Data.Utils.DatabaseUtility.GetContext() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\DatabaseUtility.cs:line 37
       at Pearlpos.Data.Utils.DataInit..ctor() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\DataInit.cs:line 21
       at Pearlpos.Data.Utils.DatabaseUtility.ValidConnection(String
connectionString) in c:\Users\Muthu Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\DatabaseUtility.cs:line 24
       at Pearlpos.Data.Utils.Database.ConnectDatabase() in c:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos.Data\Utils\Database.cs:line 86
       at My.MyApplication.ConnectDatabase() in C:\Users\Muthu
Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos\Application\ApplicationEvents.vb:line 14
       at My.MyApplication.Application_Startup(Object sender,
StartupEventArgs e) in C:\Users\Muthu Annamalai\Documents\Visual Studio
2012\Projects\Pearlpos\Pearlpos\Application\ApplicationEvents.vb:line 62
       at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnStar
tup(StartupEventArgs eventArgs)
       at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoAppl
icationModel()
       at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(St
ring[] commandLine)
       at My.MyApplication.Main(String[] Args) in
17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
       at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly,
String[] args)
       at System.AppDomain.nExecuteAssembly(RuntimeAssembly assembly,
String[] args)
       at System.Runtime.Hosting.ManifestRunner.Run(Boolean checkAptModel)
       at System.Runtime.Hosting.ManifestRunner.ExecuteAsAssembly()
       at
System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext
activationContext, String[] activationCustomData)
       at
System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext
activationContext)
       at System.Activator.CreateInstance(ActivationContext
activationContext)
       at
Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssemblyDebugInZone()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException: System.InvalidOperationException
       HResult=-2146233079
       Message=The 'Instance' member of the Entity Framework provider type
'FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
FirebirdSql.Data.FirebirdClient, Version=3.2.0.0, Culture=neutral,
PublicKeyToken=3750abcc3150b00c' did not return an object that inherits from
'System.Data.Entity.Core.Common.DbProviderServices'. Entity Framework
providers must inherit from this class and the 'Instance' member must return
the singleton instance of the provider. This may be because the provider
does not support Entity Framework 6 or later; see
http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

[Firebird-net-provider] [FB-Tracker] Created: (DNET-524) EF5: Avoid deadlocks by connection reusage and allow usage of CreateDatabaseIfNotExists DB initializer

[Mark J. (JIRA) <tr...@fi...>]

EF5: Avoid deadlocks by connection reusage and allow usage of CreateDatabaseIfNotExists DB initializer
------------------------------------------------------------------------------------------------------

                 Key: DNET-524
                 URL: http://tracker.firebirdsql.org/browse/DNET-524
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 3.2.0.0
         Environment: EF 5 on .NET 4.0 and probably 4.5
            Reporter: Mark Junker
            Assignee: Jiri Cincura


# Avoid deadlocks by connection reusage:
#*  Assume that you have both an IDbSet<T1> and IDbSet<T2>
#* Use a TransactionScope()
#* Create the DbContext
#* Create an instance of T1 where you initialize a property T1.X with an instance of T2 queried from the IDbSet<T2>
#* Add the instance of T1 to the IDbSet<T1>
#* Call SaveChanges()
#* Results in a no wait lock because:
#** Adding the instance of T1 partially loads the IDbSet<T1> and therefore creates a lock on the table
#** SaveChanges() reopens the existing connection which produces a new FbConnectionInternal which tries to write something to a locked table
#* Solution: Reuse the internal connection when the FbConnection gets reopened
# Allow usage of CreateDatabaseIfNotExists DB initializer
#* There's a call to context.Database.Exists() while a new TransactionScope(TransactionScopeOption.Suppress) is active
#* Solution: Allow Enlist without an active transaction

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira