BLOBs and recordsets

Results 1 to 2 of 2

Thread: BLOBs and recordsets

  1. #1
    Join Date
    Dec 1969

    Default BLOBs and recordsets

    I am writting a component in VB and are using ADO to get a BLOB from a mySQL database. <BR>Im using the following code (the same as in many examples) but i only recieves the error "Operation is not allowed in this context." that refers to the row "binArray = recSet(0).GetChunk(1)<BR>"<BR>Do anyone have any suggestions ?!<BR><BR>Dim binArray() As Byte<BR>Dim dbConn, recSet<BR>Dim sqlStatement<BR><BR>Set dbConn = New ADODB.Connection<BR> dbConn.CursorLocation = adUseClient<BR> dbConn.Open "DSN=admaker"<BR>Set recSet = New ADODB.Recordset<BR><BR>sqlStatement = "SELECT data FROM sessions"<BR><BR>recSet = dbConn.Execute(sqlStatement)<BR><BR>binArray = recSet(0).GetChunk(1)<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: BLOBs and recordsets

    did u ever figure this one out? am having the same problem .. gettng the same error that is....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts