Re: [PHP-DB] problems connecting to remote oracle database

2001-07-03 Thread phil
On Tue, Jul 03, 2001 at 09:43:52AM -0400, Brian S. Dunworth wrote: > Hi Phil... > >Since you have the server name (vs. the IP address) in the HOST= verb, > make sure you have an entry in /etc/hosts for a server called 'staging' yes, that's there, otherwise, I wouldnt be able to use sqlplus

RE: [PHP-DB] problems connecting to remote oracle database

2001-07-03 Thread Brian S. Dunworth
x225 <[EMAIL PROTECTED]> - -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 7:52 PM To: [EMAIL PROTECTED] Subject:Re: [PHP-DB] problems connecting to remote oracle database a little more info..

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread phil
a little more info... I've just tried a few public oracle-sql tools. Seems to have the same problem. I can connect just fine to the database using sqlplus. But when I try the hand-compiled tools, linked against libclntsh.so, it doenst properly authenticate to the remote system. Hey... $ORACLE_HO

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread phil
On Mon, Jul 02, 2001 at 02:07:38PM -0400, Brian S. Dunworth wrote: > Hi Phil, > >Make sure that the web user (usually 'nobody' on an Apache installation) > has access to the $ORA_HOME/bin directory and permissions to execute the > binaries within. Also, be sure that ORA_HOME and ORACLE_SID

RE: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread Brian S. Dunworth
Hi Phil, Make sure that the web user (usually 'nobody' on an Apache installation) has access to the $ORA_HOME/bin directory and permissions to execute the binaries within. Also, be sure that ORA_HOME and ORACLE_SID are set in the 'nobody' user environment... - Brian --

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread phil
On Mon, Jul 02, 2001 at 10:53:55AM -0400, Anthony Carlos wrote: > Phil, > > Perhaps I'm being nit-picky, but shouldn't it be OCILogon("$user", > "$PASSWORD", "$connect_string"); ? I have tried both $user="realuser"; $password="actualpassword"; $dbname="oraclename" ocilogon($user,$password,$dbn

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-02 Thread Anthony Carlos
Phil, Perhaps I'm being nit-picky, but shouldn't it be OCILogon("$user", "$PASSWORD", "$connect_string"); ? Anthony > From: [EMAIL PROTECTED] > Date: Sat, 30 Jun 2001 09:39:11 -0700 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] problems connecting to remote oracle database > > Hi folks, > > I'm

Re: [PHP-DB] problems connecting to remote oracle database

2001-07-01 Thread Rouvas Stathis
>From Oracle manual : ORA-01017: invalid username/password; logon denied Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered togeth