Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to change the CONFIGURATION path of odbcinst.ini and odbc.ini

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "shiv kumar" <shivblore2000 AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] How to change the CONFIGURATION path of odbcinst.ini and odbc.ini
  • Date: Wed, 21 Mar 2007 18:28:03 +0530

I myself found how to achieve this. To override the system DSN file
path set the ODBCSYSINI and to override the user DSN path set the
ODBCINI environment variables.

On 3/21/07, shiv kumar <shivblore2000 AT gmail.com> wrote:
Hi All,

I have built the UnixODBC and FreeTDS using the configuration path
/build/unixODBC and /build/FreeTDS. Then I have copied completely
these installation directories ( unixODBC and FreeTDS ) to another
system under the directory "/export/ODBC". I have faced a lot of
problems in connecting the isql with DSN name and finally when I have
executed the following command it is showing the below result:
bash-2.04$ odbcinst -j
unixODBC 2.2.11
DRIVERS............: /build/unixODBC/etc/odbcinst.ini
SYSTEM DATA SOURCES: /build/unixODBC/etc/odbc.ini
USER DATA SOURCES..: /u/ask/.odbc.ini

From the result I found that the unixODBC is using the hard coded path
(during the build which I supplied) to find the odbcinst.ini. Also I
am able to confirm this using the below grep. I am expecting the
odbc*.ini should be accessed from the "/export/ODBC/unixODBC/etc"
directory. For the user DSN it is taking the .odbc,ini from the HOME
directory. Can any one please let me know how to change this
CONFIGURATION path of odbcinst.ini and odbc.ini without building the
libraries and executables again?

bash-2.04$ pwd
/export/ODBC/unixODBC
bash-2.04$ grep build ./*/* | more
./bin/dltest:^_
./bin/drv_template:Driver = /export/ODBC/freetds/lib/libtdsodbc.so
./bin/isql:^_
./bin/iusql:^_
./bin/odbc_config:
./bin/odbc_config:
./bin/odbcinst:ð
./lib/libboundparam.a:^_
./lib/libboundparam.la:dependency_libs='
/build/unixODBC/lib/libodbc.la -ldl -liconv -lpthread'
./lib/libboundparam.la:libdir='/build/unixODBC/lib'
./lib/libboundparam.so:^_
./lib/libboundparam.so.1:^_
./lib/libgtrtst.a:
./lib/libgtrtst.la:libdir='/build/unixODBC/lib'
./lib/libgtrtst.so:
./lib/libgtrtst.so.1:
./lib/libodbc.a:
./lib/libodbc.a: Connection Out [%s]
./lib/libodbc.a:^_
./lib/libodbc.la:libdir='/build/unixODBC/lib'
./lib/libodbc.so:
./lib/libodbc.so: Connection Out [%s]
./lib/libodbc.so:^_
./lib/libodbc.so.1:
./lib/libodbc.so.1: Connection Out [%s]
./lib/libodbc.so.1:^_
./lib/libodbccr.a:•
./lib/libodbccr.la:libdir='/build/unixODBC/lib'
./lib/libodbccr.so:•
./lib/libodbccr.so.1:•
./lib/libodbcinst.a:
./lib/libodbcinst.a:
./lib/libodbcinst.a:^_
./lib/libodbcinst.la:libdir='/build/unixODBC/lib'
./lib/libodbcinst.so:
./lib/libodbcinst.so:
./lib/libodbcinst.so:^_
./lib/libodbcinst.so.1:
./lib/libodbcinst.so.1:
./lib/libodbcinst.so.1:^_

Thanks,
Shiva





Archive powered by MHonArc 2.6.24.

Top of Page