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 DEBIAN

isql

isql(1) 							UnixODBC Reference							   isql(1)

NAME

       isql - utility to submit SQL queries to a data source.
       iusql - Unicode version of isql.

SYNOPSIS

       isql DSN [UID [PWD]] [options]

DESCRIPTION

       isql can be used to submit SQL to a data source and to format/output results.  It can be used in batch or interactive mode.

OPTIONS

       DSN    Name of the data source you want to connect to.

       UID    Your login to connect the DSN.

       PWD    Your password needed to login to the DSN.

       -b     Batch mode.  It will not do any prompting.

       -dx    Delimit columns with x.

       -x0xXX Delimit columns with XX, where XX is in hex.  For example -x0x09 will use a tab.

       -w     Wrap results in an HTML table

       -c     Print column names on first row.	This options only has effect in combination with the -d option.

       -mn    Limit column display width to n

       -v     Verbose output.

       --version
	      This prints the version.

EXAMPLES

       cat My.sql | isql WebDB MyID MyPWD -w
	      Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank.

AUTHOR

       This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC.

UnixODBC							     Dec 2004								   isql(1)