Re: DBD::ODBC and ODBC SQL Servre driver

"Martin J. Evans" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Organization Easysoft Limited
Message-ID <[email protected]>
On 19/06/12 16:54, Shrenuj Bansal wrote:
> On Monday, June 18, 2012 4:51:15 PM UTC-6,&quot;Martin J. Evans&quot; wrote:
>> On 18/06/2012 23:23, Shrenuj Bansal wrote:
>>> On Monday, June 18, 2012 3:54:45 PM UTC-6,&quot;Martin J. Evans&quot; wrote:
>>>> Oops, forgot to post this to the list.
>>>>
>>>> Martin
>>> Well, whenever I run the example script given to connect to the SQL Server DB, the compiler gives me an error on the "use DBI" line saying that that current system is not using the right DBI version. I wasn't sure if that was because the DBD or the ODBC driver wasn't compatible with v1.607 and the description on the website for both these modules does not really state which DBI is needed. I was using DBD-ODBC-1.33 and odbc-sqlserver-1.4.27 for the ODBC driver.
>>>
>> Can we see the error you get?
>>
>> Martin
>
> Here's the error:
>
> install_driver(ODBC) failed: DBI version 1.609 required--this is only version 1.607 at /opt/electriccloud/electriccommander/perl/lib/5.8.8/Exporter/Heavy.pm line 237.
> Compilation failed in require at (eval 3) line 3.
>
> at test.pl line 14
>

Your DBD::ODBC is too new. The latest one requires DBI 1.609.

That happened in 1.26_1 October 24, 2010

You'll need to upgrade DBI or downgrade DBD::ODBC to pre 1.26_1.

Of course if you downgrade DBD::ODBC you will lose some enhancements and bug fixes.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.