How do I create a DSN for ODBC in Linux?

sql-server linux odbc dsn
deadprogrammer picture deadprogrammer · Dec 30, 2008 · Viewed 55k times · Source

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?

Answer

adilei picture adilei · Dec 30, 2008

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.

Related questions

Linux - PHP 7.0 and MSSQL (Microsoft SQL)

Yes, I know that PHP 7.0 removed the extensions needed to connect to MSSQL. FreeTDS was my option prior to PHP 7.0 but now there really is no obvious upgrade path for those needing to still connect to MSSQL. Stupid question, but …

Read More
MSSQL Server's Native ODBC Driver for Linux and PHP 5.4

I have Apache 2.2.16 and PHP 5.4.3 on a Linux Debian 6 x64. To install the MSSQL Server's Native ODBC Driver for Linux, I use the following instructions: http://www.codesynthesis.com/~boris/blog/2011/12/02/microsoft-sql-server-odbc-driver-linux/ I configured my odbc.ini file this way: […

Read More
how to connect to SQL Server with SQuirreL SQL from non domain registered Linux box?

I need to connect to a SQL 2008 R2 Server from my Linux box that's not registered in my company's domain. I'm trying to use SQuirreL SQL version 3.2.1. I downloaded Microsoft SQL Server JDBC Driver 3.0 and assigned it to SQuirreL on …

Read More