RE: [PEAR] DB -> passwort problem with oracle
| From: | Labes Dirk | Date: | Fri, 11 Jul 2003 11:45:42 +0000 |
| Subject: | RE: [PEAR] DB -> passwort problem with oracle | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-6567@lists.php.net to get a copy of this message | ||
I've solved the problem:
I must make:
$pass1 = urlencode($pass1);
That's all :-)
greetinX
Dirk
------------------------------------------------------------------
Dirk Labes
Dipl.-Ing. (FH)
Webprogrammer/designer - IT
EBV Elektronik GmbH & Co. KG
Tel. ++49 (0)8121 - 774-562
------------------------------------------------------------------
-----Original Message-----
From: Glemnitz, Wolfgang [mailto:W.Glemnitz@SMNG.SMWK.SACHSEN.DE]
Sent: Freitag, 11. Juli 2003 13:39
To: 'pear-general@lists.php.net'
Subject: AW: [PEAR] DB -> passwort problem with oracle
-----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
--
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php