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

[venu_hs]

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

First of all thankyou for replying to my query. I have checked odbcinst.ini file and i have a different driver name Please find the below details

[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver= /.../..../libsqlncli-11.0.so.1790.0
Threading=1
UsageCount=1

Now i have modified the code as below

my$dbh1 = DBI->connect("dbi:ODBC:DRIVER={SQL Server Native Client 11.0
+};Server=abc.cde.corp.org\\XYZ;Database=TEST;UID=$user;PWD=$password"
+);

Now i got a different error Please find the below

DBI connect('DRIVER={SQL Server Native Client 11.0};Server=abc.cde.cor
+p.org\XYZ;Database=TEST;UID=abc;PWD=defv','',...) failed: [unixODBC][
+Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (SQL
+-IM004)

[mje]

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).

[venu_hs]

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

[mje]

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.