01-10-2013
Is this unixODBC or windows?
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)