Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
1
|
|
2
|
3
|
4
(2) |
5
|
6
|
7
|
8
|
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
|
16
|
17
(1) |
18
|
19
(1) |
20
|
21
|
22
|
|
23
|
24
|
25
|
26
|
27
(1) |
28
|
29
|
|
30
|
31
(20) |
|
|
|
|
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 11:08:42
|
Consider LOCALTIME and LOCALTIMESTAMP for EF6/EFCore
----------------------------------------------------
Key: DNET-967
URL: http://tracker.firebirdsql.org/browse/DNET-967
Project: .NET Data provider
Issue Type: Improvement
Components: Entity Framework, Entity Framework Core
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:28:33
|
Allow to fixup (nbackup) database via Services API
--------------------------------------------------
Key: DNET-966
URL: http://tracker.firebirdsql.org/browse/DNET-966
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:11:36
|
New datatypes handling in EF Core
---------------------------------
Key: DNET-965
URL: http://tracker.firebirdsql.org/browse/DNET-965
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:11:34
|
New datatypes handling in EF6
-----------------------------
Key: DNET-964
URL: http://tracker.firebirdsql.org/browse/DNET-964
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:01:00
|
Support for "gfix replica"
--------------------------
Key: DNET-963
URL: http://tracker.firebirdsql.org/browse/DNET-963
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:01:00
|
Evaluate compressed backups (FbStreamingBackup?)
------------------------------------------------
Key: DNET-962
URL: http://tracker.firebirdsql.org/browse/DNET-962
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:00:53
|
Evaluate encrypted backups (FbStreamingBackup?)
-----------------------------------------------
Key: DNET-961
URL: http://tracker.firebirdsql.org/browse/DNET-961
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 09:00:44
|
Evaluate ALTER SESSION RESET and connection pooling
---------------------------------------------------
Key: DNET-960
URL: http://tracker.firebirdsql.org/browse/DNET-960
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:58
|
Support for statement timeout
-----------------------------
Key: DNET-957
URL: http://tracker.firebirdsql.org/browse/DNET-957
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:57
|
Support for longer identifiers
------------------------------
Key: DNET-959
URL: http://tracker.firebirdsql.org/browse/DNET-959
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:53
|
Support 32k page size
---------------------
Key: DNET-953
URL: http://tracker.firebirdsql.org/browse/DNET-953
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:43
|
Support for batch operations
----------------------------
Key: DNET-958
URL: http://tracker.firebirdsql.org/browse/DNET-958
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:32
|
Support for fb_info_tra_snapshot_number
---------------------------------------
Key: DNET-950
URL: http://tracker.firebirdsql.org/browse/DNET-950
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:32
|
Support for INCLUDE_DATA
------------------------
Key: DNET-952
URL: http://tracker.firebirdsql.org/browse/DNET-952
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:29
|
Support for session idle timeout DPB
------------------------------------
Key: DNET-956
URL: http://tracker.firebirdsql.org/browse/DNET-956
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:27
|
Support for isc_dpb_set_bind
----------------------------
Key: DNET-955
URL: http://tracker.firebirdsql.org/browse/DNET-955
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:22
|
Support for isc_dpb_session_time_zone
-------------------------------------
Key: DNET-954
URL: http://tracker.firebirdsql.org/browse/DNET-954
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:54:15
|
Support for isc_tpb_at_snapshot_number <snapshot number length> <snapshotnumber>
--------------------------------------------------------------------------------
Key: DNET-951
URL: http://tracker.firebirdsql.org/browse/DNET-951
Project: .NET Data provider
Issue Type: Sub-task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:53:48
|
[ http://tracker.firebirdsql.org/browse/DNET-630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-630:
-------------------------------
> Support for Firebird 3.0
> ------------------------
>
> Key: DNET-630
> URL: http://tracker.firebirdsql.org/browse/DNET-630
> Project: .NET Data provider
> Issue Type: New Feature
> Components: ADO.NET Provider, Entity Framework, Entity Framework Core
> Environment: Windows 10
> Reporter: Mark Junker
> Assignee: Jiri Cincura
>
> It seems that the Firebird ADO.NET driver doesn't support Firebird 3.0 beta 2 yet. At least two things come to mind that probably have to be changed:
> * Support for BOOLEAN data type
> * Support for changed data structures
> * I found at least one situation where the data structure was changed: When I try to open an already opened embedded database
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-31 08:53:41
|
[ http://tracker.firebirdsql.org/browse/DNET-812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-812:
-------------------------------
> Support for Firebird 4.0
> ------------------------
>
> Key: DNET-812
> URL: http://tracker.firebirdsql.org/browse/DNET-812
> Project: .NET Data provider
> Issue Type: New Feature
> Components: ADO.NET Provider, Entity Framework, Entity Framework Core
> Reporter: Jiri Cincura
> Assignee: Jiri Cincura
>
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-27 08:31:22
|
Update ReservedWords in FbMetaData.xml
--------------------------------------
Key: DNET-949
URL: http://tracker.firebirdsql.org/browse/DNET-949
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-08-19 08:56:57
|
Resize compression buffer as needed in compression
--------------------------------------------------
Key: DNET-948
URL: http://tracker.firebirdsql.org/browse/DNET-948
Project: .NET Data provider
Issue Type: Sub-task
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
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
|
|
From: Muhammad Y. (JIRA) <tr...@fi...> - 2020-08-17 11:37:01
|
'No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'
------------------------------------------------------------------------------------------------------------------
Key: DNET-947
URL: http://tracker.firebirdsql.org/browse/DNET-947
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, Entity Framework
Affects Versions: 7.5.0.0
Environment: .netcore 3.1, ef 6.4
Reporter: Muhammad Yasar
Assignee: Jiri Cincura
By initializing the MYDbMigrator get the exception about provider not found. Is migration supported by firebird any other way to register the provider. Also tried to configure with appconfig but configuration section system.data cannot be recognized.
public abstract class MYBaseEntityContext : DbContext
{
protected MYBaseEntityContext() : base(connection, true)
{
Configuration.LazyLoadingEnabled = true;
Configuration.ProxyCreationEnabled = true;
Configuration.AutoDetectChangesEnabled = true;
Configuration.ValidateOnSaveEnabled = true;
}
}
public class MYDbMigrator<TContext, TMigrationsConfiguration> : DbMigrator
where TContext : MYBaseEntityContext
where TMigrationsConfiguration : MYDataMigrationConfiguration<TContext>, new()
{
public MYDbMigrator(DbConnection connection)
: base(new TMigrationsConfiguration()
{
TargetDatabase = new DbConnectionInfo(connection.ConnectionString, "FirebirdSql.Data.FirebirdClient")
})
{ }
}
public class MYDataMigrationConfiguration<TDataContext> :
DbMigrationsConfiguration<TDataContext>
where TDataContext : MYBaseEntityContext
{
public MYDataMigrationConfiguration()
{
AutomaticMigrationsEnabled = true;
AutomaticMigrationDataLossAllowed = false;
SetHistoryContextFactory("FirebirdSql.Data.FirebirdClient", (connection, defaultSchema) => new BaseHistoryDataContext(connection, defaultSchema));
SetSqlGenerator("FirebirdSql.Data.FirebirdClient", new FbMigrationSqlGenerator());
}
}
private static FbConnection connection
{
get
{
FbConnectionStringBuilder b = new FbConnectionStringBuilder
{
ServerType = FbServerType.Embedded,
UserID = "sysdba",
Password = "masterkey",
DataSource = "localhost",
Database = "MYMigrations.fdb",
ClientLibrary = "fbclient.dll",
Dialect = 3
};
return new FbConnection(b.ToString());
}
}
[![enter image description here][1]][1]
[1]: https://i.stack.imgur.com/ZqwSn.png
.net-core firebird-3.0
share edit delete flag
edited 17 mins ago
asked 28 mins ago
DronBoard
5311 silver badge99 bronze badges
'No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See go.microsoft.com/fwlink/?LinkId=260882 for more information.
https://stackoverflow.com/questions/63449608/no-entity-framework-provider-found-for-the-ado-net-provider-with-invariant-name
--
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
|
|
From: Asmita (JIRA) <tr...@fi...> - 2020-08-04 18:08:56
|
FirebirdSql.Data.FirebirdClient.dll throws exception with x64 embedded drivers
-------------------------------------------------------------------------------
Key: DNET-946
URL: http://tracker.firebirdsql.org/browse/DNET-946
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 4.6.2.0
Environment: Windows 10 ,Microsoft visual studio , C#
Reporter: Asmita
Assignee: Jiri Cincura
We are in process of converting project referencing FirebirdSql.Data.FirebirdClient.dll to Anycpu configuration and updating drivers to x64 version.
It is throwing exceptions
Test Name: AddColumnTest
Test FullName: Agilent.OpenLab.DbAbstraction.Tests.AlterTableTests.AddColumnTest
Test Source: \Tests\AlterTableTests.cs : line 45
Test Outcome: Failed
Test Duration: 0:00:00.162
Result StackTrace:
at FB_965910463_Class.isc_create_database(IntPtr[] statusVector, Int16 dbNameLength, Byte[] dbName, Int32& dbHandle, Int16 parmBufferLength, Byte[] parmBuffer, Int16 dbType)
at FB_965910463_Class.IFbClient.isc_create_database(IntPtr[] statusVector, Int16 dbNameLength, Byte[] dbName, Int32& dbHandle, Int16 parmBufferLength, Byte[] parmBuffer, Int16 dbType)
at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase(DatabaseParameterBuffer dpb)
at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase(String connectionString, Int32 pageSize, Boolean forcedWrites, Boolean overwrite)
at Agilent.OpenLab.DbAbstraction.Firebird.FirebirdDatabaseDeployer.CreateDatabase() in C:\_Projects\OLSS\SharedServices\Server\DbAbstraction\Firebird\FirebirdDatabaseDeployer.cs:line 29
at Agilent.OpenLab.DbAbstraction.Tests.AlterTableTests.SetUp() in C:\_Projects\OLSS\SharedServices\Server\DbAbstraction\Tests\AlterTableTests.cs:line 39
Result Message: System.BadImageFormatException : An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
Check list
Make sure Project configuration is Anycpu ; Done
Make sure Drivers referred are 64 bit : Done
Check Processor architecture of FirebirdSql.Data.FirebirdClient.dll is Anycpu i.e MSIL : Done
but it is not able to understand x64 drivers and failing to load it .
It is referring : Firebird driver version 2.5.4
Does it need x64 version of FirebirdSql.Data.FirebirdClient.dll? What could be wrong ?
--
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
|
|
From: Jan P. (JIRA) <tr...@fi...> - 2020-08-04 12:53:55
|
Inserting data after update results in "Column unknown" or "Must declare the variable '@px' errors
--------------------------------------------------------------------------------------------------
Key: DNET-945
URL: http://tracker.firebirdsql.org/browse/DNET-945
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 7.1.1.0
Environment: Windows 10, 16 GB RAM, i7-8850H CPU, Entity Framework Core 2.2.4, Firebird driver 7.1.1, Asp.Net Web Application with target framework 4.7.2, .Net Standard library 2.0
Reporter: Jan Pross
Assignee: Jiri Cincura
Priority: Blocker
Error is basically the same as in issue described here https://stackoverflow.com/questions/56357771/how-to-fix-must-declare-the-variable-with-firebirdsql-entityframeworkcore-fire
I've created simple web application where you can reproduce the issue https://filebin.net/cpfsuoh16xdl28xi
Steps to reproduce:
1. Build and run the web app
2. Repeat the same request e.g. 50 times by using some tool (if the requests are generated by refreshing the browser, the issue will not occur)
2. a. Capture the request e.g. with fiddler
2. b. Repeat the request from fiddler 50 times
3. An error occurs:
3. a.
Dynamic SQL Error
SQL error code = -206
Column unknown
P0
At line 2, column 9
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__32.MoveNext()
OR
3. b.
Must declare the variable '@p1'
at FirebirdSql.Data.FirebirdClient.FbCommand.UpdateParameterValues()
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__32.MoveNext()
Names of the columns and parameters can be different each time. Some requests will pass successfully some will result in beforehand mentioned errors. When an error occurs any other following request will result in an error unless the whole server is restarted.
We encountered this issue after switching some other parts of our solution to firebird. We are using 7.1.1 driver and we can not update to 7.5.0 for now (as it depends on EF core >= 3.0).
--
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
|
