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

shiv kumar shivblore2000 at gmail.com
Wed Mar 21 12:57:25 GMT 2007


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.
> ------------------------------
>
> Message: 3
> Date: Wed, 21 Mar 2007 17:12:56 +0530
> From: "shiv kumar" <shivblore2000 at gmail.com>
> Subject: [unixODBC-support] How to change the CONFIGURATION path of
>        odbcinst.ini and odbc.ini
> To: unixodbc-support at easysoft.com
> Message-ID:
>        <5e2cc4050703210442q3c6544efs3ac08ccf337ccde1 at mail.gmail.com>
> Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
>
> 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
>
>
> ------------------------------
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>
> End of unixODBC-support Digest, Vol 31, Issue 9
> ***********************************************
>



More information about the unixODBC-support mailing list