How do I create a DSN for ODBC in Linux?

Question

I am digging around in a Linux application that supposedly uses DSNs to connet to SQL Server. The connection stopped working and I can't find the credentials that are being used (all I know is the DSN's name).

I am familiar with DSNs in Windows, but how are they created and where are they stored in Linux?

score 12 · Answer 1 · edited May 17 '10 at 16:32

12

For unixODBC, DSNs are listed in /usr/local/etc/odbc.ini. Installed ODBC drivers will be listed in /usr/local/etc/odbcinst.ini.

Try:

usr$ find . -iname 'odbc*.ini'

edited May 17 '10 at 16:32

sth

222,467
53
283
367

answered May 17 '10 at 13:17

initzero

852
11
13

4

For me it's `/etc/odbc.ini` and `/etc/odbcinst.ini`. `.so` libraries in `/usr/lib/odbc/`. Ubuntu 12.04 – isomorphismes Jan 14 '14 at 14:53
2

for me it's /root/.odbc.ini. You can use odbcinst -j to view config – frostymarvelous Jun 07 '16 at 11:34

score 11 · Answer 2 · edited Apr 16 '19 at 12:43

11

Simply look for your odbc.ini file. By default it should be under /etc, but I guess it can differ from one Linux flavour to another.

This is a generalized guide for Linux/Unix.

Hope this helps.

edited Apr 16 '19 at 12:43

sebastian-c

15,057
3
47
93

answered Dec 30 '08 at 20:34

adilei

358
3
9

How do I create a DSN for ODBC in Linux?

2 Answers2