Beefy Boxes and Bandwidth Generously Provided by pair Networks DiBona
P is for Practical
 
PerlMonks  

Re^7: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue

by mje (Deacon)
on Feb 12, 2013 at 15:47 UTC ( #1018398=note: print w/ replies, xml ) Need Help??


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.


Comment on Re^7: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1018398]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2014-04-17 02:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (437 votes), past polls