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

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` [download] Look for libodbc* files in /usr/lib64 to see what exists. Better still, post ls -la /usr/lib64/libodbc* here.	[reply] [d/l]
Re^7: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 12:19 UTC
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	[reply]
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	[reply]
Re^7: connecting to mssql on rhel7 with new mssql driver by choroba (Cardinal) on Sep 28, 2017 at 11:52 UTC
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, [download]	[reply] [d/l]
Re^8: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 12:14 UTC
thanks, I will have our sa install unixODBC-devel and retry the make	[reply]