Re: DSN hostspec problem - SOLVED with alias
| From: | Roger Spears | Date: | Mon, 19 Apr 2004 12:00:41 +0000 |
| Subject: | Re: DSN hostspec problem - SOLVED with alias | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-11951@lists.php.net to get a copy of this message | ||
Herman Sinte Maartensdijk wrote:
Do you have a TNS setup? I'm using DB with Oracle and my DSN is of the format: $dsn = 'oci8://user:pass@tns'; if 'db5.portalDomainName.com' is your TNS you might try creating a new one without periods? Maybe DB chokes on it. or it is a problem with the TNS istelf. Can you connect using this user/pass/tns using SQL+? HermanWe created an alias and this solved the problem. Our new connection string: $user = myUsername; // set to my user name $pass = myPassword; // set to my password $host = db5.portalDomainName.com; // this is the hostspec $newHost = dataB //alias that's pointing to the machine in $host $dbname = myDB; // the name of my database $dsn = "oci8://$user:$pass@$newHost/$db_name"; Thanks, Roger