01-09-2013
Adding DSN for MySql
Hi ,
I am not sure where to post this. Moderators please move this to right section if needed.
I need to connect to mysql through odbc.
How to add DSN entry for the server in order to use iSQL from shell to connect to MySql DB?
Thanks ans regards,
Anupam
5 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
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)... (3 Replies)
Discussion started by: jastanle84
3 Replies
2. Shell Programming and Scripting
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 Replies)
Discussion started by: vinumahalingam
3 Replies
3. UNIX for Dummies Questions & Answers
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... (9 Replies)
Discussion started by: Jdbrown239
9 Replies
4. Shell Programming and Scripting
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 Replies)
Discussion started by: AnjanM
5 Replies
5. AIX
Where can I find
dsn and TNSNAMES.ora
on UNIX AIX
Thanks for contribution (3 Replies)
Discussion started by: digioleg54
3 Replies
LEARN ABOUT PHP
pdo_informix-dsn
PDO_INFORMIX-DSN(3) 1 PDO_INFORMIX-DSN(3)
PDO_INFORMIX DSN - Connecting to Informix databases
The PDO_INFORMIX Data Source Name (DSN) is based on the Informix ODBC DSN string. Details on configuring an Informix ODBC DSN are avail-
able from the Informix Dynamic Server Information Center. The major components of the PDO_INFORMIX DSN are:
o DSN prefix
- The DSN prefix is informix:.
o DSN
- The DSN can be either a data source setup using odbc.ini or a complete connection string.
Example #1
PDO_INFORMIX DSN example using odbc.ini
The following example shows a PDO_INFORMIX DSN for connecting to an Informix database cataloged as Infdrv33 in odbc.ini:
$db = new PDO("informix:DSN=Infdrv33", "", "");
[ODBC Data Sources]
Infdrv33=INFORMIX 3.3 32-BIT
[Infdrv33]
Driver=/opt/informix/csdk_2.81.UC1G2/lib/cli/iclis09b.so
Description=INFORMIX 3.3 32-BIT
Database=common_db
LogonID=testuser
pwd=testpass
Servername=ids_server
DB_LOCALE=en_US.819
OPTIMIZEAUTOCOMMIT=1
ENABLESCROLLABLECURSORS=1
Example #2
PDO_INFORMIX DSN example using a connection string
The following example shows a PDO_INFORMIX DSN for connecting to an Informix database named common_db using the Informix connection
string syntax.
$db = new PDO("informix:host=host.domain.com; service=9800;
database=common_db; server=ids_server; protocol=onsoctcp;
EnableScrollableCursors=1", "testuser", "tespass");
PHP Documentation Group PDO_INFORMIX-DSN(3)