Menu
▾
▴
firebird-net-provider
|
From: Rick R. <Rick@LakeValleySeed.com> - 2008-12-27 19:39:28
|
Firebird server v 2.1.17910
FirebirdClient.dll v 2.1.0.0
Vista Pro
My firebird.log file is filled with hundreds entries like:
RICK2008 (Server) Sat Dec 27 13:21:07 2008
INET/inet_error: read errno = 10054
My connection string is:
initial catalog=???;user id=Sysdba;password=masterkey;role
name=Full_Access;data source=localhost;pooling=True;max pool size=100;min
pool size=10;packet size=8192;dialect=3
I see that this error is from a dropped connection, however since I am using
my local Firebird server in a test environment (data source=localhost), I
don't know how this can be.
I looked at a clients firebird log that has thousands of the same entries.
This appears to have started when I upgraded to Firebird server v 2.1.17910
When I clear the log and run a simple quick program that logs into the
database, there are maybe 7 new entries like above. If I do selects, etc,
more entries are added, although all selects/updates/inserts run with no
problem. There are no other entries in the log.
When I execute selects/updates/inserts from DBWorkbench, a utility program,
there are no entries into the log.
Any idea why this is happening?
Regards,
Rick
|
|
From: Pham H. Le Q. P. <phu...@so...> - 2009-01-02 01:52:20
|
I get lastest source code FB.net 2.5 and build, it can't create database in Embedded Server. |
|
From: Pham H. Le Q. P. <phu...@so...> - 2009-01-02 01:52:24
|
I get lastest source code FB.net 2.5 and build, it can't create database in Embedded Server. _____ From: Rick Roen [mailto:Rick@LakeValleySeed.com] Sent: Sunday, December 28, 2008 02:39 To: fir...@li... Subject: [Firebird-net-provider] log filled with INET error 10054 Firebird server v 2.1.17910 FirebirdClient.dll v 2.1.0.0 Vista Pro My firebird.log file is filled with hundreds entries like: RICK2008 (Server) Sat Dec 27 13:21:07 2008 INET/inet_error: read errno = 10054 My connection string is: initial catalog=???;user id=Sysdba;password=masterkey;role name=Full_Access;data source=localhost;pooling=True;max pool size=100;min pool size=10;packet size=8192;dialect=3 I see that this error is from a dropped connection, however since I am using my local Firebird server in a test environment (data source=localhost), I don't know how this can be. I looked at a clients firebird log that has thousands of the same entries. This appears to have started when I upgraded to Firebird server v 2.1.17910 When I clear the log and run a simple quick program that logs into the database, there are maybe 7 new entries like above. If I do selects, etc, more entries are added, although all selects/updates/inserts run with no problem. There are no other entries in the log. When I execute selects/updates/inserts from DBWorkbench, a utility program, there are no entries into the log. Any idea why this is happening? Regards, Rick |
|
From: Jiri C. <di...@ci...> - 2009-01-03 23:15:46
|
HI, I'll look at it. Maybe some protocol problems.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Pham H. Le Q. P. <phu...@so...> - 2009-01-05 06:20:06
|
I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create database in Embbedded mode. But it can't. Please help me. Thanks |
|
From: Dean H. <dea...@dl...> - 2009-01-05 08:32:11
|
> I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create > database in Embbedded mode. But it can't. Please help me. You haven't described the problem. HOW do you try to create a database using the FbBatchScript (please provide the code you're using). HOW does it fail? Does it produce an error message (if so, what does the error say)? Does it simply do nothing and no database is created? Something else? Lastly, with the embedded server, you need to use FbConnection.CreateDatabase to actually create the database file, and then you can use FbBatchScript to populate it with tables/sproc/etc. Dean. |
|
From: Pham H. Le Q. P. <phu...@so...> - 2009-01-05 08:45:31
|
I think, FbBatchScript not support CREATE DATABASE in Embedded Server? -----Original Message----- From: Dean Harding [mailto:dea...@dl...] Sent: Monday, January 05, 2009 13:33 To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] FbBatchScript can't CREATE DATABASEin Embedded server > I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create > database in Embbedded mode. But it can't. Please help me. You haven't described the problem. HOW do you try to create a database using the FbBatchScript (please provide the code you're using). HOW does it fail? Does it produce an error message (if so, what does the error say)? Does it simply do nothing and no database is created? Something else? Lastly, with the embedded server, you need to use FbConnection.CreateDatabase to actually create the database file, and then you can use FbBatchScript to populate it with tables/sproc/etc. Dean. ---------------------------------------------------------------------------- -- _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Dean H. <dea...@dl...> - 2009-01-05 21:52:38
|
> I think, FbBatchScript not support CREATE DATABASE in Embedded Server? Right. As I said, the embedded server works on database files directly, so you need to create the database with FbConnection.CreateDatabase. You can still use FbBatchScript to populate the database with tables and so on. Dean. |
|
From: Rick R. <Rick@LakeValleySeed.com> - 2009-01-09 14:16:17
|
Did you have a chance to look at this yet?
Rick
-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...]
Sent: Saturday, January 03, 2009 4:16 PM
To: Ri...@la...; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] log filled with INET error 10054
HI, I'll look at it. Maybe some protocol problems.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2009-01-09 14:54:47
|
On Fri, Jan 9, 2009 at 15:15, Rick Roen <Ri...@la...> wrote:
> Did you have a chance to look at this yet?
Not yet. I'm working now on new FB2.1 protocol. I'll check the problem
during next week, together with protocol work.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2009-01-14 14:50:56
|
On Fri, Jan 9, 2009 at 15:15, Rick Roen <Ri...@la...> wrote:
> Did you have a chance to look at this yet?
Hi I looked into this with my latest build, and the problem is gone. I
don't know what changed (I had these errors in log too, but I thought
that's because of killing apps during debug), but it's not there
anymore. :) Maybe I've fixed by accident (LOL "fixed by accident")
something together with work on FB2.1 protocol. :)
Anyway, to be sure, can you grab latest weekly build and try?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2009-01-14 14:57:57
|
OK I'm not so lucky. :) The problem is in connection pooling that was
turned off on my connection string. I'll look at the problem.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2009-01-05 21:52:37
|
On Mon, Jan 5, 2009 at 07:32, Dean Harding <dea...@dl...> wrote:
> You haven't described the problem. HOW do you try to create a database using
> the FbBatchScript (please provide the code you're using). HOW does it fail?
> Does it produce an error message (if so, what does the error say)? Does it
> simply do nothing and no database is created? Something else?
Dean is right. Without any further info is this just ... useless. No
description, no fix.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2009-01-05 22:10:24
|
On Mon, Jan 5, 2009 at 22:52, Dean Harding <dea...@dl...> wrote:
>> I think, FbBatchScript not support CREATE DATABASE in Embedded Server?
>
> Right. As I said, the embedded server works on database files directly, so
> you need to create the database with FbConnection.CreateDatabase. You can
> still use FbBatchScript to populate the database with tables and so on.
FbBatchExecution is in fact internally calling
FbConnection.CreateDatabase, but there's no way to tell thru standard
command:
// CREATE {DATABASE | SCHEMA} 'filespec'
// [USER 'username' [PASSWORD 'password']]
// [PAGE_SIZE [=] int]
// [LENGTH [=] int [PAGE[S]]]
// [DEFAULT CHARACTER SET charset]
// [<secondary_file>];
that it should use embedded server, so it will use isc_create_database
from fbembed.dll.
What comes to my mind - but not tested, just guess that it may work -
is to provide dummy connection string with ServerType=1. Then maybe
the create database isql command will not rewrite the ServerType so it
will be done using embedded server.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: nieurig <ni...@ya...> - 2009-01-14 19:22:54
|
>
>
>OK I'm not so lucky. :) The problem is in connection pooling that was
>turned off on my connection string. I'll look at the problem.
>
Well,
I got this error too, only when pooling is set to true.
Depends on the firebird server-type I get
INET/inet_error: read errno = 10054
or
XNET error (xnet:2044) connection lost: another side is dead
Searching on web I found this
http://tracker.firebirdsql.org/browse/CORE-1196
I thought it is a firebird problem ?
Best wishes.
Niels
|
|
From: Jiri C. <di...@ci...> - 2009-01-14 19:44:16
|
On Wed, Jan 14, 2009 at 20:22, nieurig <ni...@ya...> wrote:
> I thought it is a firebird problem ?
No it's a problem in FirebirdClient. I've fixed it. Tomorrow I'll commit fix.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Mercea P. <pau...@al...> - 2009-01-15 06:27:33
|
> OK I'm not so lucky. :) The problem is in connection pooling that was > turned off on my connection string. I'll look at the problem. [PM] This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to or is something new? Regards, Paul |
|
From: Jiri C. <di...@ci...> - 2009-01-15 09:02:35
|
On Thu, Jan 15, 2009 at 07:11, Mercea Paul <pau...@al...> wrote: > This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to > or is something new? It's something different. :) -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
|
From: Jiri C. <di...@ci...> - 2009-01-15 09:04:22
|
Should be fixed now. You can check weekly build.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Pham H. Le Q. P. <phu...@so...> - 2009-05-19 07:51:35
|
I use FB 2.1.2 Embedded server, FB.Net Provider 2.5 Beta 2, our program thown following bug: Csla.DataPortalException: DataPortal.Update failed (System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.String.System.IConvertible.ToInt32(IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.XSDSchema.HandleElementColumn(XmlSchemaElement elem, DataTable table, Boolean isBase) at System.Data.XSDSchema.HandleParticle(XmlSchemaParticle pt, DataTable table, ArrayList tableChildren, Boolean isBase) at System.Data.XSDSchema.HandleComplexType(XmlSchemaComplexType ct, DataTable table, ArrayList tableChildren, Boolean isNillable) at System.Data.XSDSchema.InstantiateTable(XmlSchemaElement node, XmlSchemaComplexType typeNode, Boolean isRef) at System.Data.XSDSchema.HandleTable(XmlSchemaElement node) at System.Data.XSDSchema.HandleDataSet(XmlSchemaElement node, Boolean isNewDataSet) at System.Data.XSDSchema.LoadSchema(XmlSchemaSet schemaSet, DataSet ds) at System.Data.DataSet.ReadXSDSchema(XmlReader reader, Boolean denyResolving) at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving) at System.Data.DataSet.ReadXml(Stream stream) 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) at FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand command) at Tony.Data.Database.Database.DeriveParameters(DbCommand DbCommand) at Tony.Core.Business.Report.CMDReport.AddParameters(DbCommand DbCommand) at Tony.Core.Business.Report.CMDReport.LoadData() at Tony.Core.Business.Report.CMDReport.DataPortal_Execute()) Please help me, thanks. |
|
From: Jiri C. <di...@ci...> - 2009-05-19 08:36:42
|
And what's the test-case?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
Thanks for helping keep SourceForge clean.
X