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

Nick Gorham nick.gorham at easysoft.com
Thu Jul 17 14:08:08 BST 2008


Andy Pflueger wrote:

>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
>
>  
>
I would guess that you are running the copy of isql that came with our 
driver. If not, then it might be your lib path.

Deleting the unwanted bits would be one way of forcing the system to not 
use them :-).

Not that there is any reason why the unixODBC thats part of the package 
won't work with other drivers, its only a normal build of unixODBC with 
the sysconfdir set to /etc

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list