Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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

by mje (Curate)
on Feb 12, 2013 at 13:55 UTC ( #1018363=note: print w/replies, xml ) Need Help??

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

You are better having a full path to the driver in the odbcinst.ini file as it will only work if your relative path is correct for the directory you are in.

I don't use the ODBC driver you are using as the company I work for wrote its own SQL Server ODBC Driver. The error is saying the ODBC driver manager attempted to call SQLAllocHandle to allocate an environment and the driver returned the error IM004. This is almost always the very first call an ODBC application will make. Your driver probably needs something set in your shell environment e.g., an environment variable - but that is just a guess as I don't use that ODBC driver (what does the driver documentation say).

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

Replies are listed 'Best First'.
Re^4: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by venu_hs (Novice) on Feb 12, 2013 at 14:15 UTC

    The path in the odbcinst.ini file is an absolute path... i just removed it while posting here...sorry about that.. I am not sure if i have any documentation... As i am following up the process of DSN-less connection and ODBCINI file is not relevant here....Could you please provide me with more details...on how to implement this... Many Thanks

      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.

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1018363]
[Corion]: marto: How's things? I hope the kids are fine and you too!
[Corion]: Oh yay. I wonder why a very simple change in a program doesn't elicit a diff, and now I see that my diff program seems to have a bug ;)
[1nickt]: marto thanks for asking, so far so good. A pretty modern stack and decent procedures, although rather too much home-built stuff (e.g. a logging role that should tries to duplicate Log::Any).
[Corion]: No. It's just that I'm comparing the same output file twice, instead of comparing the output files of the two runs %-)
[Corion]: Lo and behold, running a program with the correct input files yields the correct (and expected) output. Yay me.
[1nickt]: Got a MacBook and am expected to develop directly on it, ironic given the recent thread about that.
[marto]: Corion, some not too serious issues with the kids, hopefully, other than that just dealing with commuting by car again in the winter, not much fun so far, and there's no real 'bad' weather yet :)
[marto]: 1nickt, glad to hear it, I'm sure you'll bring improvements to their stack in due course ;)
[1nickt]: Just trying to adjust to a new culture. Better doc than I am used to , but quite a bit more Agiley meta-bullshit; at least half a dozen meetings a week, strict "sprint" schedule etc. I'll adjust. And I hope to just switch off after the "scrum" each day at
[1nickt]: ... the end of the afternoon. marto How are you, snowed in? Mum and Dad expecting snow today in Surrey. (Have 5" on the ground here in NJ. And my son's high school in SOCal closed until after Xmas due to fires.)

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2017-12-11 11:43 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (289 votes). Check out past polls.