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

Re: [Firebird-net-provider] FbClient v4.0.30319

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

That's normal FbException you get from server. Nothing magic. You're
getting deadlock in your transaction(s).


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

Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

I finally got an error message on this issue.  Here is the data I pulled,
Maybe this will shed some light on what I'm doing wrong.

ErrorMsg: deadlock
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=7c3713d9-26bd-43f5-ba64-5bd1eb8e3fa1|NEWSESSIONTIMEOUT=20|

ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

The transaction level is "Snapshot"

a follow up error, with the same transaction level about 11 minutes later:
ErrorMsg: lock conflict on no wait transaction
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=662a1981-a9e9-4fda-b287-3397197f0bbb|NEWSESSIONTIMEOUT=20|
ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line
245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String
sprocname, SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname,
SProcParam[] parms, TransIsoLvl isolvl) in
c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename,
SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath,
String ipaddr, String browserinfo, TransIsoLvl isolvl) in
c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

Dixon


On Wed, Mar 19, 2014 at 3:48 PM, E. D. Epperson Jr
<dix...@gm...>wrote:

> When I hit this line:
> conn.Open();
> it breaks out of that block without throwing an exception.  Actually it
> breaks out of that class completely, but it doesn't return a datatable so
> my calling class experiences a datatable == null exception, which I handle.
>
>
> here is the code sample where I open the connection
>
>             try
>             {
>                 if (conn == null)
>                 {
>                     conn = new FbConnection(_connstr);  -- it breaks out
> here
>                 }
>                 switch (conn.State)
>                 {
>                     case ConnectionState.Closed:
>                         conn.Open();
>                         break;
>                     case ConnectionState.Broken:
>                     case ConnectionState.Connecting:
>                     case ConnectionState.Executing:
>                     case ConnectionState.Fetching:
>                         conn.Close();
>                         conn.Open();
>                         break;
>                 }
>                 return conn.State == ConnectionState.Open;
>             }
> ... then I handle any exception thrown here, except it never throws the
> exception.  I guess it just isn't opening the connection
>
> Dixon
>
>
> On Wed, Mar 19, 2014 at 3:36 PM, Jiri Cincura <di...@ci...> wrote:
>
>> On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
>> <dix...@gm...> wrote:
>> > At some point during every day, after creating the FbConnection, I then
>> > Open.  It apparently throws an error, but my try/catch doesn't catch it.
>>
>> How do you know it throw an exception? Did you tried attaching
>> debugger to VS (from other VS)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and their
>> applications. Written by three acclaimed leaders in the field,
>> this first edition is now available. Download your free book today!
>> http://p.sf.net/sfu/13534_NeoTech
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
>
> --
> Dixon Epperson
>



-- 
Dixon Epperson

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

[Mark R. <ma...@la...>]

On Thu, 20 Mar 2014 03:51:23 -0600, David De Smet <ida...@gm...>
wrote:
> I'm using LLBLGen for creating the script and model.
> 
> The script for creating the DB is DECIMAL, so is the DB end result. I
> verified with Flamerobin.

What is the precision and scale of the DECIMAL?

> The model is also decimal and when writing .NET code the value I'm
passing
> for save is decimal. But as said, the return value is Int64 or long if
> coding in C#.
> 
> I'm using Firebird Embedded.

Have you created a dialect 1 (deprecated) or dialect 3 database?

Mark

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

[David De S. <ida...@gm...>]

I'm using LLBLGen for creating the script and model.

The script for creating the DB is DECIMAL, so is the DB end result. I verified with Flamerobin.

The model is also decimal and when writing .NET code the value I'm passing for save is decimal. But as said, the return value is Int64 or long if coding in C#.

I'm using Firebird Embedded.

David De Smet

Message sent from my iPhone

> On 20/03/2014, at 02:00, Jiri Cincura <di...@ci...> wrote:
> 
> What's the datatype in DB and what's in your model? Very likely you
> have a mismatch there.
> 
> 
> -- 
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
> 
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

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

What's the datatype in DB and what's in your model? Very likely you
have a mismatch there.


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

Re: [Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

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

What's the complete message? Isn't it a violation on PK?


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

[Firebird-net-provider] DB Type decimal is not returning as decimal

[David De S. <ida...@gm...>]

Good day,

I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of
the Firebird ADO.NET Data Provider.

I'm experiencing an InvalidCastException when trying to get a value of a
field which I assigned the DB type as decimal.

Looking further into the problem I'm seeing that the returned value is not
of type decimal but instead of type Int64. Casting to Int64 solved the
exception but the problem is that the returned value is not of fixed
precision.

As an additional note, I'm using Firebird embedded, the latest version
found on the page.

Regards,
Dave

[Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

[David De S. <ida...@gm...>]

Good day,

I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of
the Firebird ADO.NET Data Provider.

And I'm getting this exception when it shouldn't.

Let me further explain:

I have a table *Product*, with *Code* field which is unique and with DB
type as VarChar.
When I save a new Product with Code = "123" and then another one with Code
= "1234", I get an unique constraint exception.

As you can see, the *Code* is not the same but still the exception is
thrown.
I used those values literally. I also have tested with "1" and then "12"
and similar ones getting the same result.

I examined the exception and is indeed pointing to the Product.Code field.

This is part of the script generated for the DB:

CREATE TABLE "Product"
(
  "Id" INTEGER NOT NULL,
  "Code" VARCHAR(50) NOT NULL,
...

CREATE GENERATOR "SEQ_Product";
...
ALTER TABLE "Product"
  ADD CONSTRAINT "PK_b975d4748fdb926b5f347dafb0a" PRIMARY KEY
...
ALTER TABLE "Product"
  ADD CONSTRAINT "UC_de8f0404c97a0d1f3917002ab06" UNIQUE
  (
    "Code"
  );

As an additional note, I'm using Firebird embedded, the latest version
found on the page.

Regards,
Dave

Re: [Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

When I hit this line:
conn.Open();
it breaks out of that block without throwing an exception.  Actually it
breaks out of that class completely, but it doesn't return a datatable so
my calling class experiences a datatable == null exception, which I handle.


here is the code sample where I open the connection

            try
            {
                if (conn == null)
                {
                    conn = new FbConnection(_connstr);  -- it breaks out
here
                }
                switch (conn.State)
                {
                    case ConnectionState.Closed:
                        conn.Open();
                        break;
                    case ConnectionState.Broken:
                    case ConnectionState.Connecting:
                    case ConnectionState.Executing:
                    case ConnectionState.Fetching:
                        conn.Close();
                        conn.Open();
                        break;
                }
                return conn.State == ConnectionState.Open;
            }
... then I handle any exception thrown here, except it never throws the
exception.  I guess it just isn't opening the connection

Dixon


On Wed, Mar 19, 2014 at 3:36 PM, Jiri Cincura <di...@ci...> wrote:

> On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
> <dix...@gm...> wrote:
> > At some point during every day, after creating the FbConnection, I then
> > Open.  It apparently throws an error, but my try/catch doesn't catch it.
>
> How do you know it throw an exception? Did you tried attaching
> debugger to VS (from other VS)?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Dixon Epperson

Re: [Firebird-net-provider] FbClient v4.0.30319

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

On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
<dix...@gm...> wrote:
> At some point during every day, after creating the FbConnection, I then
> Open.  It apparently throws an error, but my try/catch doesn't catch it.

How do you know it throw an exception? Did you tried attaching
debugger to VS (from other VS)?

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

[Firebird-net-provider] FbClient v4.0.30319

[E. D. E. J. <dix...@gm...>]

I am using FbClient, v4.0.30319  with VisualStudio 2012.  I am experiencing
an intermittent error that I wonder if anyone else has had or could tell me
how to address.

Here is my connection string:
User=******;Password=******;Database=CBT;DataSource=localhost;Port=3050;Dialect=3;Charset=UTF8;Role=;Connection
lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;

This is a development environment so I am constantly starting and stopping
the Db connection.

At some point during every day, after creating the FbConnection, I then
Open.  It apparently throws an error, but my try/catch doesn't catch it.
 The only way to recover is to restart VS2012, or change the connection
string.

I've checked the event logs on the dev computer, but it doesn't give me any
clue.

One question I do have, should I be using the connection pooling options in
the connection string with an ado.net client?  Other than that, I've no
idea what could be causing the issue.


-- 
Dixon Epperson

Re: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.

[Joël G. <J.G...@fa...>]

HI Marco,

Thanks for your response. I forgot to mention that in my initial quest. Yes, I did do that. Here is the content of my App.config fil:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <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.FbProviderServices, FirebirdSql.Data.FirebirdClient" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Kind regards,

Joël Gijbels

Van: Marco Castro - McSoft [mailto:mc...@mc...]
Verzonden: dinsdag 18 maart 2014 19:19
Aan: Joël Gijbels; fir...@li...
Onderwerp: RE: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.



Hello Joel,
Did you configured your App.config file with this provider configuration?
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <!-- 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>
  <system.data>
    <DbProviderFactories>
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <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>

          Best  regards,
Marco Aurelio Castro
Director
McSoft
McSoft<http://www.mcsoft.com.br> | A Empresa<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnEmpresa.htm> | Nosso sistema<http://www.mcsoft.com.br/TextoGenerico.aspx?FileName=fnSolucoes.htm>
[Facebook]<http://www.facebook.com/McSoftBH>[Twitter]<http://twitter.com/mcsoft>


----- Original Message -----
From: Joël Gijbels [mailto:J.G...@fa...]
To: fir...@li...<mailto:fir...@li...>
Sent: Tue, 18 Mar 2014 11:00:26 +0000
Subject: [Firebird-net-provider] Question about the Firebird .Net Client forEF6.
Hi Firebird-net-provider,

As a .Net developer I have been asked to connect to a Firebird database via Entity Framework. I installed both the Data Provider and the DDEX.

[cid:image002.jpg@01CF3497.1BAF19C0]

Via NuGet I added Entity Framework 6.0.2 and the Firebird ADO.NET Data Provider (Entity Framework 6).

[cid:image004.jpg@01CF3497.1BAF19C0]

So far so good, I managed to open the ADO.Net Entity Data Model wizard, select the correct database for a database first approach. But then I get this confusing error according to the version of the database provider I have installed.

[cid:image009.jpg@01CF3497.1BAF19C0]

Any help would be appreciated. If you need more info, please let me know.

Thanks in advance for your advice.

Kind regards,

Joël Gijbels.

[Firebird-net-provider] [FB-Tracker] Created: (DNET-548) there is an exception when i create object of model

[vitalii (JIRA) <tr...@fi...>]

 there is an exception when i create object of model
----------------------------------------------------

                 Key: DNET-548
                 URL: http://tracker.firebirdsql.org/browse/DNET-548
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
         Environment: windows 7, x64, visual studio 2012, ef 6
            Reporter: vitalii
            Assignee: Jiri Cincura


I hope I created issue in correct way!

I installed Firebird Provider and DDEX Provider.
I installed EF6.

I could create model. I could saw entities.
But when i create an object of model:

FirebirdEntities context = new FirebirdEntities();

i get exception:

{"The Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient' 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."}

Can you help me?
Maybe this problem was sounded here, but i didn't find it.

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-547) there is an exception when i create object of model

[vitalii (JIRA) <tr...@fi...>]

there is an exception when i create object of model
---------------------------------------------------

                 Key: DNET-547
                 URL: http://tracker.firebirdsql.org/browse/DNET-547
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
         Environment: windows 7, x64, visual studio 2012, ef 6
            Reporter: vitalii
            Assignee: Jiri Cincura


Good day. 

I installed Firebird Provider and DDEX Provider. 
I installed EF6.

I could create model. I could saw entities.
But when i create an object of model:

FirebirdEntities context = new FirebirdEntities();

i get exception:

{"The Entity Framework provider type 'FirebirdSql.Data.FirebirdClient.FbProviderServices, FirebirdSql.Data.FirebirdClient' 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."}

Can you help me? 
Maybe this problem was sounded here, but i didn't find it.




-- 
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] How to connect

[Mark R. <ma...@la...>]

On Fri, 14 Mar 2014 04:54:34 +0000, "Dass, Sukhen (NDH-MRM)"
<Suk...@mr...> wrote:
> Dear Team,
> 
> I am facing a issue in connection of Firebird database which is kept in
a
> shared drive. Physically I am able to access the file and it has full
> permission for read/write.
> 
> Please help to connect to a shared database in vb.net

Firebird can only use databases on a local drive to prevent corrupted
databases through insufficient/incorrect locking. Using a shared drive
implies that you need to use a Firebird server and the database file local
to that server, and have the client connect to that server.

Mark

Re: [Firebird-net-provider] How to connect

[André K. <Kna...@be...>]

> I am facing a issue in connection of Firebird database which is
> kept in a shared drive. Physically I am able to access the file and
> it has full permission for read/write.

Can you give more details please?
What character has the "issue"?
What  did  you try so far and what does not work as expected? Show the
relevant parts of the code, please.

You   mention  "shared  drive"... but you understand that using a real
SQL   server   (any   of  them,  not  just  Firebird)  you  are  *NOT*
communicating with "the file" usually. 

Instead  communication  to  the database is delegated to the server by
the client.

[Firebird-net-provider] How to connect

[Dass, S. (NDH-MRM) <Suk...@mr...>]

Dear Team,

I am facing a issue in connection of Firebird database which is kept in a shared drive. Physically I am able to access the file and it has full permission for read/write.

Please help to connect to a shared database in vb.net


Thanks
Sukhen Dass
This message contains information which may be confidential and privileged. Unless you are the intended recipient (or authorized to receive this message for the intended recipient), you may not use, copy, disseminate or disclose to anyone the message or any information contained in the message.  If you have received the message in error, please advise the sender by reply e-mail, and delete the message.  Thank you very much.

[Firebird-net-provider] Add auto-generated identity for primary key column

[zab <zab...@gm...>]

The begining of the discussion is here:
https://github.com/cincuranet/NETProvider/pull/2
Implementation:
https://github.com/zabulus/NETProvider/commit/6f9b7621cef4d9862ce6acb7c8fd8c9764ad7397
Main point is to add auto-generating values for PK column with specified
DatabaseGeneratedOption.Identity. 
Problem is how to configure behavior of such autogeneration.
My implementation creates separate generator for each PK in all tables and
uses IBExpert-like naming. Cincuranet suggests that it should be somehow
configurated, because some users might want to have one generator for all
PKs in database, and configurable naming for generator and before insertion
trigger.
I had suggested to use app.config separate section like entity framework
does. Something like the follow:

<configSections>
    <section name="firebird.client.net" type="FirebirdConfigurationHandler"
/>
</configSections>
<connectionstrings>
    <add name=&quot;exampleConnectionString&quot;
connectionString=&quot;&lt;some connection string values>"
provider="FirebirdSql.Data.FirebirdClient" />
</connectionstrings>
<firebird.client.net>
    <IdentityBehavior connectionString="exampleConnectionString"
generating="separate/shared" naming="some/naming/shemes" />
</firebird.client.net>

What else can be added to such configuration regarding to auto-generated
values? 
What other options or option values can be suggested?



--
View this message in context: http://firebird.1100200.n4.nabble.com/Add-auto-generated-identity-for-primary-key-column-tp4635338.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] Reverse engineering in Visual Studio 2013 (FirebirdClient-EF6 v4.1 and EF6) fails

[Morten M. <mo...@my...>]

Thanks! Your tip got me a step further! 

I uninstalled the NetProvider msi package, and un-GAC'ed all the remaining
FirebirdClients (yes, I actually had several). Then, I added the
NetProvider-EF6 NuGet package (for the x'th time) and made sure my config
was correct. Now, when I try to reverse engineer, I run into the DNET-542
issue you mention.
But anyhow; I got past the other problems at least! :-) I'll just wait for
the update then...

Regards, 
Morten





--
View this message in context: http://firebird.1100200.n4.nabble.com/Reverse-engineering-in-Visual-Studio-2013-Net-4-5-1-FirebirdClient-EF6-v4-1-and-EF6-fails-with-no-co-tp4635223p4635226.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

Re: [Firebird-net-provider] Reverse engineering in Visual Studio 2013 (FirebirdClient-EF6 v4.1 and EF6) fails

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

On Tue, Feb 25, 2014 at 9:31 PM, Morten Myrvold <mo...@my...> wrote:
>
> Does anyone have any idea what could be wrong?  This is really getting quite frustrating now…


VS is very likely loading version from GAC and hence it cannot see EF6
version. Maybe you also didn't changed the config (NuGet package is
not currently doing it automatically) so the designer is falling back
to non-EF6 mode. Maybe you'll hit also
http://tracker.firebirdsql.org/browse/DNET-542
(https://github.com/cincuranet/NETProvider/tree/ef6-schema3).


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

[Firebird-net-provider] Reverse engineering in Visual Studio 2013 (FirebirdClient-EF6 v4.1 and EF6) fails

[Morten M. <mo...@my...>]

Hi,

 

I've been trying to get the Firebird ADO.NET Provider to work in Visual
Studio2013 in order to reverse engineer my Firebird database in EF6, but no
matter how I go about installing, I keep getting "a ton of" different error
messages and weird behavior. Many of these, I have later been able to
eliminate by reinstalling my .Net versions.

I think maybe there were some configuration errors there, but that should be
sorted out now. All .Net verification tests I have run says they're all OK.

 

I have messed around with both the MSI installers (NetProvider 4.1.0.0 and
DDEX  3.0.1) found on http://www.firebirdsql.org/en/net-provider/, and NuGet
packages in Visual Studio 2013. 

It seems to me that I needed to "manually" download the MSI installers for
NetProvider and DDEX in order to get the Server Explorer connection to
function in VStudio, and that the NuGet packages are only necessary for the
project references?

 

Anyway; at this point, I have a situation where I can successfully add the
database to the Server Explorer in VS, but when I try to "Update model from
database" on an empty edmx file in my project, it says: 

"Your project references the latest version of Entity Framework; however, an
Entity Framework database provider compatible with this version could not be
found for your data connection. Exit this wizard, install a compatible
provider, and rebuild your project before performing this action." Above
this text, the only option is "Entity Framework 6.0", and it is checked and
disabled (as it's the only choice).

Viewing NuGet packages for project, I do have both the "EntityFramework"
(v6.0.2) and "Firebird ADO.NET Data provider (Entity Framework 6)" (v6.0.2),
but anyhow it still says the NetProvider is not compatible with EF6? I have
tried both .Net framework 4 and 4.5, but they both failed the same way.

 

I've scoured the net (and this list) in search of correct installation
procedures, but have come up short so far... 

 

Does anyone have any idea what could be wrong?  This is really getting quite
frustrating now.

Any tips would be greatly appreciated! J

 

 

Regards,

Morten 



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

[Firebird-net-provider] [FB-Tracker] Created: (DNET-546) Need new FbDataReader methods

[Gabor L. (JIRA) <tr...@fi...>]

Need new FbDataReader methods
-----------------------------

                 Key: DNET-546
                 URL: http://tracker.firebirdsql.org/browse/DNET-546
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.1.0.0
         Environment: Visual Studio 2012, .NET 4.0
            Reporter: Gabor Lakatos
            Assignee: Jiri Cincura
            Priority: Minor


I have new extension form FbDataReader class. I extend Get... (GetString, GetInt32, etc) methods for new parameters. Example: GetString("FIELDNAME", "DefaultValue").

The code:

using System;
using FirebirdSql.Data.FirebirdClient;

public static class FbDataReaderEx
{
    public static bool GetBoolean(this FbDataReader oR, string FieldName, bool Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetBoolean(oR.GetOrdinal(FieldName));
        }
    }

    public static byte GetByte(this FbDataReader oR, string FieldName, byte Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetByte(oR.GetOrdinal(FieldName));
        }
    }
    
    public static DateTime GetDateTime(this FbDataReader oR, string FieldName, DateTime Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetDateTime(oR.GetOrdinal(FieldName));
        }
    }
    
    public static decimal GetDecimal(this FbDataReader oR, string FieldName, decimal Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetDecimal(oR.GetOrdinal(FieldName));
        }
    }
    
    public static double GetDouble(this FbDataReader oR, string FieldName, double Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetDouble(oR.GetOrdinal(FieldName));
        }
    }
    
    public static Type GetFieldType(this FbDataReader oR, string FieldName)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return null;
        }
        else
        {
            return oR.GetFieldType(oR.GetOrdinal(FieldName));
        }
    }
    
    public static float GetFloat(this FbDataReader oR, string FieldName, float Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetFloat(oR.GetOrdinal(FieldName));
        }
    }
    
    public static Guid GetGuid(this FbDataReader oR, string FieldName, Guid Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetGuid(oR.GetOrdinal(FieldName));
        }
    }
    
    public static Int16 GetInt16(this FbDataReader oR, string FieldName, Int16 Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetInt16(oR.GetOrdinal(FieldName));
        }
    }
    
    public static Int32 GetInt32(this FbDataReader oR, string FieldName, Int32 Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetInt32(oR.GetOrdinal(FieldName));
        }
    }
    
    public static Int64 GetInt64(this FbDataReader oR, string FieldName, Int64 Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetInt64(oR.GetOrdinal(FieldName));
        }
    }
    
    public static string GetString(this FbDataReader oR, string FieldName, string Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetString(oR.GetOrdinal(FieldName));
        }
    }
    
    public static object GetValue(this FbDataReader oR, string FieldName, object Default)
    {
        if (oR.IsDBNull(oR.GetOrdinal(FieldName)))
        {
            return Default;
        }
        else
        {
            return oR.GetValue(oR.GetOrdinal(FieldName));
        }
    }
    
    public static bool IsDBNull(this FbDataReader oR, string FieldName)
    {
        return oR.IsDBNull(oR.GetOrdinal(FieldName));
    }
}

I would be happy if the new procedures would appear in the new version.

Thanks,
    Gabor

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

        

[Firebird-net-provider] Hang at program exit with embedded database

[Philip G. <phi...@gm...>]

Hello,

I am using the .NET provider version 4.1.0.0 with the x86 embedded server version 2.5.2.26540. I'm new to Firebird and my goal is to use it to replace a sqlite database.

My problem is that when I open an embedded database with FbConnection, my program hangs for a few seconds (sometimes up to 9!) after the Main() returns. Here's a simple example:

    private static void Main()
    {
      const string connectionString =
        "User=SYSDBA;Password=masterkey;Database=sandbox.fdb;ServerType=1";

      if (! File.Exists("sandbox.fdb"))
        FbConnection.CreateDatabase(connectionString);

      using (var connection = new FbConnection(connectionString))
        connection.Open();

      Console.WriteLine("Finished");  // appears several seconds before program exits
    }

Should I be doing something differently? Is this normal?

Thanks,
Philip

[Firebird-net-provider] [FB-Tracker] Created: (DNET-545) Don't want to need Directory c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider

[Firebird U. u. W. (JIRA) <tr...@fi...>]

Don't want to need Directory c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider 
-------------------------------------------------------------------------------------------

                 Key: DNET-545
                 URL: http://tracker.firebirdsql.org/browse/DNET-545
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 4.1.0.0
         Environment: Perhaps important that I use Sharp develop 4.4. (Windows 7)
            Reporter: Firebird User unter Windows7
            Assignee: Jiri Cincura


I have tried to drop a table still there are StoredProecedures using it in the data base.
I catched an exception. ok. But the text was:
Can't load file FbTransaction.cs under c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient.

So I have created an user jiri and so on. Isn't there any other solution?

Than I got the real exception text.
FirebirdSql.Data.FirebirdClient.FbException: unsuccessful metadata update
cannot delete
COLUMN RELATION1.MY_FR
there are 3 dependencies

The location was:
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbTransaction.cs
Line 174

By the way:
I have heard that lock(this) is not a good way for synchronization.

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-544) Provider not found

[Thomas A. (JIRA) <tr...@fi...>]

Provider not found
------------------

                 Key: DNET-544
                 URL: http://tracker.firebirdsql.org/browse/DNET-544
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.0.0.0
         Environment: Win7 /64, Visual Studio 2012
            Reporter: Thomas Aichinger
            Assignee: Jiri Cincura
            Priority: Trivial


After installing NETProvider-4.0.0.0.msi	it is unknown in Visual Studio. How to add reference? Also Server Explorer is not working with DEXX Provider 3.0.0.0. Get the message "Unable to find the requested .Net Framework Data Provider.  It may not be installed."

I checked Global Assembly Cache with gacutil and both providers are registered.

Please help.

Regards
Thomas

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