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.pland 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
