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
|
|
From: Thomas B. <Tho...@As...> - 2013-06-18 09:26:32
|
Fields of this type show "unknown" type in Entity Developer, but I don't know whether this is a problem of ED or of the .NET Provider. Thank you for any hints! Thomas |
|
From: Thomas B. <Tho...@As...> - 2013-06-18 08:52:04
|
Mark Rotteveel <mark@...> writes: > > On 18-6-2013 07:41, Thomas Beckmann wrote: > > While connecting to FB 2.5 works fine, I'm getting "username and password > > are not defined"-error if I try to establish a connection to FB 3.0 via > > .NET-provider in VS 2012 or Entity Developer. > > > > The conncetion string generated looks as follows (username and password > > replaced): > > > > By default Firebird 3 only allows you to connect using the new > authentication and encryption mechanism. You have to enable legacy > authentication first, by editing the firebird.conf: > > AuthServer = Legacy_Auth, Srp, Win_Sspi > > (make sure to remove the # prefix). I am not entirely sure, but you > might need to add the user again to make sure the password is also > available in the legacy format. Thank you, Mark, I already tried that, but missed, that I was editing AuthClient - property :-( ... Now, it works! And: Yes, the user has to be added again. Many thanks and sunny days, Thomas |
|
From: Mark R. <ma...@la...> - 2013-06-18 08:25:11
|
On 18-6-2013 07:41, Thomas Beckmann wrote: > While connecting to FB 2.5 works fine, I'm getting "username and password > are not defined"-error if I try to establish a connection to FB 3.0 via > .NET-provider in VS 2012 or Entity Developer. > > I am surprised that the parameter names for the connection string that I > have to fill in, obviously changed (compared to 2.5). > > The conncetion string generated looks as follows (username and password > replaced): > > datasource=localhost;port=3051;database=D:\user\AMS\ASSCLOUD1.FDB;userid=***; > password=***;role=ADMIN;charset=ISO8859_1;clientlibrary="C:\Program > Files (x86)\srv\Firebird_3_0\fbclient.dll";dialect=3;servertype=Default > > A connection via isql or IBExpert works nicely. > > I'm using "WI-T3.0.0.30435 Firebird 3.0 Unstable" with W7/64 and > 32bit-version of DDEX-Provider for VS 2012. > > I'd really appreciate any hints! By default Firebird 3 only allows you to connect using the new authentication and encryption mechanism. You have to enable legacy authentication first, by editing the firebird.conf: AuthServer = Legacy_Auth, Srp, Win_Sspi (make sure to remove the # prefix). I am not entirely sure, but you might need to add the user again to make sure the password is also available in the legacy format. Mark -- Mark Rotteveel |
|
From: Thomas B. <Tho...@As...> - 2013-06-18 05:50:12
|
While connecting to FB 2.5 works fine, I'm getting "username and password are not defined"-error if I try to establish a connection to FB 3.0 via .NET-provider in VS 2012 or Entity Developer. I am surprised that the parameter names for the connection string that I have to fill in, obviously changed (compared to 2.5). The conncetion string generated looks as follows (username and password replaced): datasource=localhost;port=3051;database=D:\user\AMS\ASSCLOUD1.FDB;userid=***; password=***;role=ADMIN;charset=ISO8859_1;clientlibrary="C:\Program Files (x86)\srv\Firebird_3_0\fbclient.dll";dialect=3;servertype=Default A connection via isql or IBExpert works nicely. I'm using "WI-T3.0.0.30435 Firebird 3.0 Unstable" with W7/64 and 32bit-version of DDEX-Provider for VS 2012. I'd really appreciate any hints! Thank you, Thomas |
|
From: Pierre A. <pie...@op...> - 2013-06-15 20:31:59
|
Hi Jiri,
We have gone the "try to connect to database" route. Trying to create
the database requires that you also cleanup afterwards in order not to
leave an empty database lying around; and what if you can't delete it?
Or what if some other process tries to do the same thing at the same
time?
Obviously, trying to connect to the database might fail, but then, if
it fails, that's as good as no database in my case: I can't access to
the data!
Pierre
-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...]
Sent: mercredi 5 juin 2013 15:47
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider] Checking database existence
Hi *,
I was recently rethinking some stuff we do (or not) support for Entity
Framework. One think we don't support is checking database existence
(migrations, initializers, ...). I know the API itself doesn't support
it, but as I checked how other tools and products are solving it it's
basically always just trying to pen the connection. if it fails it
supposes the database does not exists. I also found and idea to try to
create the database (without rewriting). There are, for both, cases
when it can fail and hence returning false even it the database
actually does exist - like not having enough permission (from top of
my head).
What do you think? Do you think it's a good idea to add support like
this? And if so what's better approach. Try to connect or try to
create? Where do you see all the false negatives? Are these
acceptable?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
----------------------------------------------------------------------------
--
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Herman S. (JIRA) <tr...@fi...> - 2013-06-11 14:48:35
|
Firebird .NET Data Provider reads Guids incorrectly on little-endian systems
----------------------------------------------------------------------------
Key: DNET-509
URL: http://tracker.firebirdsql.org/browse/DNET-509
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Reporter: Herman Schoenfeld
Assignee: Jiri Cincura
On a little-endian systems Guids values are not being correctly hydrated by the Firebird ADO.NET provider.
For example, a user may insert a Guid via a query of the form
..." INSERT INTO MyTable VALUES (UUID_TO_CHAR(" + guid.ToString() + " ))"
But when that user loads the Guid back via the provider (on a little endian system), the value is different than the correct value stored on the database value.
The problem is that Uuid & Guid vary in storage format but not it presentation format.The The CHAR(16) octets contain the Uuid bytes in big endian layout. When hydrating these bytes into a Guid, the provider does not compensate for the Guid's storage of certain parts as the native endian. The correct way to parse the uuid into a guid is:
var rfc4122bytes = ... uuid byte array returned from firebird ..
if (BitConverter.IsLittleEndian) {
Array.Reverse(rfc4122bytes, 0, 4);
Array.Reverse(rfc4122bytes, 4, 2);
Array.Reverse(rfc4122bytes, 6, 2);
}
var guid = new Guid(rfc4122bytes);
Suspected location of bug is in class 'DbValue' method 'GetGuid'.
As a work-around, I've written a wrapper for the FbDataReader which will correct the invalid guid value.
public class FirebirdCorrectingReader : IDataReader {
private readonly IDataReader _decoratedReader;
public FirebirdCorrectingReader(IDataReader decoratedReader) {
_decoratedReader = decoratedReader;
}
#region IDataReader Impl
public void Dispose() {
_decoratedReader.Dispose();
}
public string GetName(int i) {
return _decoratedReader.GetName(i);
}
public string GetDataTypeName(int i) {
return _decoratedReader.GetDataTypeName(i);
}
public Type GetFieldType(int i) {
return _decoratedReader.GetFieldType(i);
}
public object GetValue(int i) {
var result = _decoratedReader.GetValue(i);
if (result is Guid) {
result = CorrectGuid((Guid)result);
}
return result;
}
public int GetValues(object[] values) {
return _decoratedReader.GetValues(values);
}
public int GetOrdinal(string name) {
return _decoratedReader.GetOrdinal(name);
}
public bool GetBoolean(int i) {
return _decoratedReader.GetBoolean(i);
}
public byte GetByte(int i) {
return _decoratedReader.GetByte(i);
}
public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length) {
return _decoratedReader.GetBytes(i, fieldOffset, buffer, bufferoffset, length);
}
public char GetChar(int i) {
return _decoratedReader.GetChar(i);
}
public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length) {
return _decoratedReader.GetChars(i, fieldoffset, buffer, bufferoffset, length);
}
public Guid GetGuid(int i) {
return CorrectGuid(_decoratedReader.GetGuid(i));
}
public short GetInt16(int i) {
return _decoratedReader.GetInt16(i);
}
public int GetInt32(int i) {
return _decoratedReader.GetInt32(i);
}
public long GetInt64(int i) {
return _decoratedReader.GetInt64(i);
}
public float GetFloat(int i) {
return _decoratedReader.GetFloat(i);
}
public double GetDouble(int i) {
return _decoratedReader.GetDouble(i);
}
public string GetString(int i) {
return _decoratedReader.GetString(i);
}
public decimal GetDecimal(int i) {
return _decoratedReader.GetDecimal(i);
}
public DateTime GetDateTime(int i) {
return _decoratedReader.GetDateTime(i);
}
public IDataReader GetData(int i) {
return _decoratedReader.GetData(i);
}
public bool IsDBNull(int i) {
return _decoratedReader.IsDBNull(i);
}
public int FieldCount { get { return _decoratedReader.FieldCount; } }
object IDataRecord.this[int i] {
get { return _decoratedReader[i]; }
}
object IDataRecord.this[string name] {
get {return _decoratedReader[name]; }
}
public void Close() {
_decoratedReader.Close();
}
public DataTable GetSchemaTable() {
return _decoratedReader.GetSchemaTable();
}
public bool NextResult() {
return _decoratedReader.NextResult();
}
public bool Read() {
return _decoratedReader.Read();
}
public int Depth { get { return _decoratedReader.Depth; } }
public bool IsClosed { get { return _decoratedReader.IsClosed; } }
public int RecordsAffected { get { return _decoratedReader.RecordsAffected; } }
#endregion
public static Guid CorrectGuid(Guid badlyParsedGuid) {
var rfc4122bytes = badlyParsedGuid.ToByteArray();
if (BitConverter.IsLittleEndian) {
Array.Reverse(rfc4122bytes, 0, 4);
Array.Reverse(rfc4122bytes, 4, 2);
Array.Reverse(rfc4122bytes, 6, 2);
}
return new Guid(rfc4122bytes);
}
}
--
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. <di...@ci...> - 2013-06-05 13:47:27
|
Hi *,
I was recently rethinking some stuff we do (or not) support for Entity
Framework. One think we don't support is checking database existence
(migrations, initializers, ...). I know the API itself doesn't support
it, but as I checked how other tools and products are solving it it's
basically always just trying to pen the connection. if it fails it
supposes the database does not exists. I also found and idea to try to
create the database (without rewriting). There are, for both, cases
when it can fail and hence returning false even it the database
actually does exist - like not having enough permission (from top of
my head).
What do you think? Do you think it's a good idea to add support like
this? And if so what's better approach. Try to connect or try to
create? Where do you see all the false negatives? Are these
acceptable?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Wojciech K. (JIRA) <tr...@fi...> - 2013-06-05 08:40:34
|
Add support for EF4 on net.framework 4.5 - outer apply. (on 4.0 Works great)
----------------------------------------------------------------------------
Key: DNET-508
URL: http://tracker.firebirdsql.org/browse/DNET-508
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Reporter: Wojciech Kmiecik
Assignee: Jiri Cincura
Hi.
This bug is connected to DNET-497, DNET-462.
When you have .NET framework 4.5 installed, Entity framework is generating queries with outer apply statement.
BUT when framework is downgraded to 4.0 Queries are OK.
We discovered this fact when investigating DNET-497 because OUTER APPLY statements was generated only on single developer machine.
Whole investigation process :
http://stackoverflow.com/questions/16650954/entity-framework-generates-different-queries-on-different-workstations
--
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. <di...@ci...> - 2013-06-04 13:34:40
|
Done. DNET-507
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2013-06-04 13:34:34
|
Remove T4 SSDL to FB template and rework it to pure C# code
-----------------------------------------------------------
Key: DNET-507
URL: http://tracker.firebirdsql.org/browse/DNET-507
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 3.0.2.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...> - 2013-05-31 11:38:39
|
Support for EF's Migrations
---------------------------
Key: DNET-506
URL: http://tracker.firebirdsql.org/browse/DNET-506
Project: .NET Data provider
Issue Type: New Feature
Components: Entity Framework support
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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...> - 2013-05-31 08:44:45
|
[ http://tracker.firebirdsql.org/browse/DNET-499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-499:
-------------------------------
> Backup problem in Windows 7
> ---------------------------
>
> Key: DNET-499
> URL: http://tracker.firebirdsql.org/browse/DNET-499
> Project: .NET Data provider
> Issue Type: Bug
> Components: ADO.NET Provider
> Affects Versions: 2.5.1
> Environment: Windows 7
> Reporter: Hayatuddeen Sadiq
> Assignee: Jiri Cincura
>
> Hello,
> I have a desktop application that the backup is working fine but when i move it to window 7 the backup is not working.
> This is the code:
> Private Sub BackupDatabase(ByVal backupFile As String)
> 'Dim cs As New FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder
> 'cs.UserID = "sysdba"
> 'cs.Password = "masterkey"
> 'cs.Database = "localhost:ndahrm"
> Dim bkp As New FirebirdSql.Data.Services.FbBackup
> bkp.ConnectionString = DB.ConnectionString
> Dim bp As New FirebirdSql.Data.Services.FbBackupFile(backupFile, 2048)
> bkp.BackupFiles.Add(bp)
> bkp.Verbose = True
> bkp.Options = FirebirdSql.Data.Services.FbBackupFlags.IgnoreLimbo
> Try
> bkp.Execute()
> Timer1.Stop()
> prgBar.Value = 100
> MessageBox.Show("Processing Completed Successfully.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information)
> Catch ex As Exception
> MessageBox.Show(ex.Message)
> End Try
> End Sub
> And this is the error code:
> Invalid clumplet buffer structure: buffer end before end of clumplet - no length component
--
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...> - 2013-05-31 08:39:04
|
Async support
-------------
Key: DNET-505
URL: http://tracker.firebirdsql.org/browse/DNET-505
Project: .NET Data provider
Issue Type: Sub-task
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...> - 2013-05-31 08:39:00
|
Support for EF6
---------------
Key: DNET-503
URL: http://tracker.firebirdsql.org/browse/DNET-503
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider, Entity Framework support
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...> - 2013-05-31 08:38:54
|
Implement IDbConnectionFactory
------------------------------
Key: DNET-504
URL: http://tracker.firebirdsql.org/browse/DNET-504
Project: .NET Data provider
Issue Type: Sub-task
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. <di...@ci...> - 2013-05-31 08:08:54
|
Hi *,
I'm thinking about deprecating T4 template that is available for Model
First when you want to generate the model. It's a PIA to maintain it.
It needs to be completely independent from other code (because you
need only it when running it inside VS). The T4 is a good for
templating. But thanks to EF's way of working we have a fair amount of
logic there, which gets worse with every new version of EF.
I have strong doubts somebody ever used it (questioning also Model
First's itself usage). Because you need to 1) get it from somewhere
(it's not inside VS), 2) put it into one of basically three
directories VS is looking into, 3) select it in EF's designer. Then
you can use it. And it's purely developer-side stuff.
On the other hand, I still manage support for
ObjectContext.CreateDatabaseScript. That works and will work. Also we
have now EF's Migrations (currently not RTMed for Firebird). Not the
same stuff, but there's a big overlap and it's even more powerful.
Thus if I'll not receive any objections, I'll remove it.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: LIKORIS L. (JIRA) <tr...@fi...> - 2013-05-28 07:05:41
|
FbRemoteEvent problem
---------------------
Key: DNET-502
URL: http://tracker.firebirdsql.org/browse/DNET-502
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.0.2.0
Environment: VS 2010, Windows 7, Firebird 2.5.2
Reporter: LIKORIS Ltd.
Assignee: Jiri Cincura
The application is very often does not respond to events.
In my application, the user can cause the child windows, which immediately begin wiretapping of certain events. If the user opens two child windows, the program sometimes starts to ignore the event.
Moreover, if the application is run from a computer that is running Firebird error does not occur.
Fix the problem but could not. While sdealal this:
In file GdsEventManager.cs to add a line
...
operation = this.database.ReadResponse();
Thead.Sleep(10); //added line
switch (operation)
{
...
and the error does not occur.
The problem in the streams!
--
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: Muthu A. <pea...@ho...> - 2013-05-21 12:03:47
|
In my App.config I have,
<system.data>
<DbProviderFactories>
<remove invariant="FirebirdSql.Data.FirebirdClient" />
<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient,Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" />
</DbProviderFactories>
</system.data>
<connectionStrings>
<clear />
<add name="Entities" providerName="FirebirdSql.Data.FirebirdClient" connectionString="User=SYSDBA;Password=masterkey;Database=C:\Pearlpos\Data\Store.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connectionlifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;" />
</connectionStrings>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="FirebirdSql.Data.FirebirdClient" />
</parameters>
</defaultConnectionFactory>
</entityFramework>
In my Machine.config I have,
<configSections>
...
<section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
....
</configSections>
<system.data>
<DbProviderFactories>
<add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>
</DbProviderFactories>
</system.data>
Do I have to configure in my customer system...
Thanks...
-----Original Message-----
From: ji...@ci... [mailto:ji...@ci...] On Behalf Of Jiri Cincura
Sent: Tuesday, May 21, 2013 12:36 AM
To: pea...@ho...; For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Unable to find the requested .Net Framework Data Provider
The provider factory is not registered in app.config (or machine.config).
--
Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2013-05-21 06:29:22
|
The provider factory is not registered in app.config (or machine.config).
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Muthu A. <pea...@ho...> - 2013-05-20 22:32:27
|
I am using EF Code First in VS 2012 Ultimate with Firebird Dot Net Provider
3.0.2.0.
I need to change the connection string run time as to connect to different
machine as required.
In order to do that, I store the connection string in settings and create
the DBProviderFactory in code and pass the connection string to it. It is
working fine in my dev machine.
Here is the code that is use to create my connection,
private static DbConnection CreateDbConnection(string providerName, string
connectionString)
{
// Assume failure.
DbConnection connection = null;
// Create the DbProviderFactory and DbConnection.
if (connectionString != null)
{
try
{
var factory =
DbProviderFactories.GetFactory(providerName);
connection = factory.CreateConnection();
if (connection != null) connection.ConnectionString =
connectionString;
}
catch (Exception ex)
{
// Set the connection to null if it was not created.
connection = null;
MessageBox.Show(EmailException.FormatException(ex));
}
}
// Return the connection.
return connection;
}
But in my customer machine (Firebird Dot Net Provider 3.0.2.0. installed) it
throws "Unable to Find .Net Framework Data Provider". Here is the stack
An Unhandled Exception has occured in PearlPOS
----------------------------------------------
System.ArgumentException: Unable to find the requested .Net Framework Data
Provider. It may not be installed.
at System.Data.Common.DbProviderFactories.GetFactory(String
providerInvariantName)
at
System.Data.Entity.Internal.LazyInternalConnection.CreateConnectionFromProvi
derName(String providerInvariantName)
at
System.Data.Entity.Internal.LazyInternalConnection.InitializeFromConnectionS
tringSetting(ConnectionStringSettings appConfigConnection)
at
System.Data.Entity.Internal.LazyInternalConnection.TryInitializeFromAppConfi
g(String name, AppConfig config)
at System.Data.Entity.Internal.LazyInternalConnection.Initialize()
at System.Data.Entity.Internal.LazyInternalConnection.get_Connection()
at System.Data.Entity.Internal.LazyInternalContext.get_Connection()
at Pearlpos.Data.Utils.Database.get_DataSource()
at My.MyApplication.ConnectDatabase()
at My.MyApplication.Application_Startup(Object sender, StartupEventArgs
e)
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)
----------------------------------------------
Thanks,
Muthu Annamalai
|
|
From: Pavel (JIRA) <tr...@fi...> - 2013-05-16 11:11:11
|
NullReferenceException with Connection.GetSchema
-------------------------------------------------
Key: DNET-501
URL: http://tracker.firebirdsql.org/browse/DNET-501
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 2.5.2
Environment: .NET Compact Framework 3.5 SP2/ Firebird 2.5.1
Reporter: Pavel
Assignee: Jiri Cincura
Priority: Blocker
I try to use GetSchema in FirebirdClient-NETCF-2.5.2:
command.Connection.GetSchema("Generators"); - NullReferenceException Exception
at FirebirdSql.Data.Schema.FbSchemaFactory.GetSchema(FbConnection connection, String collectionName, String[] restrictions)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.GetSchema(String collectionName, String[] restrictions)
at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName, String[] restrictions)
at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String collectionName)
// Also the same exception:
DataTable parmsDataTable = connection.GetSchema("procedurearameters", new string[] { null, null, spName });
return parmsDataTable.Rows.Count;
// Also the same exception:
FbCommandBuilder.DeriveParameters(command);
Tests runs on real device with WinCE 6.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
|
|
From: M. A. C. <mc...@mc...> - 2013-05-09 12:59:28
|
Hello Muthu,<br><br> I would say that your issue is at this part of the code:<br><br> <font size="2"><font face="Consolas"><font color="#000000">: l.</font><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTITEMs</span></font></font><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">FirstOrDefault</span><span style="color: black; font-family: Consolas; font-size: 10pt;">().</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT<br><br> and/or<br><br> <font color="#000000">(l.</font><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Any</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span><br><br> Marco Castro</span><br><br><b>----- Original Message -----</b><br>
<b>From:</b> Muthu Annamalai [mailto:pea...@ho...]<br>
<b>To:</b> fir...@li...<br>
<b>Sent:</b> Wed, 8 May 2013 22:34:13 -0500<br>
<b>Subject:</b> [Firebird-net-provider] LINQ Outer Error<br><br>
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Trebuchet MS","sans-serif";
color:#3366FF;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--><div class="WordSection1"><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">I Use VS 2012 Ultimate, EF 5.0 Code First, Firebird Provider 3.0.2.0</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">When I use the following LINQ query</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal" style="background: white;"><span style="color: blue; font-family: Consolas; font-size: 10pt;">public</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">IQueryable</span><span style="color: black; font-family: Consolas; font-size: 10pt;"><</span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">SalesTotalCount</span><span style="color: black; font-family: Consolas; font-size: 10pt;">> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ZDepartmentSalesPeriod</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">get</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">return</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> (</span><span style="color: blue; font-family: Consolas; font-size: 10pt;">from</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">in</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReceiptRepository</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">NoTracking</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">where</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDATE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">>=</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReportEndDate</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> &</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDATE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;"><=</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ReportEndDate</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">from</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> l </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">in</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> r.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTLINEs</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">let</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> department =</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEMSTYLE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> != </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">null</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> ? l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEMSTYLE</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">ITEM</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">CATEGORY</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> : l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTITEMs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">FirstOrDefault</span><span style="color: black; font-family: Consolas; font-size: 10pt;">().</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENT</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">group</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> l </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">by</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> department</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">into</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> receiptLines</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">select</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: blue; font-family: Consolas; font-size: 10pt;">new</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: darkblue; font-family: Consolas; font-size: 10pt;">SalesTotalCount</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> {</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Name</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Key</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DEPARTMENTNAME</span><span style="color: black; font-family: Consolas; font-size: 10pt;">,</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Total</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = (</span><span style="color: blue; font-family: Consolas; font-size: 10pt;">double</span><span style="color: black; font-family: Consolas; font-size: 10pt;">)receiptLines.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Sum</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(l =></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">QUANTITY</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> * l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">PRICE</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> -</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> (l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Any</span><span style="color: black; font-family: Consolas; font-size: 10pt;">()</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> ? l.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">RECEIPTDISCOUNTs</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Sum</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(d => d.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">DISCOUNT</span><span style="color: black; font-family: Consolas; font-size: 10pt;">)</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> : 0)),</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Count</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: darkcyan; font-family: Consolas; font-size: 10pt;">Count</span><span style="color: black; font-family: Consolas; font-size: 10pt;">(),</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> </span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Listed</span><span style="color: black; font-family: Consolas; font-size: 10pt;"> = receiptLines.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">Key</span><span style="color: black; font-family: Consolas; font-size: 10pt;">.</span><span style="color: purple; font-family: Consolas; font-size: 10pt;">LISTED</span><span style="color: black; font-family: Consolas; font-size: 10pt;"></span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> });</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> }</span></p><p class="MsoNormal" style="background: white;"><span style="color: black; font-family: Consolas; font-size: 10pt;"> }</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;">Firebird is throwing this exception</span></p><p class="MsoNormal"><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"> </span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">SQL error code = -104</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">Token unknown - line 35, column 4</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><b><span style="background: white; color: red; font-family: Consolas; font-size: 9pt; mso-highlight: white;">OUTER</span></b><span style="background: white; color: red; font-family: Consolas; font-size: 9pt; mso-highlight: white;"> </span><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">---&amp;gt; Dynamic SQL Error</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">SQL error code = -104</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">Token unknown - line 35, column 4</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;">OUTER</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)</span></p><p class="MsoNormal" style="-ms-text-autospace:;"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)</span></p><p class="MsoNormal"><span style="background: white; color: rgb(30, 30, 30); font-family: Consolas; font-size: 9pt; mso-highlight: white;"> at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error</span><span style="color: rgb(51, 102, 255); font-family: "Trebuchet MS","sans-serif"; font-size: 10pt;"></span></p></div>
|
|
From: Jiri C. <di...@ci...> - 2013-05-09 04:37:21
|
On Thu, May 9, 2013 at 5:34 AM, Muthu Annamalai
<pea...@ho...> wrote:
> Firebird is throwing this exception
>
>
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER ---&gt; Dynamic SQL Error
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER
>
> at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
> behavior)
>
> at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
> behavior)
>
> at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
>
> at
> System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior
> behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException,
> FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error
Yes. This query is very likely to end up with OUTER APPLY in the
generated statement and this is not supported by Firebird (yet). You
have to rewrite the query.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Muthu A. <pea...@ho...> - 2013-05-09 03:34:21
|
I Use VS 2012 Ultimate, EF 5.0 Code First, Firebird Provider 3.0.2.0
When I use the following LINQ query
public IQueryable<SalesTotalCount> ZDepartmentSalesPeriod
{
get
{
return (from r in ReceiptRepository.NoTracking()
where r.RECEIPTDATE >= ReportEndDate &
r.RECEIPTDATE <= ReportEndDate
from l in r.RECEIPTLINEs
let department =
l.ITEMSTYLE != null
? l.ITEMSTYLE.ITEM.CATEGORY.DEPARTMENT
: l.RECEIPTITEMs.FirstOrDefault().DEPARTMENT
group l by department
into receiptLines
select new SalesTotalCount
{
Name = receiptLines.Key.DEPARTMENTNAME,
Total = (double)receiptLines.Sum(l =>
l.QUANTITY * l.PRICE -
(l.RECEIPTDISCOUNTs.Any()
?
l.RECEIPTDISCOUNTs.Sum(d => d.DISCOUNT)
:
0)),
Count = receiptLines.Count(),
Listed = receiptLines.Key.LISTED
});
}
}
Firebird is throwing this exception
SQL error code = -104
Token unknown - line 35, column 4
OUTER ---&gt; Dynamic SQL Error
SQL error code = -104
Token unknown - line 35, column 4
OUTER
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio
r behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at
System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(Entity
Command entityCommand, CommandBehavior
behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.C
ommon.IscException, FirebirdSql.Data.FirebirdClient, Version=3.0.2.0,
Culture=neutral,
PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error
|
|
From: Jiri C. <di...@ci...> - 2013-05-04 07:29:22
|
On Fri, May 3, 2013 at 4:17 PM, Yiannis Bourkelis <yia...@gm...> wrote:
> v2.7.7 is the most recent version that requires only NET Framework 2.0?
> (file: NETProvider-2.7.7-NET20.7z)
Yes.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
211 messages has been excluded from this view by a project administrator.
