Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^5: connecting to mssql on rhel7 with new mssql driver

by choroba (Archbishop)
on Sep 27, 2017 at 20:37 UTC ( #1200231=note: print w/replies, xml ) Need Help??


in reply to Re^4: connecting to mssql on rhel7 with new mssql driver
in thread connecting to mssql on rhel7 with new mssql driver

> cannot find -lodbc

It seems the header file is missing. Install the dev package for the odbc library.

($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord }map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,

Replies are listed 'Best First'.
Re^6: connecting to mssql on rhel7 with new mssql driver
by mje (Curate) on Sep 28, 2017 at 08:47 UTC

    Actually, what that is saying is it cannot find libodbc.so in the list of paths provided for linking (-L/usr/lib64). That is strange as an earlier post showed:

    042 odbc_config reports --prefix=/usr 043 odbc_config reports --include-prefix=/usr/include 044 odbc_config reports --lib-prefix=/usr/lib64 045 ODBC INC dir set to /usr/include via odbc_config 046 ODBC LIB dir set to /usr/lib64 via odbc_config 047 Using ODBCHOME /usr

    Look for libodbc* files in /usr/lib64 to see what exists. Better still, post ls -la /usr/lib64/libodbc* here.

      ls -la /usr/lib64/libodbc*
      lrwxrwxrwx 1 root root 18 Aug 29 19:54 /usr/lib64/libodbccr.so -> libodbccr.so.2.0.0
      lrwxrwxrwx 1 root root 18 Aug 29 19:53 /usr/lib64/libodbccr.so.2 -> libodbccr.so.2.0.0
      -rwxr-xr-x 1 root root 44776 Jul 15 2015 /usr/lib64/libodbccr.so.2.0.0
      lrwxrwxrwx 1 root root 24 Aug 29 19:54 /usr/lib64/libodbcdrvcfg1S.so -> libodbcdrvcfg1S.so.2.0.0
      lrwxrwxrwx 1 root root 24 Aug 29 19:53 /usr/lib64/libodbcdrvcfg1S.so.2 -> libodbcdrvcfg1S.so.2.0.0
      -rwxr-xr-x 1 root root 7016 Jul 15 2015 /usr/lib64/libodbcdrvcfg1S.so.2.0.0
      lrwxrwxrwx 1 root root 24 Aug 29 19:54 /usr/lib64/libodbcdrvcfg2S.so -> libodbcdrvcfg2S.so.2.0.0
      lrwxrwxrwx 1 root root 24 Aug 29 19:53 /usr/lib64/libodbcdrvcfg2S.so.2 -> libodbcdrvcfg2S.so.2.0.0
      -rwxr-xr-x 1 root root 6912 Jul 15 2015 /usr/lib64/libodbcdrvcfg2S.so.2.0.0
      lrwxrwxrwx 1 root root 20 Aug 29 19:53 /usr/lib64/libodbcinst.so.2 -> libodbcinst.so.2.0.0
      -rwxr-xr-x 1 root root 74616 Jul 15 2015 /usr/lib64/libodbcinst.so.2.0.0
      lrwxrwxrwx 1 root root 21 Aug 29 19:54 /usr/lib64/libodbcminiS.so -> libodbcminiS.so.2.0.0
      lrwxrwxrwx 1 root root 21 Aug 29 19:53 /usr/lib64/libodbcminiS.so.2 -> libodbcminiS.so.2.0.0
      -rwxr-xr-x 1 root root 7008 Jul 15 2015 /usr/lib64/libodbcminiS.so.2.0.0
      lrwxrwxrwx 1 root root 19 Aug 29 19:53 /usr/lib64/libodbcmyS.so -> libodbcmyS.so.2.0.0
      lrwxrwxrwx 1 root root 19 Aug 29 19:53 /usr/lib64/libodbcmyS.so.2 -> libodbcmyS.so.2.0.0
      -rwxr-xr-x 1 root root 11144 Jul 15 2015 /usr/lib64/libodbcmyS.so.2.0.0
      lrwxrwxrwx 1 root root 19 Aug 29 19:54 /usr/lib64/libodbcnnS.so -> libodbcnnS.so.2.0.0
      lrwxrwxrwx 1 root root 19 Aug 29 19:53 /usr/lib64/libodbcnnS.so.2 -> libodbcnnS.so.2.0.0
      -rwxr-xr-x 1 root root 7016 Jul 15 2015 /usr/lib64/libodbcnnS.so.2.0.0
      lrwxrwxrwx 1 root root 21 Aug 29 19:53 /usr/lib64/libodbcpsqlS.so -> libodbcpsqlS.so.2.0.0
      lrwxrwxrwx 1 root root 21 Aug 29 19:53 /usr/lib64/libodbcpsqlS.so.2 -> libodbcpsqlS.so.2.0.0
      -rwxr-xr-x 1 root root 11192 Jul 15 2015 /usr/lib64/libodbcpsqlS.so.2.0.0
      lrwxrwxrwx 1 root root 16 Aug 29 19:53 /usr/lib64/libodbc.so.2 -> libodbc.so.2.0.0
      -rwxr-xr-x 1 root root 429728 Jul 15 2015 /usr/lib64/libodbc.so.2.0.0
      lrwxrwxrwx 1 root root 20 Aug 29 19:54 /usr/lib64/libodbctxtS.so -> libodbctxtS.so.2.0.0
      lrwxrwxrwx 1 root root 20 Aug 29 19:53 /usr/lib64/libodbctxtS.so.2 -> libodbctxtS.so.2.0.0
      -rwxr-xr-x 1 root root 11152 Jul 15 2015 /usr/lib64/libodbctxtS.so.2.0.0
Re^6: connecting to mssql on rhel7 with new mssql driver
by vcoderv2 (Novice) on Sep 28, 2017 at 11:50 UTC
    can you advise which package I need to have sa install? Thank you
      Probably unixODBC-devel?

      ($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord }map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,
        thanks, I will have our sa install unixODBC-devel and retry the make

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2020-12-02 07:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (35 votes). Check out past polls.

    Notices?