Setting LongReadLen with Win32::ODBC

bobdole has asked for the wisdom of the Perl Monks concerning the following question:

With DBI I can set the LongReadLen using this method $dbc-> {'LongReadLen'} = 999;

But how can I do that with Win32::ODBC ? I am pulling a Notes field from a DBISAM datbase casted as a longvarchar and it works fine when I use DBI and set the LongReadLen but when I pull the same fields using Win32::ODBC and setting LongReadLen the same method as I did with the DBI it stops when it hits something to large.

Comment on Setting LongReadLen with Win32::ODBC

Replies are listed 'Best First'.
Re: Setting LongReadLen with Win32::ODBC by bart (Canon) on Dec 18, 2006 at 22:02 UTC
then why aren't you using DBD::ODBC instead? AFAIK Win32::ODBC is deprecated. "Last Modified 1999.09.25."	[reply]
Re^2: Setting LongReadLen with Win32::ODBC by bobdole (Beadle) on Dec 18, 2006 at 22:06 UTC
I am running on two diffrent servers and the server where I am having the trouble I can't get the DBI::ODBC loaded proberly so I changed all the code to use win32	[reply]
Re^2: Setting LongReadLen with Win32::ODBC by bobdole (Beadle) on Dec 18, 2006 at 22:12 UTC
Is there anything I can do with the Win32 to solve that issue? I spent several hours trying to get the DBD::ODBC to compile correctly before giving up and I really dont want to have to deal with it again as well as converting all my code back.	[reply]
Re^3: Setting LongReadLen with Win32::ODBC by bart (Canon) on Dec 19, 2006 at 12:42 UTC
What perl is that for, that you can't use a precompiled PPM distribution? If you have to compile your own version, and keep having trouble with it, I'd advise to ask on the DBI Users mailing list. All the experts are there.	[reply]