Operating System - HP-UX
1753879 Members
7644 Online
108809 Solutions
New Discussion

Database connectivity failed

 
Sivakumar Murugan
Occasional Contributor

Database connectivity failed

Hi,

The following error comes when i execute the perl script from unix to connect SQL Server which is installed on windows machine thru DBD:ODBC and unixODBC Driver Maanger.

[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL-IM004)

could you please help me to resolve this issue.

Note:
The below environment variable I used in my perl script.

$ENV{'ODBCHOME'} = "/usr/local/unixODBC";
$ENV{'ODBCINI'} = "/opt/batchapps/omega/resin/.odbc.ini";
$ENV{'DBI_DSN'} = "dbi:ODBC:TEST";

Thanks@regards,
Shiv