Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Good, but did you read what I was talking about? IscException (and
FbException props). That's what matters, not all the rest you captured
- I'm not interested in runtime pieces etc. With this you're simply
wasting time off all people in list trying to help.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Tue, Jan 19, 2010 at 21:28, Russell R russ...@passfield.co.uk wrote:
Do you have any suggestions?
Debugger!
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
I am not sure how I can generate the error through the debugger. This error only occurs when the device is connected via a LAN cable. Is there software on Windows CE that will let me see the device from another PC on the LAN? From research, I would need to build a special version of CE that includes SMB. I don't have these facilities. Also, not sure that any more info will be forthcoming -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27240211.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Wed, Jan 20, 2010 at 12:26, Russell R russ...@passfield.co.uk wrote:
I am not sure how I can generate the error through the debugger. This error
only occurs when the device is connected via a LAN cable.
I don't know what kind of device you have. But I suppose you can
connect it via USB and attach debugger and still use LAN for
connection.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
We have a MC3090 connected via a Cradlepoint device. We can connect either via USB or LAN - not both at the same time. I download my executable by USB and then switch to LAN to run it -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27240571.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Wed, Jan 20, 2010 at 12:56, Russell R russ...@passfield.co.uk wrote:
I download my executable by USB
and then switch to LAN to run it
Hmm, then you're probably stuck with echo debugging.
The VS can connect to remote process, but I doubt it works for these devices.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
I don't think it is a resource or coding issue as when I run exactly the same software over a USB connection everything works okay. The handheld I am testing has a cradle that can plug straight into a router and picks up an IP address using DHCP. It is only when I connect via ethernet that I get the issue -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27222809.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Tried putting in a wait between each read and also between each read cycle (every 200 reads for the default fetch size), but I get the same issue. -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27223304.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Here is some cut down code that can repo the error (only when connected via
the LAN). I put it in program.cs:
namespace test
{
class Program
{
[MTAThread]
static void Main() {
FbConnection centralConn = null;
FbDataReader reader = null;
FbCommand centralCmd = null;
int rowcnt = 0;
try {
string connstr =
@Server=192.168.2.112;User=XX;Password=YY;Database=c:\demodata.fdb;Charset=UTF8;
string selcmd = @SELECT
UNIQUE_KEY,BATCH_NO,EVENT_TYPE,ACTUAL_DATE,STATUS,ENVIRONMENT_CODE,NURSERY_KEY,AREA_KEY,ACTUAL_BATCH_QTY,ACTUAL_SPACE_UNITS,SPACING_METHOD,TRAY_TYPE,PLANTS_PER_SPACE_UNIT,MADE_ACTUAL_BY,EVENT_FUNCTION,WASTE_OR_ADJUST_PCENT,SEQUENCE,PRIOR_PLANTS_PER_UNIT
FROM BATCH_EVENT;
centralConn = new FbConnection(connstr);
centralConn.Open();
centralCmd = ((FbConnection)centralConn).CreateCommand();
centralCmd.CommandText = selcmd;
reader = centralCmd.ExecuteReader();
while (reader.Read()) {
rowcnt++;
}
}
catch (Exception e) {
MessageBox.Show(e.ToString());
}
MessageBox.Show(rows read: +rowcnt.ToString());
reader.Close();
reader.Dispose();
centralCmd.Dispose();
centralConn.Close();
centralConn.Dispose();
}
}
}
Russell Rose
Passfield Data Systems Ltd
Tel: +44 1404 514401
--
View this message in context:
http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27224127.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Hi, At January-19-10, 6:01 AM, Russell R wrote: Tried putting in a wait between each read and also between each read cycle (every 200 reads for the default fetch size), but I get the same issue. Is it possible that it's a memory resource limit on the client that you are hitting? You did mention that it is a handheld device. What is the hardware configuration(especially memory size)? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Tue, Jan 19, 2010 at 12:00, Russell R russ...@passfield.co.uk wrote:
Here is some cut down code that can repo the error (only when connected via
the LAN). I put it in program.cs:
And what's the exception and stack trace you get?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Message Stack Trace at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() at StockCheck1.Program.Main() Print of whole exception FirebirdSql.Data.FirebirdClient.FbException --- FirebirdSql.Data.Common.IscException: IscException at FirebirdSql.Data.Client.Gds.XdrStream.ReadValue() at FirebirdSql.Data.Client.Gds.GdsStatement.ReadDataRow() at FirebirdSql.Data.Client.Gds.GdsStatement.Fetch() at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() at StockCheck1.Program.Main() at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() at StockCheck1.Program.Main() -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27227366.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
Tried with a FetchSize of 50 and still an error. This also works when run over a USB cable. It only errors when run over a LAN. It has 62Mb Ram and is running Windows CE 5.0 -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27227411.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
I have given the code I am using in thread: Russell R Jan 19, 2010; 11:00am Please check to make sure it is valid -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27227957.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Tue, Jan 19, 2010 at 16:16, Russell R russ...@passfield.co.uk wrote:
FirebirdSql.Data.FirebirdClient.FbException ---
FirebirdSql.Data.Common.IscException: IscException
at FirebirdSql.Data.Client.Gds.XdrStream.ReadValue()
at FirebirdSql.Data.Client.Gds.GdsStatement.ReadDataRow()
at FirebirdSql.Data.Client.Gds.GdsStatement.Fetch()
at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
at FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
at StockCheck1.Program.Main()
What has the IscException inside? I mean properties etc.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
not quit sure what you want, there is no errorcode or message. I can print out any bits of the exception that you want, but I'm not sure where to get the info. There is nothing in the Errors worth mentioning. I am trapping a FbException. Tell me what to print and I will print it. If not then tomorrow, I'll do a print that includes everything I can see -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27230202.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Tue, Jan 19, 2010 at 19:19, Russell R russ...@passfield.co.uk wrote:
I am trapping a FbException
I'm particularly interested in IscException.
I'll do a print that includes everything I can see
That the easiest way.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
I have tried all the following option, but I couldn't get any more
information. Do you have any suggestions?
//tw.WriteLine(Message);
//tw.WriteLine(e.Message);
tw.WriteLine(InnerException);
tw.WriteLine(e.InnerException);
//tw.WriteLine(Inner Message);
//tw.WriteLine(e.InnerException.Message);
//tw.WriteLine(Inner Exception Exception);
//tw.WriteLine(e.InnerException.InnerException.Message);
tw.WriteLine(Base Exception);
tw.WriteLine(e.GetBaseException().ToString());
tw.WriteLine(Base Exception Message);
tw.WriteLine(e.GetBaseException().Message);
//for (int i=0;ie.Errors.Count;i++){
//tw.WriteLine(Error +i.ToString());
//tw.WriteLine(Cl :+e.Errors[i].Class+, N
:+e.Errors[i].Number.ToString()+, Ln :+e.Errors[i].LineNumber+, Msg
:+e.Errors[i].Message);
//}
//tw.WriteLine(Stack Trace);
//tw.WriteLine(e.StackTrace);
tw.WriteLine(e.ToString());
--
View this message in context:
http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27232184.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firebird Client error during Fetch cycle
Hi This is the summary of all my other posts. Sorry for the confusion earlier, but I thought it best to consolidate. I am running the latest version of firebird client (2.5.1) built for .net 2.0 compact framework (Thanks Jakub). During a fetch cycle of a large select, I often get a 10054 error on the server and read error within the client code. This only happens when communicating via a LAN connection (never via a USB). I have tried many different error recovery tatics and none of them seem to work. Also the network I am using is only local and so there shouldn't be too much noise. Once I get the 10054 error, the only solution seems to be to close the connection and start a new one. However, this is quite time consuming on a Windows CE device and the server eventually crashes. Therefore I think the issue must be related to how the client/server interacts with TCP and this would mean looking into the client code. Whilst I have the code, I don't think I could readily find out what is going on. Please could someone help out Thanks a lot Russell Rose Passfield Data Systems Ltd Tel: +44 1404 514401 -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27213450.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
The 10054 is Connection reset by peer. MSDN describes:
An existing connection was forcibly closed by the remote host. This
normally results if the peer application on the remote host is
suddenly stopped, the host is rebooted, the host or remote network
interface is disabled, or the remote host uses a hard close (see
setsockopt for more information on the SO_LINGER option on the remote
socket). This error may also result if a connection was broken due to
keep-alive activity detecting a failure while one or more operations
are in progress. Operations that were in progress fail with
WSAENETRESET. Subsequent operations fail with WSAECONNRESET.
Yre you reading the data constantly? So some powersaving etc. stuff
isn't started. Are you in unattended mode or not?
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
The device has powersave switched off. Can you point me in the direction of how to configure the SO_LINGER option - maybe this will help. My code starts up a reader and it grabs the first 200 rows (default setting). After I have read the 200 rows the next read (I have put on a counter to determine which row it fails on) causes the 10054 error and generates an error on the client. The client gives no error information, but the stack trace indicates that it's during the fetch (often on the 201 row). After this I must reset the connection for anything to work -- View this message in context: http://old.nabble.com/Firebird-Client-error-during-Fetch-cycle-tp27213450p27216333.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
On Mon, Jan 18, 2010 at 21:34, Russell R russ...@passfield.co.uk wrote:
The device has powersave switched off. Can you point me in the direction of
how to configure the SO_LINGER option - maybe this will help. My code
You can play with socket settings in GdsConnection Connect method.
starts up a reader and it grabs the first 200 rows (default setting). After
I have read the 200 rows the next read (I have put on a counter to determine
which row it fails on) causes the 10054 error and generates an error on the
Are you reading next rows immediately?
client. The client gives no error information, but the stack trace
indicates that it's during the fetch (often on the 201 row). After this I
must reset the connection for anything to work
This looks like connection problem on device.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com
--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Client error during Fetch cycle
At 03:59 AM 19/01/2010, Russell R wrote: Hi This is the summary of all my other posts. Sorry for the confusion earlier, but I thought it best to consolidate. I am running the latest version of firebird client (2.5.1) built for .net 2.0 compact framework (Thanks Jakub). During a fetch cycle of a large select, I often get a 10054 error on the server and read error within the client code. This only happens when communicating via a LAN connection (never via a USB). Problems occurring during fetch cycle of a large select ought to make you at least suspicious that your client application is the one that is crashing. Are you sure the client device has enough resources to what you're asking it to do? A crashed app means (eventually) a dead socket and thus a 10054 error in firebird.log, which reflects the loss of one side of a socket. I have tried many different error recovery tatics and none of them seem to work. Also the network I am using is only local and so there shouldn't be too much noise. Once I get the 10054 error, the only solution seems to be to close the connection and start a new one. However, this is quite time consuming on a Windows CE device and the server eventually crashes. If the *server* crashes as the result of a client operation from the network then the cause is usually a call to a buggy UDF. Otherwise, it's really hard for a client to crash the server. Does it really crash? If/when it does, with luck there will be some clue in the system logs and/or firebird.log. Therefore I think the issue must be related to how the client/server interacts with TCP and this would mean looking into the client code. Whilst I have the code, I don't think I could readily find out what is going on. The client and server interact with TCP/IP only insofar as they use it as a transport layer *if* the client uses TCP/IP protocol for its connection. The Firebird server (and guardian, if it is being used) report any network error messages in firebird.log but they don't have any influence over a broken socket. (TCP/IP is out of the picture if the client uses a different protocol, btw.) You will see 10054 (Connection reset by peer) errors under various conditions. Some are significant, some not. Clients that crash out of a connection, e.g., by switching off the PDA while an operation is in progress or encountering some other unhandled error, will break the socket and cause a 10054 error. That's just an example: there's a long list of possibilities. Sometimes this sort of problem occurs when the TCP/IP timeout and/or keepalive parameters for the network are unsuitably configured for the types of clients that use it, causing the TCP/IP server to reset a connection arbitrarily if it decides the peer is unresponsive. A network connection is only as fast as the slower end of the partnership. With a slow client, it's not unusual for a Windows server with default TCP/IP properties to cause this problem. If the network setup is allowing DHCP to assign an arbitrary node address for the host then it is possible for a slow client to lose the server if a timeout occurred that eventually left a server program idle. Use a static IP address for the host server and, if necessary, for those slow clients. It might not solve the whole problem but at least any recovery procedure at the client can hope to retrieve a valid connection handle if it is able to refresh its end of the connection before the server notices it is lost. Note that Windows updates have been known to break network conditions that worked previously but that might have been vulnerable to some threat that the update addresses. Please could someone help out No obvious single answer here, though, and the issues mentioned are just clues, pretty much all OT for the net-provider, afaiu. Helen -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
