[unixODBC-support] unixODBC - isql not working with MSSQL

Andy Pflueger AndyPflueger at ivyhill-cinram.com
Thu Jul 17 13:12:22 BST 2008


Nick wrote:
> Well, its finding the driver. Things to check are is freetds using the 
> odbcinst lib to read the ini file or doing it itself. Maybe worth 
> setting ODBCINI to point to your odbc.iui file, or use strace to see 
> what ini is being opened after the driver lib is loaded.

Hello again,

I used strace as suggested and determined that isql is using the trial copy
of easysoft's MSSQL Server drivers that have expired. How can I
uninstall/disable these on my system so it'll use /usr/lib's or
/usr/local/lib's libraries instead?

open("/usr/local/easysoft/unixODBC/lib/libodbc.so.1", O_RDONLY) = 3
read(3,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0}\0\0004\0\0\0"..., 512) =
512
fstat64(3, {st_mode=S_IFREG|0755, st_size=540760, ...}) = 0
old_mmap(NULL, 491068, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0)
= 0xe84000
old_mmap(0xef7000, 20480, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x72000) = 0xef7000
mprotect(0xbfe84000, 4096, PROT_READ|PROT_WRITE|PROT_EXEC|PROT_GROWSDOWN) =
0
close(3)                                = 0
open("/usr/local/easysoft/unixODBC/lib/libodbcinst.so.1", O_RDONLY) = 3
read(3,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\2604\0\0004\0\0\0"..., 512)
= 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=109270, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0xb7f29000
old_mmap(NULL, 86656, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0)
= 0xdaa000
old_mmap(0xdbe000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0xdbe000

I've edited /etc/ld.so.conf and rebooted thinking that would eliminate the
system knowing about these but that didn't seem to help. The appropriate
ODBC env variables are as follows:

$ env |grep ODBC
ODBCSYSINI=/etc
ODBCINI=/etc/odbc.ini

$ env |grep FREE
FREETDSCONF=/usr/local/etc/freetds.conf

I just basically would like to completely uninstall Easysoft's ODBC-SQL from
my system and use the freetds & unixODBC which were installed separately
yesterday.

TIA,
Andy


_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support



More information about the unixODBC-support mailing list