blob issue

Hi,
I am writing an application to store documents that i
scan into a database. I create adobe pdf files, and i
can add them to my database ( mysql ) as a blob.

All of this is fine. But, when i want to read the
docs, i have a problem. I am using the following code,
and a control from adobe to display the file.

Dim mystream As ADODB.Stream
Set mystream = New ADODB.Stream

mystream.Type = adTypeBinary

Set rs = New ADODB.Recordset
rs.ActiveConnection = connMySQL
sqlstr = "Select * from files WHERE
files.file_id = 8"
Set rs = New ADODB.Recordset
rs.ActiveConnection = connMySQL
rs.Open sqlstr, connMySQL, adOpenStatic,
adLockOptimistic
Debug.Print rs.RecordCount

'rs.Open "Select * from files WHERE files.file_id = 8"
mystream.Open
mystream.Write rs!File
mystream.SaveToFile "c:\test.pdf",
adSaveCreateOverWrite
mystream.Close
rs.Close


'adobe control
Pdf1.LoadFile ("c:\text.pdf")
Pdf1.Visible = True



the issue here, its that it takes a little bit of time
to get the doc from the database, so, the
pdf1.loadfile command cannot load the file, as it has
not been fully written to the local disk.

i will be running 5 client machines, and one server.
is there an easier way to do this?


any advice or code would be very very much
appricateed.......


many thanks



__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: blob issue

Well, I did some research on you error (mostly google and mysql
manual) and the most common causes of this error includes your
problems (so, you should have found this :P). I'll work with the R T
Fine M *lol*

http://dev.mysql.com/doc/mysql/en/gone-away.html

It happens that your client is sending large packets to the server, as
eva2000 stated at the Vbulleting Forum:

"You can also get these errors if you send a query to the server that
is incorrect or too large. If mysqld gets a packet that is too large
or out of order, it assumes that something has gone wrong with the
client and closes the connection. If you need big queries (for
example, if you are working with big BLOB columns), you can increase
the query limit by starting mysqld with the -O max_allowed_packet=3D#
option (default 1M) or via max_allowed_packet variable in your
/etc/my.cnf file and restarting mysql after you edited your
/etc/my.cnf file. The extra memory is allocated on demand, so mysqld
will use more memory only when you issue a big query or when mysqld
must return a big result row"

Try this and let me know if it works.
Good luck.

On 4/18/05, Mark Mchugh wrote:
> Hi Daniel,
> Have tried that, still the same, this is odd?
>=20
> Mark
>=20
>=20
> --- Daniel da Veiga wrote:
> > If it takes some times for your app to load and use
> > the file data, the
> > server considers this idle time, and thus disconnect
> > you after a few
> > seconds, try setting a higher value for
> > "wait_timeout" and
> > "interactive_timeout", or rebuild your code to
> > connect and insert the
> > data only after all processing of the file is
> > complete. So, your
> > rs.Open would be executed only AFTER
> > mystream.LoadFromFile, avoiding
> > idle time.
> >
> > Hope that helps,
> >
> > On 4/15/05, Mark Mchugh wrote:
> > > hi,
> > > I am trying to add files to my database, on the
> > server
> > >
> > > max_allowed_packet =3D 1073741824
> > >
> > > and i am using the following code..
> > >
> > > sqlstr =3D "select * from files where 1=3D0;"
> > >
> > > rs.Open sqlstr, connMySQL, adOpenStatic,
> > > adLockOptimistic
> > > rs.AddNew
> > > mystream.Open
> > > Debug.Print strFileName
> > > mystream.LoadFromFile strFileName
> > > rs!file_name =3D "All Scanned"
> > > rs!Fromp =3D CatDir
> > > rs!Desc1 =3D ronsnotes
> > > rs!file_size =3D mystream.Size
> > > rs!policyid =3D fdesc
> > > rs!file =3D mystream.Read
> > > rs.Update
> > > mystream.Close
> > > rs.Close
> > >
> > > i get the error message "lost connection to mysql
> > > server during query"
> > >
> > > any ideas?
> > >
> > > thanks
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Read only the mail you want - Yahoo! Mail
> > SpamGuard.
> > > http://promotions.yahoo.com/new_mail
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > >
> > >
> >
> >
> > --
> > Daniel da Veiga
> > Computer Operator - RS - Brazil
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> >
> >
>=20
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: blob issue

thanks for this....
still having the problem, i've put the following into
the my.ini

max_allowed_packet=32M

the file i am adding is 16Meg, seems odd?


MArk
--- Daniel da Veiga wrote:

> Well, I did some research on you error (mostly
> google and mysql
> manual) and the most common causes of this error
> includes your
> problems (so, you should have found this :P). I'll
> work with the R T
> Fine M *lol*
>
> http://dev.mysql.com/doc/mysql/en/gone-away.html
>
> It happens that your client is sending large packets
> to the server, as
> eva2000 stated at the Vbulleting Forum:
>
> "You can also get these errors if you send a query
> to the server that
> is incorrect or too large. If mysqld gets a packet
> that is too large
> or out of order, it assumes that something has gone
> wrong with the
> client and closes the connection. If you need big
> queries (for
> example, if you are working with big BLOB columns),
> you can increase
> the query limit by starting mysqld with the -O
> max_allowed_packet=#
> option (default 1M) or via max_allowed_packet
> variable in your
> /etc/my.cnf file and restarting mysql after you
> edited your
> /etc/my.cnf file. The extra memory is allocated on
> demand, so mysqld
> will use more memory only when you issue a big query
> or when mysqld
> must return a big result row"
>
> Try this and let me know if it works.
> Good luck.
>
> On 4/18/05, Mark Mchugh wrote:
> > Hi Daniel,
> > Have tried that, still the same, this is odd?
> >
> > Mark
> >
> >
> > --- Daniel da Veiga
> wrote:
> > > If it takes some times for your app to load and
> use
> > > the file data, the
> > > server considers this idle time, and thus
> disconnect
> > > you after a few
> > > seconds, try setting a higher value for
> > > "wait_timeout" and
> > > "interactive_timeout", or rebuild your code to
> > > connect and insert the
> > > data only after all processing of the file is
> > > complete. So, your
> > > rs.Open would be executed only AFTER
> > > mystream.LoadFromFile, avoiding
> > > idle time.
> > >
> > > Hope that helps,
> > >
> > > On 4/15/05, Mark Mchugh
> wrote:
> > > > hi,
> > > > I am trying to add files to my database, on
> the
> > > server
> > > >
> > > > max_allowed_packet = 1073741824
> > > >
> > > > and i am using the following code..
> > > >
> > > > sqlstr = "select * from files where 1=0;"
> > > >
> > > > rs.Open sqlstr, connMySQL, adOpenStatic,
> > > > adLockOptimistic
> > > > rs.AddNew
> > > > mystream.Open
> > > > Debug.Print strFileName
> > > > mystream.LoadFromFile strFileName
> > > > rs!file_name = "All Scanned"
> > > > rs!Fromp = CatDir
> > > > rs!Desc1 = ronsnotes
> > > > rs!file_size = mystream.Size
> > > > rs!policyid = fdesc
> > > > rs!file = mystream.Read
> > > > rs.Update
> > > > mystream.Close
> > > > rs.Close
> > > >
> > > > i get the error message "lost connection to
> mysql
> > > > server during query"
> > > >
> > > > any ideas?
> > > >
> > > > thanks
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Read only the mail you want - Yahoo! Mail
> > > SpamGuard.
> > > > http://promotions.yahoo.com/new_mail
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives:
> http://lists.mysql.com/win32
> > > > To unsubscribe:
> > >
> >
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> > > >
> > > >
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > >
> >
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Plan great trips with Yahoo! Travel: Now over
> 17,000 guides!
> > http://travel.yahoo.com/p-travelguide
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>




__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: blob issue

I have an update, the error message i am now getting
is

"got packet bigger than 'max_allowed_packet'"


i wonder is this a client problem? i ahve added the
following into the my.ini

[client]
max_allowed_packet=32M



--- Daniel da Veiga wrote:

> Well, I did some research on you error (mostly
> google and mysql
> manual) and the most common causes of this error
> includes your
> problems (so, you should have found this :P). I'll
> work with the R T
> Fine M *lol*
>
> http://dev.mysql.com/doc/mysql/en/gone-away.html
>
> It happens that your client is sending large packets
> to the server, as
> eva2000 stated at the Vbulleting Forum:
>
> "You can also get these errors if you send a query
> to the server that
> is incorrect or too large. If mysqld gets a packet
> that is too large
> or out of order, it assumes that something has gone
> wrong with the
> client and closes the connection. If you need big
> queries (for
> example, if you are working with big BLOB columns),
> you can increase
> the query limit by starting mysqld with the -O
> max_allowed_packet=#
> option (default 1M) or via max_allowed_packet
> variable in your
> /etc/my.cnf file and restarting mysql after you
> edited your
> /etc/my.cnf file. The extra memory is allocated on
> demand, so mysqld
> will use more memory only when you issue a big query
> or when mysqld
> must return a big result row"
>
> Try this and let me know if it works.
> Good luck.
>
> On 4/18/05, Mark Mchugh wrote:
> > Hi Daniel,
> > Have tried that, still the same, this is odd?
> >
> > Mark
> >
> >
> > --- Daniel da Veiga
> wrote:
> > > If it takes some times for your app to load and
> use
> > > the file data, the
> > > server considers this idle time, and thus
> disconnect
> > > you after a few
> > > seconds, try setting a higher value for
> > > "wait_timeout" and
> > > "interactive_timeout", or rebuild your code to
> > > connect and insert the
> > > data only after all processing of the file is
> > > complete. So, your
> > > rs.Open would be executed only AFTER
> > > mystream.LoadFromFile, avoiding
> > > idle time.
> > >
> > > Hope that helps,
> > >
> > > On 4/15/05, Mark Mchugh
> wrote:
> > > > hi,
> > > > I am trying to add files to my database, on
> the
> > > server
> > > >
> > > > max_allowed_packet = 1073741824
> > > >
> > > > and i am using the following code..
> > > >
> > > > sqlstr = "select * from files where 1=0;"
> > > >
> > > > rs.Open sqlstr, connMySQL, adOpenStatic,
> > > > adLockOptimistic
> > > > rs.AddNew
> > > > mystream.Open
> > > > Debug.Print strFileName
> > > > mystream.LoadFromFile strFileName
> > > > rs!file_name = "All Scanned"
> > > > rs!Fromp = CatDir
> > > > rs!Desc1 = ronsnotes
> > > > rs!file_size = mystream.Size
> > > > rs!policyid = fdesc
> > > > rs!file = mystream.Read
> > > > rs.Update
> > > > mystream.Close
> > > > rs.Close
> > > >
> > > > i get the error message "lost connection to
> mysql
> > > > server during query"
> > > >
> > > > any ideas?
> > > >
> > > > thanks
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Read only the mail you want - Yahoo! Mail
> > > SpamGuard.
> > > > http://promotions.yahoo.com/new_mail
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives:
> http://lists.mysql.com/win32
> > > > To unsubscribe:
> > >
> >
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> > > >
> > > >
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > >
> >
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Plan great trips with Yahoo! Travel: Now over
> 17,000 guides!
> > http://travel.yahoo.com/p-travelguide
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>




__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: blob issue

Try setting the package in bytes, I mean 33554432 bytes :)
Dunno, but the error message is very clear to me, seems your're
getting some odd issue setting the value, so, try bytes, and do a
'show global variables like '%package%'' at your console to see the
exact value of the variable.

Good luck,

On 4/18/05, Mark Mchugh wrote:
> I have an update, the error message i am now getting
> is
>=20
> "got packet bigger than 'max_allowed_packet'"
>=20
> i wonder is this a client problem? i ahve added the
> following into the my.ini
>=20
> [client]
> max_allowed_packet=3D32M
>=20
>=20
> --- Daniel da Veiga wrote:
>=20
> > Well, I did some research on you error (mostly
> > google and mysql
> > manual) and the most common causes of this error
> > includes your
> > problems (so, you should have found this :P). I'll
> > work with the R T
> > Fine M *lol*
> >
> > http://dev.mysql.com/doc/mysql/en/gone-away.html
> >
> > It happens that your client is sending large packets
> > to the server, as
> > eva2000 stated at the Vbulleting Forum:
> >
> > "You can also get these errors if you send a query
> > to the server that
> > is incorrect or too large. If mysqld gets a packet
> > that is too large
> > or out of order, it assumes that something has gone
> > wrong with the
> > client and closes the connection. If you need big
> > queries (for
> > example, if you are working with big BLOB columns),
> > you can increase
> > the query limit by starting mysqld with the -O
> > max_allowed_packet=3D#
> > option (default 1M) or via max_allowed_packet
> > variable in your
> > /etc/my.cnf file and restarting mysql after you
> > edited your
> > /etc/my.cnf file. The extra memory is allocated on
> > demand, so mysqld
> > will use more memory only when you issue a big query
> > or when mysqld
> > must return a big result row"
> >
> > Try this and let me know if it works.
> > Good luck.
> >
> > On 4/18/05, Mark Mchugh wrote:
> > > Hi Daniel,
> > > Have tried that, still the same, this is odd?
> > >
> > > Mark
> > >
> > >
> > > --- Daniel da Veiga
> > wrote:
> > > > If it takes some times for your app to load and
> > use
> > > > the file data, the
> > > > server considers this idle time, and thus
> > disconnect
> > > > you after a few
> > > > seconds, try setting a higher value for
> > > > "wait_timeout" and
> > > > "interactive_timeout", or rebuild your code to
> > > > connect and insert the
> > > > data only after all processing of the file is
> > > > complete. So, your
> > > > rs.Open would be executed only AFTER
> > > > mystream.LoadFromFile, avoiding
> > > > idle time.
> > > >
> > > > Hope that helps,
> > > >
> > > > On 4/15/05, Mark Mchugh
> > wrote:
> > > > > hi,
> > > > > I am trying to add files to my database, on
> > the
> > > > server
> > > > >
> > > > > max_allowed_packet =3D 1073741824
> > > > >
> > > > > and i am using the following code..
> > > > >
> > > > > sqlstr =3D "select * from files where 1=3D0;"
> > > > >
> > > > > rs.Open sqlstr, connMySQL, adOpenStatic,
> > > > > adLockOptimistic
> > > > > rs.AddNew
> > > > > mystream.Open
> > > > > Debug.Print strFileName
> > > > > mystream.LoadFromFile strFileName
> > > > > rs!file_name =3D "All Scanned"
> > > > > rs!Fromp =3D CatDir
> > > > > rs!Desc1 =3D ronsnotes
> > > > > rs!file_size =3D mystream.Size
> > > > > rs!policyid =3D fdesc
> > > > > rs!file =3D mystream.Read
> > > > > rs.Update
> > > > > mystream.Close
> > > > > rs.Close
> > > > >
> > > > > i get the error message "lost connection to
> > mysql
> > > > > server during query"
> > > > >
> > > > > any ideas?
> > > > >
> > > > > thanks
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > Read only the mail you want - Yahoo! Mail
> > > > SpamGuard.
> > > > > http://promotions.yahoo.com/new_mail
> > > > >
> > > > > --
> > > > > MySQL Windows Mailing List
> > > > > For list archives:
> > http://lists.mysql.com/win32
> > > > > To unsubscribe:
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives: http://lists.mysql.com/win32
> > > > To unsubscribe:
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> > > >
> > > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Plan great trips with Yahoo! Travel: Now over
> > 17,000 guides!
> > > http://travel.yahoo.com/p-travelguide
> > >
> >
> >
> > --
> > Daniel da Veiga
> > Computer Operator - RS - Brazil
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> >
> >
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: blob issue

its strange, fromt he server i get this for
max_allowed_packet = 104856576

that should be big enought for a 16M file?



--- Daniel da Veiga wrote:

> Try setting the package in bytes, I mean 33554432
> bytes :)
> Dunno, but the error message is very clear to me,
> seems your're
> getting some odd issue setting the value, so, try
> bytes, and do a
> 'show global variables like '%package%'' at your
> console to see the
> exact value of the variable.
>
> Good luck,
>
> On 4/18/05, Mark Mchugh wrote:
> > I have an update, the error message i am now
> getting
> > is
> >
> > "got packet bigger than 'max_allowed_packet'"
> >
> > i wonder is this a client problem? i ahve added
> the
> > following into the my.ini
> >
> > [client]
> > max_allowed_packet=32M
> >
> >
> > --- Daniel da Veiga
> wrote:
> >
> > > Well, I did some research on you error (mostly
> > > google and mysql
> > > manual) and the most common causes of this error
> > > includes your
> > > problems (so, you should have found this :P).
> I'll
> > > work with the R T
> > > Fine M *lol*
> > >
> > > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > >
> > > It happens that your client is sending large
> packets
> > > to the server, as
> > > eva2000 stated at the Vbulleting Forum:
> > >
> > > "You can also get these errors if you send a
> query
> > > to the server that
> > > is incorrect or too large. If mysqld gets a
> packet
> > > that is too large
> > > or out of order, it assumes that something has
> gone
> > > wrong with the
> > > client and closes the connection. If you need
> big
> > > queries (for
> > > example, if you are working with big BLOB
> columns),
> > > you can increase
> > > the query limit by starting mysqld with the -O
> > > max_allowed_packet=#
> > > option (default 1M) or via max_allowed_packet
> > > variable in your
> > > /etc/my.cnf file and restarting mysql after you
> > > edited your
> > > /etc/my.cnf file. The extra memory is allocated
> on
> > > demand, so mysqld
> > > will use more memory only when you issue a big
> query
> > > or when mysqld
> > > must return a big result row"
> > >
> > > Try this and let me know if it works.
> > > Good luck.
> > >
> > > On 4/18/05, Mark Mchugh
> wrote:
> > > > Hi Daniel,
> > > > Have tried that, still the same, this is odd?
> > > >
> > > > Mark
> > > >
> > > >
> > > > --- Daniel da Veiga
> > > wrote:
> > > > > If it takes some times for your app to load
> and
> > > use
> > > > > the file data, the
> > > > > server considers this idle time, and thus
> > > disconnect
> > > > > you after a few
> > > > > seconds, try setting a higher value for
> > > > > "wait_timeout" and
> > > > > "interactive_timeout", or rebuild your code
> to
> > > > > connect and insert the
> > > > > data only after all processing of the file
> is
> > > > > complete. So, your
> > > > > rs.Open would be executed only AFTER
> > > > > mystream.LoadFromFile, avoiding
> > > > > idle time.
> > > > >
> > > > > Hope that helps,
> > > > >
> > > > > On 4/15/05, Mark Mchugh
> > > wrote:
> > > > > > hi,
> > > > > > I am trying to add files to my database,
> on
> > > the
> > > > > server
> > > > > >
> > > > > > max_allowed_packet = 1073741824
> > > > > >
> > > > > > and i am using the following code..
> > > > > >
> > > > > > sqlstr = "select * from files where 1=0;"
> > > > > >
> > > > > > rs.Open sqlstr, connMySQL,
> adOpenStatic,
> > > > > > adLockOptimistic
> > > > > > rs.AddNew
> > > > > > mystream.Open
> > > > > > Debug.Print strFileName
> > > > > > mystream.LoadFromFile strFileName
> > > > > > rs!file_name = "All Scanned"
> > > > > > rs!Fromp = CatDir
> > > > > > rs!Desc1 = ronsnotes
> > > > > > rs!file_size = mystream.Size
> > > > > > rs!policyid = fdesc
> > > > > > rs!file = mystream.Read
> > > > > > rs.Update
> > > > > > mystream.Close
> > > > > > rs.Close
> > > > > >
> > > > > > i get the error message "lost connection
> to
> > > mysql
> > > > > > server during query"
> > > > > >
> > > > > > any ideas?
> > > > > >
> > > > > > thanks
> > > > > >
> > > > > > __________________________________
> > > > > > Do you Yahoo!?
> > > > > > Read only the mail you want - Yahoo! Mail
> > > > > SpamGuard.
> > > > > > http://promotions.yahoo.com/new_mail
> > > > > >
> > > > > > --
> > > > > > MySQL Windows Mailing List
> > > > > > For list archives:
> > > http://lists.mysql.com/win32
> > > > > > To unsubscribe:
> > > > >
> > > >
> > >
> >
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Daniel da Veiga
> > > > > Computer Operator - RS - Brazil
> > > > >
> > > > > --
> > > > > MySQL Windows Mailing List
> > > > > For list archives:
> http://lists.mysql.com/win32
> > > > > To unsubscribe:
> > > > >
> > > >
> > >
> >
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
> > > > >
> > > > >
> > > >
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Plan great trips with Yahoo! Travel: Now over
> > > 17,000 guides!
> > > > http://travel.yahoo.com/p-travelguide
> > > >
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > MySQL Windows Mailing List
>
=== message truncated ===




__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: blob issue

Yeah it should, but hey, at least now you moved into a new MySQL
Manual section :) that is A.2.9. Check it out. Well, I did it, noticed
that this variable, as you stated before, must be set BOTH client and
server side... So, now you should discover wich one (client or server)
is sending you the message (or just set the variable in both) :)

More information? Check this out:

http://dev.mysql.com/doc/mysql/en/packet-too-large.html

Good luck, again...

On 4/18/05, Mark Mchugh wrote:
> its strange, fromt he server i get this for
> max_allowed_packet =3D 104856576
>=20
> that should be big enought for a 16M file?
>=20
>=20
> --- Daniel da Veiga wrote:
>=20
> > Try setting the package in bytes, I mean 33554432
> > bytes :)
> > Dunno, but the error message is very clear to me,
> > seems your're
> > getting some odd issue setting the value, so, try
> > bytes, and do a
> > 'show global variables like '%package%'' at your
> > console to see the
> > exact value of the variable.
> >
> > Good luck,
> >
> > On 4/18/05, Mark Mchugh wrote:
> > > I have an update, the error message i am now
> > getting
> > > is
> > >
> > > "got packet bigger than 'max_allowed_packet'"
> > >
> > > i wonder is this a client problem? i ahve added
> > the
> > > following into the my.ini
> > >
> > > [client]
> > > max_allowed_packet=3D32M
> > >
> > >
> > > --- Daniel da Veiga
> > wrote:
> > >
> > > > Well, I did some research on you error (mostly
> > > > google and mysql
> > > > manual) and the most common causes of this error
> > > > includes your
> > > > problems (so, you should have found this :P).
> > I'll
> > > > work with the R T
> > > > Fine M *lol*
> > > >
> > > > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > >
> > > > It happens that your client is sending large
> > packets
> > > > to the server, as
> > > > eva2000 stated at the Vbulleting Forum:
> > > >
> > > > "You can also get these errors if you send a
> > query
> > > > to the server that
> > > > is incorrect or too large. If mysqld gets a
> > packet
> > > > that is too large
> > > > or out of order, it assumes that something has
> > gone
> > > > wrong with the
> > > > client and closes the connection. If you need
> > big
> > > > queries (for
> > > > example, if you are working with big BLOB
> > columns),
> > > > you can increase
> > > > the query limit by starting mysqld with the -O
> > > > max_allowed_packet=3D#
> > > > option (default 1M) or via max_allowed_packet
> > > > variable in your
> > > > /etc/my.cnf file and restarting mysql after you
> > > > edited your
> > > > /etc/my.cnf file. The extra memory is allocated
> > on
> > > > demand, so mysqld
> > > > will use more memory only when you issue a big
> > query
> > > > or when mysqld
> > > > must return a big result row"
> > > >
> > > > Try this and let me know if it works.
> > > > Good luck.
> > > >
> > > > On 4/18/05, Mark Mchugh
> > wrote:
> > > > > Hi Daniel,
> > > > > Have tried that, still the same, this is odd?
> > > > >
> > > > > Mark
> > > > >
> > > > >
> > > > > --- Daniel da Veiga
> > > > wrote:
> > > > > > If it takes some times for your app to load
> > and
> > > > use
> > > > > > the file data, the
> > > > > > server considers this idle time, and thus
> > > > disconnect
> > > > > > you after a few
> > > > > > seconds, try setting a higher value for
> > > > > > "wait_timeout" and
> > > > > > "interactive_timeout", or rebuild your code
> > to
> > > > > > connect and insert the
> > > > > > data only after all processing of the file
> > is
> > > > > > complete. So, your
> > > > > > rs.Open would be executed only AFTER
> > > > > > mystream.LoadFromFile, avoiding
> > > > > > idle time.
> > > > > >
> > > > > > Hope that helps,
> > > > > >
> > > > > > On 4/15/05, Mark Mchugh
> > > > wrote:
> > > > > > > hi,
> > > > > > > I am trying to add files to my database,
> > on
> > > > the
> > > > > > server
> > > > > > >
> > > > > > > max_allowed_packet =3D 1073741824
> > > > > > >
> > > > > > > and i am using the following code..
> > > > > > >
> > > > > > > sqlstr =3D "select * from files where 1=3D0;"
> > > > > > >
> > > > > > > rs.Open sqlstr, connMySQL,
> > adOpenStatic,
> > > > > > > adLockOptimistic
> > > > > > > rs.AddNew
> > > > > > > mystream.Open
> > > > > > > Debug.Print strFileName
> > > > > > > mystream.LoadFromFile strFileName
> > > > > > > rs!file_name =3D "All Scanned"
> > > > > > > rs!Fromp =3D CatDir
> > > > > > > rs!Desc1 =3D ronsnotes
> > > > > > > rs!file_size =3D mystream.Size
> > > > > > > rs!policyid =3D fdesc
> > > > > > > rs!file =3D mystream.Read
> > > > > > > rs.Update
> > > > > > > mystream.Close
> > > > > > > rs.Close
> > > > > > >
> > > > > > > i get the error message "lost connection
> > to
> > > > mysql
> > > > > > > server during query"
> > > > > > >
> > > > > > > any ideas?
> > > > > > >
> > > > > > > thanks
> > > > > > >
> > > > > > > __________________________________
> > > > > > > Do you Yahoo!?
> > > > > > > Read only the mail you want - Yahoo! Mail
> > > > > > SpamGuard.
> > > > > > > http://promotions.yahoo.com/new_mail
> > > > > > >
> > > > > > > --
> > > > > > > MySQL Windows Mailing List
> > > > > > > For list archives:
> > > > http://lists.mysql.com/win32
> > > > > > > To unsubscribe:
> > > > > >
> > > > >
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Daniel da Veiga
> > > > > > Computer Operator - RS - Brazil
> > > > > >
> > > > > > --
> > > > > > MySQL Windows Mailing List
> > > > > > For list archives:
> > http://lists.mysql.com/win32
> > > > > > To unsubscribe:
> > > > > >
> > > > >
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > Plan great trips with Yahoo! Travel: Now over
> > > > 17,000 guides!
> > > > > http://travel.yahoo.com/p-travelguide
> > > > >
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> >
> ===3D message truncated ===3D
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: blob issue

its seems the same when i have added to client
section, and i've set the max_allowed_packet=100M for
both client and server, do i need to change something
on my local client machine that sending the blob to
the server?


--- Daniel da Veiga wrote:

> Yeah it should, but hey, at least now you moved into
> a new MySQL
> Manual section :) that is A.2.9. Check it out. Well,
> I did it, noticed
> that this variable, as you stated before, must be
> set BOTH client and
> server side... So, now you should discover wich one
> (client or server)
> is sending you the message (or just set the variable
> in both) :)
>
> More information? Check this out:
>
>
http://dev.mysql.com/doc/mysql/en/packet-too-large.html
>
> Good luck, again...
>
> On 4/18/05, Mark Mchugh wrote:
> > its strange, fromt he server i get this for
> > max_allowed_packet = 104856576
> >
> > that should be big enought for a 16M file?
> >
> >
> > --- Daniel da Veiga
> wrote:
> >
> > > Try setting the package in bytes, I mean
> 33554432
> > > bytes :)
> > > Dunno, but the error message is very clear to
> me,
> > > seems your're
> > > getting some odd issue setting the value, so,
> try
> > > bytes, and do a
> > > 'show global variables like '%package%'' at your
> > > console to see the
> > > exact value of the variable.
> > >
> > > Good luck,
> > >
> > > On 4/18/05, Mark Mchugh
> wrote:
> > > > I have an update, the error message i am now
> > > getting
> > > > is
> > > >
> > > > "got packet bigger than 'max_allowed_packet'"
> > > >
> > > > i wonder is this a client problem? i ahve
> added
> > > the
> > > > following into the my.ini
> > > >
> > > > [client]
> > > > max_allowed_packet=32M
> > > >
> > > >
> > > > --- Daniel da Veiga
> > > wrote:
> > > >
> > > > > Well, I did some research on you error
> (mostly
> > > > > google and mysql
> > > > > manual) and the most common causes of this
> error
> > > > > includes your
> > > > > problems (so, you should have found this
> :P).
> > > I'll
> > > > > work with the R T
> > > > > Fine M *lol*
> > > > >
> > > > >
> http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > > >
> > > > > It happens that your client is sending large
> > > packets
> > > > > to the server, as
> > > > > eva2000 stated at the Vbulleting Forum:
> > > > >
> > > > > "You can also get these errors if you send a
> > > query
> > > > > to the server that
> > > > > is incorrect or too large. If mysqld gets a
> > > packet
> > > > > that is too large
> > > > > or out of order, it assumes that something
> has
> > > gone
> > > > > wrong with the
> > > > > client and closes the connection. If you
> need
> > > big
> > > > > queries (for
> > > > > example, if you are working with big BLOB
> > > columns),
> > > > > you can increase
> > > > > the query limit by starting mysqld with the
> -O
> > > > > max_allowed_packet=#
> > > > > option (default 1M) or via
> max_allowed_packet
> > > > > variable in your
> > > > > /etc/my.cnf file and restarting mysql after
> you
> > > > > edited your
> > > > > /etc/my.cnf file. The extra memory is
> allocated
> > > on
> > > > > demand, so mysqld
> > > > > will use more memory only when you issue a
> big
> > > query
> > > > > or when mysqld
> > > > > must return a big result row"
> > > > >
> > > > > Try this and let me know if it works.
> > > > > Good luck.
> > > > >
> > > > > On 4/18/05, Mark Mchugh
> > > wrote:
> > > > > > Hi Daniel,
> > > > > > Have tried that, still the same, this is
> odd?
> > > > > >
> > > > > > Mark
> > > > > >
> > > > > >
> > > > > > --- Daniel da Veiga
>
> > > > > wrote:
> > > > > > > If it takes some times for your app to
> load
> > > and
> > > > > use
> > > > > > > the file data, the
> > > > > > > server considers this idle time, and
> thus
> > > > > disconnect
> > > > > > > you after a few
> > > > > > > seconds, try setting a higher value for
> > > > > > > "wait_timeout" and
> > > > > > > "interactive_timeout", or rebuild your
> code
> > > to
> > > > > > > connect and insert the
> > > > > > > data only after all processing of the
> file
> > > is
> > > > > > > complete. So, your
> > > > > > > rs.Open would be executed only AFTER
> > > > > > > mystream.LoadFromFile, avoiding
> > > > > > > idle time.
> > > > > > >
> > > > > > > Hope that helps,
> > > > > > >
> > > > > > > On 4/15/05, Mark Mchugh
>
> > > > > wrote:
> > > > > > > > hi,
> > > > > > > > I am trying to add files to my
> database,
> > > on
> > > > > the
> > > > > > > server
> > > > > > > >
> > > > > > > > max_allowed_packet = 1073741824
> > > > > > > >
> > > > > > > > and i am using the following code..
> > > > > > > >
> > > > > > > > sqlstr = "select * from files where
> 1=0;"
> > > > > > > >
> > > > > > > > rs.Open sqlstr, connMySQL,
> > > adOpenStatic,
> > > > > > > > adLockOptimistic
> > > > > > > > rs.AddNew
> > > > > > > > mystream.Open
> > > > > > > > Debug.Print strFileName
> > > > > > > > mystream.LoadFromFile strFileName
> > > > > > > > rs!file_name = "All Scanned"
> > > > > > > > rs!Fromp = CatDir
> > > > > > > > rs!Desc1 = ronsnotes
> > > > > > > > rs!file_size = mystream.Size
> > > > > > > > rs!policyid = fdesc
> > > > > > > > rs!file = mystream.Read
> > > > > > > > rs.Update
> > > > > > > > mystream.Close
> > > > > > > > rs.Close
> > > > > > > >
> > > > > > > > i get the error message "lost
> connection
> > > to
> > > > > mysql
> > > > > > > > server during query"
> > > > > > > >
> > > > > > > > any ideas?
> > > > > > > >
> > > > > > > > thanks
>
=== message truncated ===




__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

re: blob issue

Do you connect through named pipe ?
I've observed the 'gone_away_error' with bigger blobs when using named =
pipes.
The same insert-query via tcp/ip works just normal.
Probably an issue for the bug-system, 'just found no time sofar to write =
a report...
regards,
armin.

> -----Original Message-----
> From: Mark Mchugh [mailto:mark_mch@yahoo.com]
> Sent: Monday, April 18, 2005 6:15 PM
> To: Daniel da Veiga; MySQL Win32 List
> Subject: Re: blob issue
>=20
> its strange, fromt he server i get this for max_allowed_packet =
> 104856576
>=20
> that should be big enought for a 16M file?
>=20
>=20
>=20
> --- Daniel da Veiga wrote:
>=20
> > Try setting the package in bytes, I mean 33554432 bytes :)
> Dunno, but
> > the error message is very clear to me, seems your're
> getting some odd
> > issue setting the value, so, try bytes, and do a 'show global=20
> > variables like '%package%'' at your console to see the
> exact value of
> > the variable.
> >=20
> > Good luck,
> >=20
> > On 4/18/05, Mark Mchugh wrote:
> > > I have an update, the error message i am now
> > getting
> > > is
> > >=20
> > > "got packet bigger than 'max_allowed_packet'"
> > >=20
> > > i wonder is this a client problem? i ahve added
> > the
> > > following into the my.ini
> > >=20
> > > [client]
> > > max_allowed_packet=3D32M
> > >=20
> > >=20
> > > --- Daniel da Veiga
> > wrote:
> > >=20
> > > > Well, I did some research on you error (mostly google and mysql
> > > > manual) and the most common causes of this error includes your=20
> > > > problems (so, you should have found this :P).
> > I'll
> > > > work with the R T
> > > > Fine M *lol*
> > > >
> > > > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > >
> > > > It happens that your client is sending large
> > packets
> > > > to the server, as
> > > > eva2000 stated at the Vbulleting Forum:
> > > >
> > > > "You can also get these errors if you send a
> > query
> > > > to the server that
> > > > is incorrect or too large. If mysqld gets a
> > packet
> > > > that is too large
> > > > or out of order, it assumes that something has
> > gone
> > > > wrong with the
> > > > client and closes the connection. If you need
> > big
> > > > queries (for
> > > > example, if you are working with big BLOB
> > columns),
> > > > you can increase
> > > > the query limit by starting mysqld with the -O=20
> > > > max_allowed_packet=3D# option (default 1M) or via
> max_allowed_packet
> > > > variable in your /etc/my.cnf file and restarting mysql
> after you
> > > > edited your /etc/my.cnf file. The extra memory is allocated
> > on
> > > > demand, so mysqld
> > > > will use more memory only when you issue a big
> > query
> > > > or when mysqld
> > > > must return a big result row"
> > > >
> > > > Try this and let me know if it works.
> > > > Good luck.
> > > >
> > > > On 4/18/05, Mark Mchugh
> > wrote:
> > > > > Hi Daniel,
> > > > > Have tried that, still the same, this is odd?
> > > > >
> > > > > Mark
> > > > >
> > > > >
> > > > > --- Daniel da Veiga
> > > > wrote:
> > > > > > If it takes some times for your app to load
> > and
> > > > use
> > > > > > the file data, the
> > > > > > server considers this idle time, and thus
> > > > disconnect
> > > > > > you after a few
> > > > > > seconds, try setting a higher value for "wait_timeout" and=20
> > > > > > "interactive_timeout", or rebuild your code
> > to
> > > > > > connect and insert the
> > > > > > data only after all processing of the file
> > is
> > > > > > complete. So, your
> > > > > > rs.Open would be executed only AFTER mystream.LoadFromFile,=20
> > > > > > avoiding idle time.
> > > > > >
> > > > > > Hope that helps,
> > > > > >
> > > > > > On 4/15/05, Mark Mchugh
> > > > wrote:
> > > > > > > hi,
> > > > > > > I am trying to add files to my database,
> > on
> > > > the
> > > > > > server
> > > > > > >
> > > > > > > max_allowed_packet =3D 1073741824
> > > > > > >
> > > > > > > and i am using the following code..
> > > > > > >
> > > > > > > sqlstr =3D "select * from files where 1=3D0;"
> > > > > > >
> > > > > > > rs.Open sqlstr, connMySQL,
> > adOpenStatic,
> > > > > > > adLockOptimistic
> > > > > > > rs.AddNew
> > > > > > > mystream.Open
> > > > > > > Debug.Print strFileName
> > > > > > > mystream.LoadFromFile strFileName
> > > > > > > rs!file_name =3D "All Scanned"
> > > > > > > rs!Fromp =3D CatDir
> > > > > > > rs!Desc1 =3D ronsnotes
> > > > > > > rs!file_size =3D mystream.Size
> > > > > > > rs!policyid =3D fdesc
> > > > > > > rs!file =3D mystream.Read
> > > > > > > rs.Update
> > > > > > > mystream.Close
> > > > > > > rs.Close
> > > > > > >
> > > > > > > i get the error message "lost connection
> > to
> > > > mysql
> > > > > > > server during query"
> > > > > > >
> > > > > > > any ideas?
> > > > > > >
> > > > > > > thanks
> > > > > > >
> > > > > > > __________________________________
> > > > > > > Do you Yahoo!?
> > > > > > > Read only the mail you want - Yahoo! Mail
> > > > > > SpamGuard.
> > > > > > > http://promotions.yahoo.com/new_mail
> > > > > > >
> > > > > > > --
> > > > > > > MySQL Windows Mailing List For list archives:
> > > > http://lists.mysql.com/win32
> > > > > > > To unsubscribe:
> > > > > >
> > > > >
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Daniel da Veiga
> > > > > > Computer Operator - RS - Brazil
> > > > > >
> > > > > > --
> > > > > > MySQL Windows Mailing List
> > > > > > For list archives:
> > http://lists.mysql.com/win32
> > > > > > To unsubscribe:
> > > > > >
> > > > >
> > > >
> > >
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > Plan great trips with Yahoo! Travel: Now over
> > > > 17,000 guides!
> > > > > http://travel.yahoo.com/p-travelguide
> > > > >
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> >=20
> ===3D message truncated ===3D
>=20
>=20
>=20
> =09
> __________________________________
> Do you Yahoo!?=20
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =20
> http://lists.mysql.com/win32?unsub=3Darmin.schoeffmann@aegae on.de
>=20
>=20
>=20
>=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: blob issue

Your client is the APP that is accessing MySQL, not the console at the
machine, *lol*, it would be so easy that way, but you should check the
usage of the library you're using to access (ADO, dunno) and the
syntax to set the connection parameters... I guess your problem is
found and its now a matter of how you'll fix it, and the web and the
Manual may help you more than me.

On 4/18/05, Mark Mchugh wrote:
> its seems the same when i have added to client
> section, and i've set the max_allowed_packet=3D100M for
> both client and server, do i need to change something
> on my local client machine that sending the blob to
> the server?
>=20
>=20
> --- Daniel da Veiga wrote:
>=20
> > Yeah it should, but hey, at least now you moved into
> > a new MySQL
> > Manual section :) that is A.2.9. Check it out. Well,
> > I did it, noticed
> > that this variable, as you stated before, must be
> > set BOTH client and
> > server side... So, now you should discover wich one
> > (client or server)
> > is sending you the message (or just set the variable
> > in both) :)
> >
> > More information? Check this out:
> >
> >
> http://dev.mysql.com/doc/mysql/en/packet-too-large.html
> >
> > Good luck, again...
> >
> > On 4/18/05, Mark Mchugh wrote:
> > > its strange, fromt he server i get this for
> > > max_allowed_packet =3D 104856576
> > >
> > > that should be big enought for a 16M file?
> > >
> > >
> > > --- Daniel da Veiga
> > wrote:
> > >
> > > > Try setting the package in bytes, I mean
> > 33554432
> > > > bytes :)
> > > > Dunno, but the error message is very clear to
> > me,
> > > > seems your're
> > > > getting some odd issue setting the value, so,
> > try
> > > > bytes, and do a
> > > > 'show global variables like '%package%'' at your
> > > > console to see the
> > > > exact value of the variable.
> > > >
> > > > Good luck,
> > > >
> > > > On 4/18/05, Mark Mchugh
> > wrote:
> > > > > I have an update, the error message i am now
> > > > getting
> > > > > is
> > > > >
> > > > > "got packet bigger than 'max_allowed_packet'"
> > > > >
> > > > > i wonder is this a client problem? i ahve
> > added
> > > > the
> > > > > following into the my.ini
> > > > >
> > > > > [client]
> > > > > max_allowed_packet=3D32M
> > > > >
> > > > >
> > > > > --- Daniel da Veiga
> > > > wrote:
> > > > >
> > > > > > Well, I did some research on you error
> > (mostly
> > > > > > google and mysql
> > > > > > manual) and the most common causes of this
> > error
> > > > > > includes your
> > > > > > problems (so, you should have found this
> > :P).
> > > > I'll
> > > > > > work with the R T
> > > > > > Fine M *lol*
> > > > > >
> > > > > >
> > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > > > >
> > > > > > It happens that your client is sending large
> > > > packets
> > > > > > to the server, as
> > > > > > eva2000 stated at the Vbulleting Forum:
> > > > > >
> > > > > > "You can also get these errors if you send a
> > > > query
> > > > > > to the server that
> > > > > > is incorrect or too large. If mysqld gets a
> > > > packet
> > > > > > that is too large
> > > > > > or out of order, it assumes that something
> > has
> > > > gone
> > > > > > wrong with the
> > > > > > client and closes the connection. If you
> > need
> > > > big
> > > > > > queries (for
> > > > > > example, if you are working with big BLOB
> > > > columns),
> > > > > > you can increase
> > > > > > the query limit by starting mysqld with the
> > -O
> > > > > > max_allowed_packet=3D#
> > > > > > option (default 1M) or via
> > max_allowed_packet
> > > > > > variable in your
> > > > > > /etc/my.cnf file and restarting mysql after
> > you
> > > > > > edited your
> > > > > > /etc/my.cnf file. The extra memory is
> > allocated
> > > > on
> > > > > > demand, so mysqld
> > > > > > will use more memory only when you issue a
> > big
> > > > query
> > > > > > or when mysqld
> > > > > > must return a big result row"
> > > > > >
> > > > > > Try this and let me know if it works.
> > > > > > Good luck.
> > > > > >
> > > > > > On 4/18/05, Mark Mchugh
> > > > wrote:
> > > > > > > Hi Daniel,
> > > > > > > Have tried that, still the same, this is
> > odd?
> > > > > > >
> > > > > > > Mark
> > > > > > >
> > > > > > >
> > > > > > > --- Daniel da Veiga
> >
> > > > > > wrote:
> > > > > > > > If it takes some times for your app to
> > load
> > > > and
> > > > > > use
> > > > > > > > the file data, the
> > > > > > > > server considers this idle time, and
> > thus
> > > > > > disconnect
> > > > > > > > you after a few
> > > > > > > > seconds, try setting a higher value for
> > > > > > > > "wait_timeout" and
> > > > > > > > "interactive_timeout", or rebuild your
> > code
> > > > to
> > > > > > > > connect and insert the
> > > > > > > > data only after all processing of the
> > file
> > > > is
> > > > > > > > complete. So, your
> > > > > > > > rs.Open would be executed only AFTER
> > > > > > > > mystream.LoadFromFile, avoiding
> > > > > > > > idle time.
> > > > > > > >
> > > > > > > > Hope that helps,
> > > > > > > >
> > > > > > > > On 4/15/05, Mark Mchugh
> >
> > > > > > wrote:
> > > > > > > > > hi,
> > > > > > > > > I am trying to add files to my
> > database,
> > > > on
> > > > > > the
> > > > > > > > server
> > > > > > > > >
> > > > > > > > > max_allowed_packet =3D 1073741824
> > > > > > > > >
> > > > > > > > > and i am using the following code..
> > > > > > > > >
> > > > > > > > > sqlstr =3D "select * from files where
> > 1=3D0;"
> > > > > > > > >
> > > > > > > > > rs.Open sqlstr, connMySQL,
> > > > adOpenStatic,
> > > > > > > > > adLockOptimistic
> > > > > > > > > rs.AddNew
> > > > > > > > > mystream.Open
> > > > > > > > > Debug.Print strFileName
> > > > > > > > > mystream.LoadFromFile strFileName
> > > > > > > > > rs!file_name =3D "All Scanned"
> > > > > > > > > rs!Fromp =3D CatDir
> > > > > > > > > rs!Desc1 =3D ronsnotes
> > > > > > > > > rs!file_size =3D mystream.Size
> > > > > > > > > rs!policyid =3D fdesc
> > > > > > > > > rs!file =3D mystream.Read
> > > > > > > > > rs.Update
> > > > > > > > > mystream.Close
> > > > > > > > > rs.Close
> > > > > > > > >
> > > > > > > > > i get the error message "lost
> > connection
> > > > to
> > > > > > mysql
> > > > > > > > > server during query"
> > > > > > > > >
> > > > > > > > > any ideas?
> > > > > > > > >
> > > > > > > > > thanks
> >
> ===3D message truncated ===3D
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: blob issue

thanks.....

here's my connection.....


Set connMySQL = New ADODB.Connection
connMySQL.ConnectionString = "DRIVER={mySQL ODBC
3.51 Driver};" _
& "SERVER=192.168.0.55;" _
& "DATABASE=acctest;" _
& "UID=root;" _
& "PWD=xxxxxxxx;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384


is this ok for blobs?


thanks



--- Daniel da Veiga wrote:

> Your client is the APP that is accessing MySQL, not
> the console at the
> machine, *lol*, it would be so easy that way, but
> you should check the
> usage of the library you're using to access (ADO,
> dunno) and the
> syntax to set the connection parameters... I guess
> your problem is
> found and its now a matter of how you'll fix it, and
> the web and the
> Manual may help you more than me.
>
> On 4/18/05, Mark Mchugh wrote:
> > its seems the same when i have added to client
> > section, and i've set the max_allowed_packet=100M
> for
> > both client and server, do i need to change
> something
> > on my local client machine that sending the blob
> to
> > the server?
> >
> >
> > --- Daniel da Veiga
> wrote:
> >
> > > Yeah it should, but hey, at least now you moved
> into
> > > a new MySQL
> > > Manual section :) that is A.2.9. Check it out.
> Well,
> > > I did it, noticed
> > > that this variable, as you stated before, must
> be
> > > set BOTH client and
> > > server side... So, now you should discover wich
> one
> > > (client or server)
> > > is sending you the message (or just set the
> variable
> > > in both) :)
> > >
> > > More information? Check this out:
> > >
> > >
> >
>
http://dev.mysql.com/doc/mysql/en/packet-too-large.html
> > >
> > > Good luck, again...
> > >
> > > On 4/18/05, Mark Mchugh
> wrote:
> > > > its strange, fromt he server i get this for
> > > > max_allowed_packet = 104856576
> > > >
> > > > that should be big enought for a 16M file?
> > > >
> > > >
> > > > --- Daniel da Veiga
> > > wrote:
> > > >
> > > > > Try setting the package in bytes, I mean
> > > 33554432
> > > > > bytes :)
> > > > > Dunno, but the error message is very clear
> to
> > > me,
> > > > > seems your're
> > > > > getting some odd issue setting the value,
> so,
> > > try
> > > > > bytes, and do a
> > > > > 'show global variables like '%package%'' at
> your
> > > > > console to see the
> > > > > exact value of the variable.
> > > > >
> > > > > Good luck,
> > > > >
> > > > > On 4/18/05, Mark Mchugh
> > > wrote:
> > > > > > I have an update, the error message i am
> now
> > > > > getting
> > > > > > is
> > > > > >
> > > > > > "got packet bigger than
> 'max_allowed_packet'"
> > > > > >
> > > > > > i wonder is this a client problem? i ahve
> > > added
> > > > > the
> > > > > > following into the my.ini
> > > > > >
> > > > > > [client]
> > > > > > max_allowed_packet=32M
> > > > > >
> > > > > >
> > > > > > --- Daniel da Veiga
>
> > > > > wrote:
> > > > > >
> > > > > > > Well, I did some research on you error
> > > (mostly
> > > > > > > google and mysql
> > > > > > > manual) and the most common causes of
> this
> > > error
> > > > > > > includes your
> > > > > > > problems (so, you should have found this
> > > :P).
> > > > > I'll
> > > > > > > work with the R T
> > > > > > > Fine M *lol*
> > > > > > >
> > > > > > >
> > > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > > > > >
> > > > > > > It happens that your client is sending
> large
> > > > > packets
> > > > > > > to the server, as
> > > > > > > eva2000 stated at the Vbulleting Forum:
> > > > > > >
> > > > > > > "You can also get these errors if you
> send a
> > > > > query
> > > > > > > to the server that
> > > > > > > is incorrect or too large. If mysqld
> gets a
> > > > > packet
> > > > > > > that is too large
> > > > > > > or out of order, it assumes that
> something
> > > has
> > > > > gone
> > > > > > > wrong with the
> > > > > > > client and closes the connection. If you
> > > need
> > > > > big
> > > > > > > queries (for
> > > > > > > example, if you are working with big
> BLOB
> > > > > columns),
> > > > > > > you can increase
> > > > > > > the query limit by starting mysqld with
> the
> > > -O
> > > > > > > max_allowed_packet=#
> > > > > > > option (default 1M) or via
> > > max_allowed_packet
> > > > > > > variable in your
> > > > > > > /etc/my.cnf file and restarting mysql
> after
> > > you
> > > > > > > edited your
> > > > > > > /etc/my.cnf file. The extra memory is
> > > allocated
> > > > > on
> > > > > > > demand, so mysqld
> > > > > > > will use more memory only when you issue
> a
> > > big
> > > > > query
> > > > > > > or when mysqld
> > > > > > > must return a big result row"
> > > > > > >
> > > > > > > Try this and let me know if it works.
> > > > > > > Good luck.
> > > > > > >
> > > > > > > On 4/18/05, Mark Mchugh
>
> > > > > wrote:
> > > > > > > > Hi Daniel,
> > > > > > > > Have tried that, still the same, this
> is
> > > odd?
> > > > > > > >
> > > > > > > > Mark
> > > > > > > >
> > > > > > > >
> > > > > > > > --- Daniel da Veiga
> > >
> > > > > > > wrote:
> > > > > > > > > If it takes some times for your app
> to
> > > load
> > > > > and
> > > > > > > use
> > > > > > > > > the file data, the
> > > > > > > > > server considers this idle time, and
> > > thus
> > > > > > > disconnect
> > > > > > > > > you after a few
> > > > > > > > > seconds, try setting a higher value
> for
> > > > > > > > > "wait_timeout" and
> > > > > > > > > "interactive_timeout", or rebuild
> your
> > > code
> > > > > to
>
=== message truncated ===




__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: blob issue

I sincerelly dunno!
Take a look at:

http://dev.mysql.com/tech-resources/articles/vb-blob-handlin g.html

As stated in a mail from this list... There are samples there and the
connection string, maybe if you take a look at the manual, set it and
try it, sorry, but I guess the list can't help anymore, as you KNOW
your problem and MySQL docs are extense and rich.

Good luck,

On 4/19/05, Mark Mchugh wrote:
> thanks.....
>=20
> here's my connection.....
>=20
> Set connMySQL =3D New ADODB.Connection
> connMySQL.ConnectionString =3D "DRIVER=3D{mySQL ODBC
> 3.51 Driver};" _
> & "SERVER=3D192.168.0.55;" _
> & "DATABASE=3Dacctest;" _
> & "UID=3Droot;" _
> & "PWD=3Dxxxxxxxx;" _
> & "OPTION=3D" & 1 + 2 + 8 + 32 + 2048 + 16384
>=20
> is this ok for blobs?
>=20
> thanks
>=20
>=20
> --- Daniel da Veiga wrote:
>=20
> > Your client is the APP that is accessing MySQL, not
> > the console at the
> > machine, *lol*, it would be so easy that way, but
> > you should check the
> > usage of the library you're using to access (ADO,
> > dunno) and the
> > syntax to set the connection parameters... I guess
> > your problem is
> > found and its now a matter of how you'll fix it, and
> > the web and the
> > Manual may help you more than me.
> >
> > On 4/18/05, Mark Mchugh wrote:
> > > its seems the same when i have added to client
> > > section, and i've set the max_allowed_packet=3D100M
> > for
> > > both client and server, do i need to change
> > something
> > > on my local client machine that sending the blob
> > to
> > > the server?
> > >
> > >
> > > --- Daniel da Veiga
> > wrote:
> > >
> > > > Yeah it should, but hey, at least now you moved
> > into
> > > > a new MySQL
> > > > Manual section :) that is A.2.9. Check it out.
> > Well,
> > > > I did it, noticed
> > > > that this variable, as you stated before, must
> > be
> > > > set BOTH client and
> > > > server side... So, now you should discover wich
> > one
> > > > (client or server)
> > > > is sending you the message (or just set the
> > variable
> > > > in both) :)
> > > >
> > > > More information? Check this out:
> > > >
> > > >
> > >
> >
> http://dev.mysql.com/doc/mysql/en/packet-too-large.html
> > > >
> > > > Good luck, again...
> > > >
> > > > On 4/18/05, Mark Mchugh
> > wrote:
> > > > > its strange, fromt he server i get this for
> > > > > max_allowed_packet =3D 104856576
> > > > >
> > > > > that should be big enought for a 16M file?
> > > > >
> > > > >
> > > > > --- Daniel da Veiga
> > > > wrote:
> > > > >
> > > > > > Try setting the package in bytes, I mean
> > > > 33554432
> > > > > > bytes :)
> > > > > > Dunno, but the error message is very clear
> > to
> > > > me,
> > > > > > seems your're
> > > > > > getting some odd issue setting the value,
> > so,
> > > > try
> > > > > > bytes, and do a
> > > > > > 'show global variables like '%package%'' at
> > your
> > > > > > console to see the
> > > > > > exact value of the variable.
> > > > > >
> > > > > > Good luck,
> > > > > >
> > > > > > On 4/18/05, Mark Mchugh
> > > > wrote:
> > > > > > > I have an update, the error message i am
> > now
> > > > > > getting
> > > > > > > is
> > > > > > >
> > > > > > > "got packet bigger than
> > 'max_allowed_packet'"
> > > > > > >
> > > > > > > i wonder is this a client problem? i ahve
> > > > added
> > > > > > the
> > > > > > > following into the my.ini
> > > > > > >
> > > > > > > [client]
> > > > > > > max_allowed_packet=3D32M
> > > > > > >
> > > > > > >
> > > > > > > --- Daniel da Veiga
> >
> > > > > > wrote:
> > > > > > >
> > > > > > > > Well, I did some research on you error
> > > > (mostly
> > > > > > > > google and mysql
> > > > > > > > manual) and the most common causes of
> > this
> > > > error
> > > > > > > > includes your
> > > > > > > > problems (so, you should have found this
> > > > :P).
> > > > > > I'll
> > > > > > > > work with the R T
> > > > > > > > Fine M *lol*
> > > > > > > >
> > > > > > > >
> > > > http://dev.mysql.com/doc/mysql/en/gone-away.html
> > > > > > > >
> > > > > > > > It happens that your client is sending
> > large
> > > > > > packets
> > > > > > > > to the server, as
> > > > > > > > eva2000 stated at the Vbulleting Forum:
> > > > > > > >
> > > > > > > > "You can also get these errors if you
> > send a
> > > > > > query
> > > > > > > > to the server that
> > > > > > > > is incorrect or too large. If mysqld
> > gets a
> > > > > > packet
> > > > > > > > that is too large
> > > > > > > > or out of order, it assumes that
> > something
> > > > has
> > > > > > gone
> > > > > > > > wrong with the
> > > > > > > > client and closes the connection. If you
> > > > need
> > > > > > big
> > > > > > > > queries (for
> > > > > > > > example, if you are working with big
> > BLOB
> > > > > > columns),
> > > > > > > > you can increase
> > > > > > > > the query limit by starting mysqld with
> > the
> > > > -O
> > > > > > > > max_allowed_packet=3D#
> > > > > > > > option (default 1M) or via
> > > > max_allowed_packet
> > > > > > > > variable in your
> > > > > > > > /etc/my.cnf file and restarting mysql
> > after
> > > > you
> > > > > > > > edited your
> > > > > > > > /etc/my.cnf file. The extra memory is
> > > > allocated
> > > > > > on
> > > > > > > > demand, so mysqld
> > > > > > > > will use more memory only when you issue
> > a
> > > > big
> > > > > > query
> > > > > > > > or when mysqld
> > > > > > > > must return a big result row"
> > > > > > > >
> > > > > > > > Try this and let me know if it works.
> > > > > > > > Good luck.
> > > > > > > >
> > > > > > > > On 4/18/05, Mark Mchugh
> >
> > > > > > wrote:
> > > > > > > > > Hi Daniel,
> > > > > > > > > Have tried that, still the same, this
> > is
> > > > odd?
> > > > > > > > >
> > > > > > > > > Mark
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > --- Daniel da Veiga
> > > >
> > > > > > > > wrote:
> > > > > > > > > > If it takes some times for your app
> > to
> > > > load
> > > > > > and
> > > > > > > > use
> > > > > > > > > > the file data, the
> > > > > > > > > > server considers this idle time, and
> > > > thus
> > > > > > > > disconnect
> > > > > > > > > > you after a few
> > > > > > > > > > seconds, try setting a higher value
> > for
> > > > > > > > > > "wait_timeout" and
> > > > > > > > > > "interactive_timeout", or rebuild
> > your
> > > > code
> > > > > > to
> >
> ===3D message truncated ===3D
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org