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]

Reply via email to