AW: [PEAR] DB -> passwort problem with oracle
| From: | Glemnitz, Wolfgang | Date: | Fri, 11 Jul 2003 11:38:57 +0000 |
| Subject: | AW: [PEAR] DB -> passwort problem with oracle | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-6566@lists.php.net to get a copy of this message | ||
-----Ursprüngliche Nachricht-----
Von: Labes Dirk [mailto:D.Labes@ebv.com]
Gesendet: Freitag, 11. Juli 2003 12:54
An: Jeroen Houben
Cc: pear-general@lists.php.net
Betreff: RE: [PEAR] DB -> passwort problem with oracle
Hi Jeroen,
but I can't connect to the Oracle database, the passwort into the
DSN string is wrong, says pear, but it isn't wrong. There is a '+'
and a '=' in the passwort. And PEAR can't make a connection to oracle;
If I make:
$conn = OCILogon ("user", "+***=***","sid");
no problem
If I make:
$conn = DB::connect(oci8://user:+***=***@$sid);
I get the Error:
DB Error: connect failed
[nativecode=ORA-01017: invalid username/password; logon denied ]
greetinX
Dirk
Hi,
when you make this:
require_once 'DB.php';
$phptype = 'oci8';
$user = 'username';
$pass = 'password';
$db_sid = 'sid';
$dsn = "$phptype://$user:$pass@$db_sid";
// is the String correct?
echo $dsn;
$db = DB::connect($dsn);
greetinx
Wolfgang