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


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

We are trying for all the possibilities for connectivity. Could you please give me any info regarding sybase interfaces file.... Also any links regarding the steps to be followed for achieving sql server connectivty from Perl. Thank you very much!!

  • Comment on Re^6: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue

Replies are listed 'Best First'.
Re^7: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by mje (Curate) on Feb 12, 2013 at 15:47 UTC

    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.

[reply]
      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
[reply]

        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.

[reply]

In Section Seekers of Perl Wisdom