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

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

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

ptop
Novice

Jan 12, 2009, 1:35 AM

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

Jan 12, 2009, 8:16 AM

Post #2 of 2 (1076 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)

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