Re: error ORA-12699

Try using $connect_string="ORCL"; Wayne sang wrote: > > I have read some doc. > $connect_string is set to equal from tnsnames.ora. > > $connect_string="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = > 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL)))"; > > I can connect my local oracle server before when using > OCILogon("system","manager"); > > But now , i cannot connect local oracle server!! > It is always said the ORA-12699 error! > > I donot know what is wrong. > > sang > > "Anthony Carlos" <anthony@digitalphenom.com> wrote in message > news:B75F483C.E61%anthony@digitalphenom.com... > > Sang, > > > > Since you're trying to connect from another computer to the Oracle server, > > you probably need to specify a connect string in the OCILogon command. > > > > OCILogon('system', 'manager', "$connect_string"); > > > > What's the value for $connect_string? It depends on how you've set-up your > > Oracle networking. If you can access your DB from that client machine with > > SQL*Plus, then you must be loging in via the following format: > > > > >sqlplus system/manager@<connect_string> > > > > Use the value of <connect_string> for $connect_string. It should be > defined > > in your tnsnames.ora file on your client, and have a corresponding entry > in > > your listern.ora file on your server. > > > > I suspect that your client machine is trying to access an Oracle database > on > > itself, because no connect string was specified. > > > > Lemme know if this helps, > > > > Anthony > > > > > From: "sang" <sang@technical-e.co.jp> > > > Date: Wed, 27 Jun 2001 18:59:31 +0900 > > > To: php-db@lists.php.net > > > Subject: [PHP-DB] error ORA-12699 > > > > > > I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer. > > > I want to access ORACLE server to another computer from web server. > > > It is ok to access ORACLE SERVER with PERL, but i cannot access using > PHP. > > > > > > The first error is ora-12514 , but i change, change and change, now it