Same answer Minisoft has given us. They are making a mod so that they
will not ignore the larger packets. Although there is something configured
(we think) in our network hardware (routers) that also may be affecting it.
Partial quote from a Minisoft person below:
Setting the packet size only affected server to client transmissions. The
open statement sent from the client to server can vary in size. Looking at
the trace an 1,800 byte packet was sent from the client to the server. It
never made it. The server was waiting for it, never received it, timed out.
The client was waiting for a response the packet made it, never received it,
timed out.
ODBC is being updated so setting the packet size affects client to server
transmissions along with server to client transmission. Still though, there
is a piece of hardware somewhere in your network that doesn't like large
packet sizes. Heck, 1,800 bytes isn't even large!
BT
Tracy Johnson
MSI Schaevitz Sensors
> -----Original Message-----
> From: HP-3000 Systems Discussion
> [mailto:[log in to unmask]]On Behalf Of john pitman
> Sent: Wednesday, January 26, 2005 5:26 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] FW: About the ODBC problem.
>
>
> FWIW, when we went to adsl connections to remote offices
> inside Oz, the
> provider insisted that we would have problems unless we
> reduced segment size
> to under 1500, or at least what he understood as the packet
> size in windoze
> terms....MTU Max transmission unit. We still had a few
> strange problems, but
> eventually everything worked. Easiest way to alter this for
> windoze I found
> was downloading a thing called DRTCP.
> HTH
> jp
>
> -----Original Message-----
> From: HP-3000 Systems Discussion
> [mailto:[log in to unmask]] On Behalf
> Of Johnson, Tracy
> Sent: Tuesday, 25 January 2005 3:08 AM
> To: [log in to unmask]
> Subject: [HP3000-L] FW: About the ODBC problem.
>
> We're getting ODBC errors over our WAN to China using SQL.
> Below is how our
> personnel in China described the latest test results. (The
> pronouns and
> tenses may not be what you're used to, English is not his 1st
> language.)
>
> From my point of view, I suppose I could lower the Network
> segment size, but
> would it matter? Or should I be looking at retransmission
> parameters such
> as the number of retries, maximums, and time-outs as he says?
>
> We're using Minisoft ODBC and they have been working the
> call, but since it
> is 7AM in Minisoft-Land, maybe someone here has some other ideas?
>
> BT
>
>
> Tracy Johnson
> MSI Schaevitz Sensors
>
> -----Original Message-----
> From: [snip], Robin
> Sent: Sunday, January 23, 2005 8:43 PM
> To: [snip]
> Subject: About the ODBC problem.
>
>
> Hi [snip] $B!$ (B
>
> I use the tool "ODBC TEST" to run the same SQL, it also got error
> message.(see below)
> I think it's not the problem of MS Query, we use ODBC at VB /
> Dephi / SQL
> Server DTS /and .NET, and it also easy got error. Since Tracy
> run the same
> SQL got no error, which means the configuration of ODBC
> server side maybe
> need optimize, maybe the buffer / cache / timeout /etc.
> Hi Harrington, you need to know, China use 1.5 M DDN line to
> connect to
> Hampton server, we found it'll easy got error if the SQL
> syntax have more
> than 10 columns; even the return data only has one row.
> In general, we found the ODBC server could not accept a long
> SQL syntax
> sentence here, that maybe help you to solve minisoft ODBC to
> run at a WAN
> environment.
>
> Best Regards !
>
> Robin
>
>
>
>
> Error message of ODBC TEST $B!' (B
>
> Full Connect(Use ODBC)
> Successfully connected to DSN 'MG_85'.
> SQLExecDirect:
> In: hstmt = 0x008F2800, szSqlStr = "SELECT
> IM.ABC,
> IM.ACTCMATO,
> IM.ACTLA...", cbSqlStr = -3
> Return: SQL_ERROR=-1
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
