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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



ptop
Novice

Jan 12, 2009, 1:35 AM

Post #1 of 2 (1646 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


FishMonger
Veteran / Moderator

Jan 12, 2009, 8:16 AM

Post #2 of 2 (1640 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?

http://search.cpan.org/~timb/DBI-1.607/DBI.pm
http://search.cpan.org/author/MJEVANS/DBD-ODBC-1.17/ODBC.pm

 
 


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

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