view this article, it's work fine with vb6 :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194975
' insert
Dim ts As String, Sql As String
Dim RS
Set RS = CreateObject("ADODB.Recordset")
RS.CursorLocation = adUseServer
RS.Open "tbl_test", CreateConnexionString(CnxSGDB), 3, 2, 2
RS.AddNew ' create a new record
FileToBlob "c:\test\barre.bmp", RS!test
RS.Update
RS.Close
' select
Sql = "select * from tbl_test order by ID desc Limit 1"
Set tstcnxADO = New ADODB.Connection
tstcnxADO.ConnectionString = CreateConnexionString(CnxSGDB)
tstcnxADO.CursorLocation = adUseServer
tstcnxADO.Open
If tstcnxADO.State = adStateOpen Then
Set RS = New ADODB.Recordset
RS.Open Sql, tstcnxADO, adOpenStatic, adLockReadOnly
BlobToFile RS!test, "c:\test\testmysql.bmp", RS!test.ActualSize
RS.Close
tstcnxADO.Close
End If
Bien a vous
Philippe
http://www.devparadise.com/
----- Original Message -----
From: "Bruno Batarelo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 3:04 PM
Subject: BLOB field and ADO
> Greetings!
>
> Has anyone ever had the following problem with ADO ODBC connection:
>
> I create a table with a BLOB field. From MySQL shell I update that field
> using insert into statement and all works perfectly. But when I try to
> execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or
> 3.51) it results with a new record, but the value in the BLOB field is
> always Null. Notice that it only happens with BLOB fields in combination
> with ODBC.
>
> Thank You
>
> Bruno
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
