in reply to Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
The original message "ct_connect(): directory service layer: internal directory control layer error: Requested server name not found" seems to be your main problem and it suggests it is coming from the library beneath DBD::Sybase (but you did not specify what you are using). Not that I use Sybase but it suggests to me that "abc.cde.corp.org\XYZ" is possibly wrong.
Switching to unixODBC is not going to make this problem go away. The "Can't open lib 'SQL Server'" error is referring to what you've put in your odbcinst.ini file where you named the Driver which is supposed to be a path to the ODBC Driver shared lib you want to use i.e. DRIVER={SQL Server} makes unixODBC look in your odbcinst.ini file for a Driver named "SQL Server" then it looks for the key "driver" and attempts to dynamically load that shared object. You error suggests the driver key in the odbcinst.ini file says "SQL Server" which is not a valid shared object to load.
e.g., a valid odbcinst.ini file looks like this:
[ODBC] Trace=no TraceFile=/tmp/unixodbc.log [SQL Server] Description=SQL Server ODBC driver Driver=/usr/local/easysoft/sqlserver/lib/libessqlsrv.so
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Connecting to sqlserver2008 - DBD::Sybase connectivity and unixODBC issue
by venu_hs (Novice) on Feb 12, 2013 at 13:46 UTC | |
by mje (Curate) on Feb 12, 2013 at 13:55 UTC | |
by venu_hs (Novice) on Feb 12, 2013 at 14:15 UTC | |
by mje (Curate) on Feb 12, 2013 at 14:53 UTC | |
by venu_hs (Novice) on Feb 12, 2013 at 15:28 UTC | |
|