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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-523) Unable to unload fbembed.dll

[Marcel B. (JIRA) <tr...@fi...>]

Unable to unload fbembed.dll
----------------------------

                 Key: DNET-523
                 URL: http://tracker.firebirdsql.org/browse/DNET-523
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.2.0.0
            Reporter: Marcel Brink
            Assignee: Jiri Cincura
            Priority: Critical


I have a small application to be able to backup / restore and upgrade Firebird database which are used by our software.
Since we started years back with Firebird 1.5 and migrated to 2.5 it's still possible some of our customer are running on 1.5.

So i'm trying to automate the process to :
- Restore a backup (possibly 1.5)
- I try to connect through a 1.5 fbembed.dll using the FbConnectionBuilder.ClientLibrary.
- if it fail i try to connect through a 2.5 fbembed.dll using the FbConnectionBuilder.ClientLibrary.

However, switching from 1 client to the other doesn't free the fbembed.dll (and related dll's).
Even disposing the FbConnection doesn't do the trick.
FbConnection.ClearAllPools() also doesn't work.

Is there any way to force unloading the fbembed.dll ?
I tried it by manually unloading, but this leads to problems (probably due to caching of the dynamic assembly)

tia,

Marcel

-- 
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] Provider 3.2.0.0 EF6 Exception

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

Looks like you're not using EF6 version.

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

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

Thanks,
Muthu Annamalai

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-522) Split Entity framework 6 provider from the FirebirdSql.Data.FirebirdClient.dll into a new DLL to avoid incompatibilties when using the DDEX Provider and trying to use EF6 in applications

[André Z. (J. <tr...@fi...>]

Split Entity framework 6 provider from the FirebirdSql.Data.FirebirdClient.dll into a new DLL to avoid incompatibilties when using the DDEX Provider and trying to use EF6 in applications
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DNET-522
                 URL: http://tracker.firebirdsql.org/browse/DNET-522
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: vNext
         Environment: Windows 8, Visual Studio 2012, .net 4.5 and EF6
            Reporter: André Ziegler
            Assignee: Jiri Cincura
            Priority: Critical


Problem:

When you use the DDEX provider in Visual Studio you need to install the (non EF6) FirebirdSql.Data.FirebirdClient.dll into the GAC. When you now try to use EF6, the provider from the GAC (non EF6) is used all the time and this results in errors, because the EF6 requires new providers.


Solution:

Split Entity framework 6 provider from the FirebirdSql.Data.FirebirdClient.dll into a new DLL (maybe follow the Microsoft Naming convention what Microsoft does with their EG6 provider (EntityFramework.SqlServer) and name it EntityFramework.Firebird). Now the VS/DDEX can use the non EF6 version from GAC and EF6 projects can use the EntityFramework.Firebird without having issues.

-- 
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] .NET provider 3.2.0.0 released

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

More info at http://blog.cincura.net/233420-ado-net-provider-for-firebird-3-2-0-0-is-ready/
.

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

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

On Fri, Oct 4, 2013 at 2:03 PM, André Knappstein
<Kna...@be...> wrote:
> When  I  help  people migrating from dBase to C#, I show them how easy
> you  can drag/drop your tables on the form and get running in about no
> time. Big "aaaah! Fine!".
> Then  I  show them the code that's been generated, some 4.000 lines of
> unreadable spaghetti even for the smallest tasks. Big "uuuuuh! Ugly!".
>
> That's  usually the point when they are ready to take a closer look on
> how to do the simple things yourself with a few classes or a few lines
> of code :-)

:D

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

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

> I think removing the quoted identifiers is a better way anyway. For
> the future etc.

I absolutely agree.
As  far  as  I know they already started the migration again, also not
defining  so awfully man indexes as they did before (using DBFs it was
necessary to have an index for all and everything).

> So you
> basically don't have this problem. It's the same story as in data sets
> (I hope nobody is using it now) generated bin VS.
When  I  help  people migrating from dBase to C#, I show them how easy
you  can drag/drop your tables on the form and get running in about no
time. Big "aaaah! Fine!".
Then  I  show them the code that's been generated, some 4.000 lines of
unreadable spaghetti even for the smallest tasks. Big "uuuuuh! Ugly!".

That's  usually the point when they are ready to take a closer look on
how to do the simple things yourself with a few classes or a few lines
of code :-)

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

On Wed, Oct 2, 2013 at 1:28 PM, André Knappstein
<Kna...@be...> wrote:
> OK, thank you anyway.
> I  think  I will be telling them to re-create the databases, this time
> using a character set *and* *not* the quoted identifiers.

I think removing the quoted identifiers is a better way anyway. For
the future etc.

> Interesting  though,  that  I  did  not  find  any  hint about similar
> problems  in  the  internet  concerning  for  example MSSQL server and
> similar.

I think the problem is, that MSSQL is not using quotes. MSSQL is kind
of hybrid, it keeps casing as is (not defaulting to upper case) and
matches exact matches only if used inside "[" and "]". So you
basically don't have this problem. It's the same story as in data sets
(I hope nobody is using it now) generated bin VS. The query there is
kind of MSSQLized (and there's no (easy) way to plug in as 3rd party
provider provider).

> You're not taking part in the Firebird Tour this year, do you?

So far I was only invited to speak in Prague. Not in Germany.

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

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

OK, thank you anyway.
I  think  I will be telling them to re-create the databases, this time
using a character set *and* *not* the quoted identifiers.

Interesting  though,  that  I  did  not  find  any  hint about similar
problems  in  the  internet  concerning  for  example MSSQL server and
similar.

Even if I personally think that quoting identifiers is nonsense, a lot
of people are definitely doing this. Why didn't anybody have a problem
so far?

You're not taking part in the Firebird Tour this year, do you?

> Not 100% sure, but I think it's something in the DbDataAdapter the
> FbDataAdapter derives from. I don't know a place where this casing
> etc. in FirebirdClient would happen.  

> On Wed, Oct 2, 2013 at 10:47 AM, André Knappstein
> <Kna...@be...> wrote:
>> Yes.
>>
>>
>>> Are you creating the FbDataAdapter in code?
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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=60134791&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider






mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

Not 100% sure, but I think it's something in the DbDataAdapter the
FbDataAdapter derives from. I don't know a place where this casing
etc. in FirebirdClient would happen. :(

On Wed, Oct 2, 2013 at 10:47 AM, André Knappstein
<Kna...@be...> wrote:
> Yes.
>
>
>> Are you creating the FbDataAdapter in code?
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



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

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

Yes.


> Are you creating the FbDataAdapter in code?

Re: [Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

Are you creating the FbDataAdapter in code?


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

[Firebird-net-provider] fbdataadapter: fill() converting to uppercase?

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

Hi Gang,
this  is  probably  something  WAD  / inherited, but nonetheless it is
undesirable  and  I'd like to know if there is something one can do to
avoid it.

I  was  helping  a  company to move from dBase/DBF to C#/Firebird, but
their  IT  already made a migration of the huge DBFs to Firebird. They
were mostly using "default" settings, though, and so the databases are
with Characterset "NONE" and the identifiers are quoted.
Don't  know  how  the Characterset is involved in the problem, but the
quoted identifiers definitely are.

It  turned  out  that the dataadapter's fill() method is automatically
uppercasing the select command. So, to make a fill() work, the command
has - for example - to be changed like this:

standard:
"Select Field_1, Field_2, Field_3 from Table_1 where Key_1 = @Value_1"

after autoconversion by dataadapter fill():
"SELECT FIELD_1, FIELD_2, FIELD_3 FROM TABLE_1 WHERE KEY_1 = @VALUE_1"
which  will  fail,  because  the  FB  server  rejects  the uppercase'd
identifiers.

modification:
"Select  \"Field_1\",  \"Field_2\", \"Field_3\" from \"Table_1\" where
\"Key_1\" = @Value_1"

this  works  but  it  is  a  lot  of hard work in coding and very ugly
reading.

Is  there  anything  that  can  be done to ease this, any setting, any
automation?

I recommended - of course - to re-create database and do away with the
quoted   identifiers  nonsense,  and  they  indeed  prefer  this  over
constantly ESCAPEing the quotes in the query commands.

But if there is any other option...

thanks in advance!

André

[Firebird-net-provider] [FB-Tracker] Created: (DNET-521) Can firebirdsql.data.firebirdclient.dll COM visible?

[Zeki G. (J. <tr...@fi...>]

Can  firebirdsql.data.firebirdclient.dll COM visible?
-----------------------------------------------------

                 Key: DNET-521
                 URL: http://tracker.firebirdsql.org/browse/DNET-521
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
         Environment: Office 2007 and above
            Reporter: Zeki Gürsoy
            Assignee: Jiri Cincura


Can firebirdsql.data.firebirdclient.dll compile COM visible for VBA users? So it will alternative to ODBC driver.

-- 
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] AUTOREPLY [FB-Tracker] Created: (DNET-520...

[<ho...@er...>]

Sehr geehrte Damen und Herren,

vielen Dank fr Ihre Nachricht.
Ich bin bis 22.09.2013 im Urlaub und kann daher nicht persnlich auf Ihre E-Mail antworten, diese wird nicht weitergeleitet. 
In dringenden Fllen wenden Sie sich bitte direkt an unseren Support unter der Telefonnummer 089-9580870 oder per E-Mail an su...@er....

Mit freundlichen Gren

Robert Holler
ERGO SOFT GmbH
Mnchner Str. 87
85774 Unterfhring

ho...@er...
ho...@er...

http://www.ergo-soft.com
http://www.ergofakt.de

Tel: 089 95 80 87-0
Fax: 089 95 80 87-29

USt-IdentNr. DE157125042 
Steuernummer 11 143 810 33951

Amtsgericht Mnchen HRB 102056 
Geschftsfhrer: Robert Holler
Error when trying to update model from database: SQL error code = -204
----------------------------------------------------------------------

                 Key: DNET-520
                 URL: http://tracker.firebirdsql.org/browse/DNET-520
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 3.1.1.0
         Environment: Windows 8.1, Visual Studio 2012 Update 3
            Reporter: Anil Mujagic
            Assignee: Jiri Cincura


After installation of .NET Provider 3.1.1.0, while trying to update EDMX model from database, I get following error:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.9426688.
Generating the model took 00:00:00.7034577.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3738484.
Generating the model took 00:00:00.2757544.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3802625.
Generating the model took 00:00:00.2500684.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Application can compile and work with current model, but I cannot update it to include four new columns (simple nullable varchar), which I added to the table.

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

        

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-520) Error when trying to update model from database: SQL error code = -204

[Anil M. (JIRA) <tr...@fi...>]

Error when trying to update model from database: SQL error code = -204
----------------------------------------------------------------------

                 Key: DNET-520
                 URL: http://tracker.firebirdsql.org/browse/DNET-520
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 3.1.1.0
         Environment: Windows 8.1, Visual Studio 2012 Update 3
            Reporter: Anil Mujagic
            Assignee: Jiri Cincura


After installation of .NET Provider 3.1.1.0, while trying to update EDMX model from database, I get following error:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.9426688.
Generating the model took 00:00:00.7034577.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3738484.
Generating the model took 00:00:00.2757544.
Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.3802625.
Generating the model took 00:00:00.2500684.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Application can compile and work with current model, but I cannot update it to include four new columns (simple nullable varchar), which I added to the table.

-- 
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-519) There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'

[Marcus M. (JIRA) <tr...@fi...>]

There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'
----------------------------------------------------------------------------------------

                 Key: DNET-519
                 URL: http://tracker.firebirdsql.org/browse/DNET-519
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.1.1.0
            Reporter: Marcus Miris
            Assignee: Jiri Cincura
            Priority: Blocker


With the class...

public class Foo {
byte prop { get; set; }
}

...the provider threw: "There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'.

I checked and I think the following code at "FbProviderManifest.GetStoreType(edmType)" fixes the issue.

case PrimitiveTypeKind.Byte:
                    return TypeUsage.CreateDefaultTypeUsage(StoreTypeNameToStorePrimitiveType["smallint"]);



-- 
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] what is the correct way to close the trace api service?

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

You need to close it via another instance of FbTrace.

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

[Firebird-net-provider] what is the correct way to close the trace api service?

[korkless <kor...@ya...>]

hi, i'm tring to use the trace api but i have same problems to correctly close the trace service.

the call to fbTraceIstance.start("sessionName") will never return so this code will not works


fbTraceIstance.start("sessionName")
//next code will never execute
Console.WriteLine("started, press enter to exit");
Console.ReadLine();
fbTraceIstance.Stop(TraceId);  //TraceId is extracted from the first line of service output


but if i start the service on another thread i have an exception on fbTraceIstance.Close becouse the service is still opened and it tries to reopen it inside the
FbTrace.DoSimpleAction method called by FbTrace.Close

this is the multithread code

ThreadPool.QueueUserWorkItem(obj => fbTraceIstance.start("sessionName"));
Console.WriteLine("started, press enter to exit"); Console.ReadLine();
fbTraceIstance.Stop(TraceId);  //TraceId is extracted from the first line of service output 

so what's the way to correctly close the service?

and if the client application will exit without closing it there's same problem on the firebird server ? for example memory leak, etc

thanks

[Firebird-net-provider] [FB-Tracker] Created: (DNET-518) "Implementation limit exceeded"

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

"Implementation limit exceeded"
-------------------------------

                 Key: DNET-518
                 URL: http://tracker.firebirdsql.org/browse/DNET-518
             Project: .NET Data provider
          Issue Type: Bug
         Environment: Win7 x64 - VS 2012 - Firebird 2.5.x - .Net Provider 3.1.1.0
            Reporter: Rand Random
            Assignee: Jiri Cincura


I am still facing the issue when I want to update my EDMX Model, as described here

http://tracker.firebirdsql.org/browse/DNET-513
http://tracker.firebirdsql.org/browse/DNET-514

Just to make sure I am using the version 3.1.1.0 I did the following in my code:

using (var conx = new EntityModel())
            {
                var bla = conx.TabAccounts.Where(x => x.AccNr == "1001").Single();

            }

Which sucessfully run, and outputed to this sql query:

SELECT FIRST (2) 
"B"."IDACCOUNT" AS "IDACCOUNT", 
"B"."IDCOMPANY" AS "IDCOMPANY", 
"B"."IDPARENT" AS "IDPARENT", 
"B"."ACCNR" AS "ACCNR", 
"B"."ACCNRSUB" AS "ACCNRSUB", 
"B"."FLAGISSPLIT" AS "FLAGISSPLIT", 
"B"."FLAGISSYSTEMACCOUNT" AS "FLAGISSYSTEMACCOUNT", 
"B"."TEXTACCOUNTGL" AS "TEXTACCOUNTGL"
FROM "TABACCOUNT" AS "B"
WHERE CAST(_UTF8'1001' AS VARCHAR(8191)) = "B"."ACCNR"

As you notice the VARCHAR(8191) is fixed, but on Update Model from Database it fails.

Also I would like to mention that the .Single method here gets parsed to "SELECT FIRST (2) ...." shouldnt it be "SELECT FIRST (1)..." ?

Hope you can help me out.

-- 
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] Reopened: (DNET-516) Installer fails on 32bit systems

[Jiri C. (JIRA) <tr...@fi...>]

     [ http://tracker.firebirdsql.org/browse/DNET-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jiri Cincura reopened DNET-516:
-------------------------------


> Installer fails on 32bit systems
> --------------------------------
>
>                 Key: DNET-516
>                 URL: http://tracker.firebirdsql.org/browse/DNET-516
>             Project: .NET Data provider
>          Issue Type: Bug
>          Components: ADO.NET Provider
>    Affects Versions: 3.1.1.0
>         Environment: Windows 7 32bit with .NET 4.5
>            Reporter: NoPyGod
>            Assignee: Jiri Cincura
>             Fix For: vNext
>
>
> The installer gives an error - "Failed to open XML File C:\windows\microsoft.net\framework64\v4.0.30319\config\machine.config"
> Presumably because you forgot to check if the system is 64bit before modifying the 64bit machine.config

-- 
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-517) Executing Stored Procedure Fails with 'Stored Procedure doesn't exist' message

[Cecil M. (JIRA) <tr...@fi...>]

Executing Stored Procedure Fails with 'Stored Procedure doesn't exist' message
------------------------------------------------------------------------------

                 Key: DNET-517
                 URL: http://tracker.firebirdsql.org/browse/DNET-517
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.1.1.0
         Environment: Windows 8 Pro 64 bit, Visual Studio 2012
            Reporter: Cecil Martin
            Assignee: Jiri Cincura
            Priority: Critical


When executing a stored procedure, the provider returns an error stating the stored procedure doesn't exist.  Error occurs when trying to execute command as type StoredProcedure or Text.  Following are stack trace messages:

Using fbcommandbuilder.deriveparameters to derive parameters for stored procedure:

Error:
Stored procedure doesn't exist.

Stack Trace:
   at FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand command) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommandBuilder.cs:line 71
   at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 376
   at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44


And for executing as "execute procedure sp_jobq_add(?,?,?,?,?,?)":

Error:
Dynamic SQL Error
SQL error code = -204
Procedure unknown
SP_JOBQ_ADD

Stack Trace:
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 520
   at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 396
   at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44





-- 
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-516) Installer fails on 32bit systems

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

Installer fails on 32bit systems
--------------------------------

                 Key: DNET-516
                 URL: http://tracker.firebirdsql.org/browse/DNET-516
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.1.1.0
         Environment: Windows 7 32bit with .NET 4.5
            Reporter: NoPyGod
            Assignee: Jiri Cincura


The installer gives an error - "Failed to open XML File C:\windows\microsoft.net\framework64\v4.0.30319\config\machine.config"

Presumably because you forgot to check if the system is 64bit before modifying the 64bit machine.config

-- 
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] ADO.NET provider for Firebird 3.1.1.0

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

Hi *,

The version 3.1.1.0 of ADO.NET provider for Firebird is ready for your download!

More info: http://blog.cincura.net/233399-ado-net-provider-for-firebird-3-1-1-0-is-ready/
.

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

Re: [Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

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

On Thu, 15 Aug 2013 02:54:57 +0000 (UTC), Lt Col RDS Chauhan
<rds...@ya...> wrote:
> 1. Thanks for your response.  
> 
> 2. Did the following :-
> 
>    (a) Added the line UserManager = Legacy_UserManager
> 
>    (b) Changed the password with GSEC
> 
> 
> 
> 3. Now the login through .NET provider works for sysdba. But the
> Flamerobin 
> continues to accept the password masterkey and rejects the newly set 
> password. Please advise.

Flamerobin uses fbclient.dll which supports the new authentication, so it
authenticates to the sysdba password in the new authentication mechanism;
this password hasn't been changed.

Mark