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

Replies are listed 'Best First'.
Re^4: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 27, 2017 at 20:25 UTC
Thanks guys -- I have not installed modules before.. so appreciate your patience :) I had our sa install gcc: devtoolset-6 .. Getting different errors now... :( What do you think? TYVM >make gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include ConvertUTF.c gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include ODBC.c gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include dbdimp.c dbdimp.c: In function 'odbc_db_STORE_attrib': dbdimp.c:4742:22: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)pars->atrue; ^ dbdimp.c:4744:22: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)pars->afalse; ^ dbdimp.c:4997:18: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)(on ? pars->atrue : pars->afalse); ^ dbdimp.c:5002:18: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] vParam = (SQLPOINTER)(on ? pars->atrue : pars->afalse); ^ dbdimp.c:5022:27: warning: cast to pointer from integer of different s +ize [-Wint-to-pointer-cast] if (vParam == (SQLPOINTER)pars->atrue) { ^ gcc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LON +G -DSIZEOF_LONG_INT=8 -I/usr/include -I/usr/include -I. -I/efs/dist +/perl5/DBI/1.616/.exec/x86-64.rhel.7/5.10/lib/perl5/auto/DBI -D_REENT +RANT -D_GNU_SOURCE -DAPPLLIB_EXP="/efs/dist/perl5/defaults/5.10/.exec +/x86-64.linux.2.6/5.10/lib/perl5:/efs/dist/perl5/defaults/5.10/.exec/ +x86-64.linux.2.6/lib/perl5:/efs/dist/perl5/defaults/5.10/common/lib/p +erl5" -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_B +ITS=64 -O -DVERSION=\"1.56\" -DXS_VERSION=\"1.56\" -fPIC "-I/efs/di +st/perl5/core/5.10.0-ml01/.exec/x86-64.linux.2.6/lib/perl5/CORE" -DH +AVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEO +F_LONG_INT=8 -I/usr/include -I/usr/include unicode_helper.c Running Mkbootstrap for DBD::ODBC () chmod 644 ODBC.bs rm -f blib/arch/auto/DBD/ODBC/ODBC.so LD_RUN_PATH="/usr/lib64" gcc -shared -O ConvertUTF.o ODBC.o dbdimp.o + unicode_helper.o -o blib/arch/auto/DBD/ODBC/ODBC.so \ -L/usr/lib64 -lodbc \ /opt/rh/devtoolset-6/root/usr/libexec/gcc/x86_64-redhat-linux/6.3.1/ld +: cannot find -lodbc collect2: error: ld returned 1 exit status make: *** [blib/arch/auto/DBD/ODBC/ODBC.so] Error 1 [download]	[reply] [d/l]
Re^5: connecting to mssql on rhel7 with new mssql driver by choroba (Cardinal) on Sep 27, 2017 at 20:37 UTC
> 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, [download]	[reply] [d/l]
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
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
Re^8: connecting to mssql on rhel7 with new mssql driver by vcoderv2 (Novice) on Sep 28, 2017 at 12:14 UTC
Re^5: connecting to mssql on rhel7 with new mssql driver by hippo (Archbishop) on Sep 29, 2017 at 13:11 UTC
`/opt/rh/devtoolset-6/root/usr/libexec/gcc/x86_64-redhat-linux/6.3.1/ld: cannot find -lodbc` Why are you not using the system `ld`? This should be `/usr/bin/ld` on RHEL7. Are you sure that the gcc toolchain has been installed properly? Try running `ls -lZH /usr/bin/{gcc,ld}` and see if they exist OK.	[reply] [d/l] [select]