Adding DSN for MySql Post: 302754653

5 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

2. Shell Programming and Scripting

Shell script for adding a table in mysql with 10,000 lines ... pls help

Hi , I am new to shell scripting . I need to write a shell script in sql to add 10,000 lines of data in a table . Pls help guys :) ---------- Post updated at 07:08 PM ---------- Previous update was at 03:40 PM ---------- guys please help !!!

3. UNIX for Dummies Questions & Answers

Test new DSN connection to sql server

I installed an odbc driver and created a DSN to connect to a sql server database on AIX 6. I want to know how to test the DSN from the command line. What syntax or commands do I use? ---------- Post updated at 11:44 AM ---------- Previous update was at 08:26 AM ---------- OK I figured out how...

4. Shell Programming and Scripting

Copy UNIX File into a DSN with a specific Format

Hi All , I am new to programming and here is what i am trying to achieve , i am taking a list of mounted filesystems (based on the HLQ) , passing it on to a txt file and then copying the file to a DSN .The code i am using : df | grep WAST.*WASCFG.*ZFS | awk '{print $2}' | sort -o log.txt |...

5. AIX

I cannot find dsn and TNSNAMES.ora on UNIX

Where can I find dsn and TNSNAMES.ora on UNIX AIX Thanks for contribution

LEARN ABOUT CENTOS

odbcinst.ini

odbcinst.ini(5) 					       unixODBC manual pages						   odbcinst.ini(5)

NAME

       /etc/odbcinst.ini - An unixODBC drivers configuration

DESCRIPTION

       /etc/odbcinst.ini  is a text configuration file for unixODBC drivers. It can be edited by hand, but the recommended way to update this file
       is to use the odbcinst(1) utility.

FILE FORMAT

       The general .ini file format is:

	      [SectionName1]
	      key1 = value1
	      key2 = value2
	      ...

	      [SectionName2]
	      key1 = value1
	      key2 = value2
	      ...

       Each ODBC driver has its own section and can be referred to by the name of its section. Recognized configuration keys are:

       Description
	      A text string briefly describing the driver.

       Driver A filesystem path to the actual driver library.

       Setup  A filesystem path to the driver setup library.

       FileUsage
	      odbcinst(1) entry, if you edit the configuration file by hand, you have to supply it yourself.

   TEMPLATE FILES
       The recommended way to manage the drivers is using the odbcinst(1) utility. You can install the drivers by supplying it with template file,
       which has the same format as this file.

EXAMPLES

       An example of the actual PostgreSQL driver:

	      [PostgreSQL]
	      Description = PostgreSQL driver for GNU/Linux
	      Driver	  = /usr/lib/psqlodbcw.so
	      Setup	  = /usr/lib/libodbcpsqlS.so
	      FileUsage   = 1

       By specifying the driver like that, you can then reference it in the odbc.ini(5) as follows:

	      Driver = PostgreSQL

       The recommended way to add that driver is by creating template file containg:

	      [PostgreSQL]
	      Description = PostgreSQL driver for GNU/Linux
	      Driver	  = /usr/lib/psqlodbcw.so
	      Setup	  = /usr/lib/libodbcpsqlS.so

       and call the odbcinst(1):

	      # odbcinst -i -d -f template.ini

SEE ALSO

       odbcinst(1), odbc.ini(5)

AUTHORS

       The  authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of contributors
       see the AUTHORS file.

COPYRIGHT

       unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file.

version 2.3.1							  Thu 27 Jun 2013						   odbcinst.ini(5)