Kalkunte Arun writes:
> Hello,
>
> I am trying to insert a binary object into a SQL Server table field of type
>IMAGE,
> using Perl and DBI. I have been unsuccessful so far, though I have tried all the
> solutions suggested in the various lists on the internet. Could anyone who has
> implemented such a thing successfully please let me know how to proceed ?
>
> Here is what I am doing :
>
> - Open a connection to the SQL Server database.
> - Set LongtruncOK = 1 and LongReadLen = 10MB.
>
> # Insert the document.
> $SQL = "INSERT INTO blob ( filename, data ) " .
> "VALUES ( ?, ?)";
Unless ODBC (or DBD::ODBC) does some internal magic this is not going
to work with IMAGE/TEXT datatypes, because the underlying protocol
doesn't support it (i.e. handling ?-style placeholders for blob
data).
Michael
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]