Adding DSN for MySql Post: 302754663

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 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)