http://www.perlmonks.org?node_id=1018398


in reply to Re^6: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
in thread Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue

As I explained before, I don't use DBD::Sybase and the comment about the interfaces file was if you were connecting to Sybase - which I see you are not right now.

You have completed all the steps I know about to connect to MS SQL Server as far as ODBC is concerned - the problem is your ODBC driver now. I've never used that ODBC driver and I believe the error is from the driver. The MS SQL Server ODBC driver I use is a commercial one my company sells.

Replies are listed 'Best First'.
Re^8: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by venu_hs (Novice) on Apr 09, 2013 at 05:59 UTC
    Hi Monks,

    First i tried to check the connectivity from isql. I got the below error.

    IM004unixODBCDriver ManagerDriver's SQLAllocHandle on SQL_HANDLE_HENV failed ISQLERROR: Could not SQLConnect

    Any help on this please...

    Thanks

      I think this usually happens because the driver requires some environment variable to be set before connecting e.g., DB2 likes DB2INSTANCE setting. Perhaps there is something similar with the Sybase driver.