Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

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


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

I can help with the ODBC setup, files etc (since I've written an ODBC driver and contributed to unixODBC) but I've never used the driver you are using. It looks like it needs something set up outside of normal ODBC (e.g. like an env var) but I cannot tell you what that is (e.g. with IBM's DB2 driver you have to DB2_INSTANCE env var or you get exactly the same error you are getting). Surely Microsoft have some docs to tell you what you need to do or perhaps the installer set something in your environment and you are logged in as someone else - just a guess. I'm surprised the installer did not create a driver section in your driver manager files for you.


Comment on Re^5: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
Re^6: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by venu_hs (Novice) on Feb 12, 2013 at 15:28 UTC

    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!!

      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.

        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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (6)
As of 2014-07-12 00:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (237 votes), past polls