Re: DBD::Oracle installation on AIX

On 21/09/2013 19:42, Nagendra Singh wrote:
> Hi,
> I have installed DBD::ODBC latest version on 64 bit Linux Machine. One
> one machine I am able to make connection to Vertica using DSN but on
> other machine I am getting following error message. My odbc.ini,
> odbcinst.ini files are matching exactly:-
> set_err:State('82') is not a 5 character string, using 's1000' instead
> at /usr/local/lib64/perl5/DBD/ODBC.pm line 153. DBI
> connect('VertcaiABITPRIM','nbxxxxx',...)failed: 523 80 (SQL-82).
> Any pointer would be appreciated.
> Regards,
> Mr. Singh

What version of Perl, DBI and DBD::ODBC are you using (latest does not 
help as new versions have recently been released))? You can generally 
get these using:

perl --version
perl -MDBI -le 'print $DBI::VERSION'
perl -MDBD::ODBC -le 'print $DBD::ODBC::VERSION'

Error state '82' is not a 5 character string and ODBC states should be. 
It might also be useful if you can provide any details of the Vertica 
ODBC Driver. S1000 is now HY000 which is a general error and should be 
accompanied with some error string.

Error '82' (even 82000) does not exist. Error code 08002 does exist and 
that can be found here -> 
http://www.easysoft.com/developer/interfaces/odbc/sqlstate_status_return_codes.html#08002

If you are using a recent DBI and DBD::ODBC you can do:

DBI_TRACE=DBD=x.log perl myprogram.pl

and x.log should contain the log of odbc calls which would help me 
identify your problem. If this file ends up empty, try again with:

DBI_TRACE=15=x.log perl myprogram.pl

Martin
-- 
Martin J. Evans
Wetherby, UK