Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:19891 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 37488 invoked by uid 1010); 2 Nov 2005 14:50:14 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 37473 invoked from network); 2 Nov 2005 14:50:14 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 2 Nov 2005 14:50:14 -0000 X-Host-Fingerprint: 81.19.68.198 netlogic-ramtel.cust.ramtel.ru Received: from ([81.19.68.198:10825] helo=localhost.localdomain) by pb1.pair.com (ecelerity 2.0 beta r(6323M)) with SMTP id 6C/6D-02082-522D8634 for ; Wed, 02 Nov 2005 09:50:13 -0500 Message-ID: <6C.6D.02082.522D8634@pb1.pair.com> To: internals@lists.php.net Date: Wed, 02 Nov 2005 17:54:09 +0300 User-Agent: Mozilla Thunderbird 1.0 (X11/20050312) X-Accept-Language: en-us, en MIME-Version: 1.0 X-Enigmail-Version: 0.90.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 7bit X-Posted-By: 81.19.68.198 Subject: Is it necessary to have different DSN formats in PDO ? From: na@index20.ru (Andrey Nikolaev) What we have now is... "mssql:host=localhost;dbname=testdb" "sybase:host=localhost;dbname=testdb" "dblib:host=localhost;dbname=testdb" "mysql:host=localhost;dbname=testdb" "pgsql:host=localhost port=5432 dbname=testdb user=bruce password=mypass" "oci:dbname=//localhost:1521/mydb" "firebird:User=john;Password=mypass;Database=DATABASE.GDE;DataSource=localhost;Port=3050" "sqlite:/opt/databases/mydb.sq3" Maybe it's better to make it more standart ? Like: "driver:host=localhost; port=1234; user=bruce; password=mypass; dbname=testdb" "driver:file=/path/to/sql.socket; user=bruce; password=mypass; dbname=testdb" It's much easer to write, parse and generate. Only don't know what to do with ODBC: "odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\db.mdb;Uid=Admin" "odbc:DSN={IBM DB2 ODBC};HOSTNAME=localhost;PORT=50000;DBNAME=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;"