Craig, the correct syntax is
sys/[EMAIL PROTECTED] as sysdba. So you might try: >$username = "SYS" >$password = "syspassword" >$dsn="dsn AS SYSDBA" PS - can you tell I'm guessing? :) Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Friday, December 19, 2003 10:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] I have done that it works through SQLPLUS but through my page i can connect to the dsn but now i get Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE , SQL state S1000 in SQLExecDirect >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: sys as sysdba with password through ODBC >Date: Fri, 19 Dec 2003 10:36:39 -0500 > >Craig, > >did you try: > >$username = "SYS" >$password = "syspassword AS SYSDBA" >$dsn="dsn" > > >Tom Mercadante >Oracle Certified Professional > > >-----Original Message----- >From: Craig Richards [mailto:[EMAIL PROTECTED] >Sent: Friday, December 19, 2003 10:29 AM >To: Multiple recipients of list ORACLE-L >Subject: sys as sysdba with password through ODBC > > >Can this be done a want to connect through ODBC, for a php web page > >Can this be done if so how do I declare the username, password and db >string > >Currently i do > >$username = "name" >$password = "password" >$dsn="dsn" > >Any help appreciated > >Cheers > >_________________________________________________________________ >Express yourself with cool emoticons - download MSN Messenger today! >http://www.msn.co.uk/messenger > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Craig Richards > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
