CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Advanced:
Win32::ODBC + MSSQL + varbinary(max)



Jan 12, 2009, 1:35 AM

Post #1 of 2 (1819 views)
Win32::ODBC + MSSQL + varbinary(max) Can't Post

Hi ,

I'm using perl v5.8.4 + win32::ODBC + MSSQL 2005 and trying to read a binary file from a varbinary(max) column from the DB

and i'm getting this error: "Error in SQL[911] [1] [0] "Could not allocate enough memory (-1 bytes) for column"

I set the MaxBufSize like this: $db->SetMaxBufSize(2147483647 ); but without any results.

How can i do it ?

Thanks. Crazy

Veteran / Moderator

Jan 12, 2009, 8:16 AM

Post #2 of 2 (1813 views)
Re: [ptop] Win32::ODBC + MSSQL + varbinary(max) [In reply to] Can't Post

What's the size of the binary file that is stored in that field?

I haven't used Win32::ODBC but the de-facto standard Perl module for interfacing with databases is DBI and in this case, you'd also need DBD::ODBC. Have you tried using them instead of Win32::ODBC?


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives