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

i searched and found that it could be a problem with my /etc/odbc.ini file details. Actually i created a new file odbc.ini in local path and modified the environment variable $ODBCINI pointed to local file. Please tell me what i am doing wrong here...appreciate if some one could post the step by step process to implement the UnixODBC to connect to sql server... Thanks

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

Replies are listed 'Best First'.
Re^3: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue by mje (Curate) on Feb 12, 2013 at 13:33 UTC
You've got 2 problems - which one do you want help with? the DBD::Sybase problem or the DBD::ODBC one? For the DBD::Sybase one you should check your Sybase interfaces file I think (but I'm not a Sybase guy so I could be wrong). For the ODBC issue I can help but I'll need to know what ODBC driver you are using. The odbc.ini file is irrelevant if you are using a DSN-less connection which you are if your ODBC connection string starts with DRIVER={something} instead of DSN=somethingelse. I've already shown you a valid odbcinst.ini file.	[reply]

Replies are listed 'Best First'.

Re^3: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by mje (Curate) on Feb 12, 2013 at 13:33 UTC

You've got 2 problems - which one do you want help with? the DBD::Sybase problem or the DBD::ODBC one? For the DBD::Sybase one you should check your Sybase interfaces file I think (but I'm not a Sybase guy so I could be wrong). For the ODBC issue I can help but I'll need to know what ODBC driver you are using. The odbc.ini file is irrelevant if you are using a DSN-less connection which you are if your ODBC connection string starts with DRIVER={something} instead of DSN=somethingelse. I've already shown you a valid odbcinst.ini file.

[reply]