Re: Insert Image into Database

> It seems there is some kind of bug,
I think that too ...
> or in the ODBC driver (the last of
> my thoughts) or in the REALbasic database plugin.
>
I'm tring RealBasic 2005 and ActualTechnologies driver ... but now ...
I haven' done what I would like to do

> Imho, I would thing that for you it could be enough a simple routine to
> convert a binary file to an ASCII file.I.e., a routine which takes the
> byte codes and write them like a hexadecimal string, so to optain 2020
> from a string made of two spaces: it should be easy to convert back to
> the original binary datas using ASP.

Binary ---> ASCII
ASCII ---> Hex

Insert the Hex in a Filed

And with ASP i have to decode for any image ... isn't fast...

I try to search a stored procedure that can convert from a base64 to
binary or ASCII to binary before insert in a field

Any idea?

>
> Or maybe it's just because the plugin, in some way, treats the string
> like a SQL command.

In fact i do exactly that!
Via odbc i have'n the control of the cursor's SQL Server

>if it's so, every ' or " in the string must be

right!

Thanks too

I would resolve this thing ... if I ... became a genius ... :-)

.

Relevant Pages

  • Re: Dates from DB2 displaying as 12:00:00 AM
    ... you'll probably need to do the conversion to a string ... when you load the data since the ODBC driver doesn't appear to handle ... Set tdf = db.CreateTableDef ... reports from the DB2, so I'm only concentrating in Access on building forms ...
    (microsoft.public.access.externaldata)
  • Re: Strange Recordset/Query Problem
    ... > string examples. ... There was a bug in the ODBC driver that causes data to be ... > Bob Barrows ...
    (microsoft.public.inetserver.asp.general)
  • RE: why can i use 3 conditions in SQL statement only?
    ... Could there be a string length limitation in the ODBC driver for AS400 eg ... Could you please post the content of the variable containing the sql string ... Regards, ... "Tarek" wrote: ...
    (microsoft.public.excel.programming)
  • Re: ODBC Connection returns no Data
    ... so it's a proprietary database for which an ODBC driver is supplied ... String returns data. ... in the command text, there is an error, that ADO can't find the field. ... Dim conConn As New ADODB.Connection, ...
    (microsoft.public.data.ado)
  • Re: SQL UPDATE to Memo field problem
    ... Then that sounds like a problem with your ODBC driver. ... of the string to ODBC. ... > $iResult:=OC Set SQL in Cursor ... > The OC Execute Cursor line also errors out, ...
    (microsoft.public.fox.vfp.queries-sql)