Re: Re: DB_DataObject->generateDefinitions() - Filename

From:	Justin Patrin	Date:	Tue, 03 Feb 2004 17:25:39 +0000
Subject:	Re: Re: DB_DataObject->generateDefinitions() - Filename
References:	1 2 3	Groups:	php.pear.dev
Request:	Send a blank email to pear-dev+get-25443@lists.php.net to get a copy of this message

Markus Tacker wrote:

Justin Patrin wrote:
OCI8 DSNs should have a database AFAIK. Why wouldn't they? If you're using a TSN instead, it still maps to a database.
Well, I use this as the DSN and it works: oci8://user:pass@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = intra1)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME= M2KS)))

Aha! Yes, I have proposed a change similar to that to make the DB class make that for you from the real DSN rather than making you put it in yourself. However, I still don't see a DB name in that.... Just out of curiosity, why aren't you specifying a DB name? Aren't your tables within a named DB on that machine? Perhaps the SERVICE_NAME is mapping to a database? You can specify a database with SID or GLOBAL_NAME in the CONNECT_DATA. -- paperCrane <Justin Patrin>