Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sys as sysdba with password through ODBC

RE: sys as sysdba with password through ODBC

From: Craig Richards <craigdba_at_hotmail.com>
Date: Fri, 19 Dec 2003 07:49:33 -0800
Message-ID: <F001.005DA70E.20031219074933@fatcity.com>


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" <thomas.mercadante_at_labor.state.ny.us>
>To: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>
>CC: "'craigdba_at_hotmail.com'" <craigdba_at_hotmail.com>
>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:craigdba_at_hotmail.com]
>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: craigdba_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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: Craig Richards
  INET: craigdba_at_hotmail.com

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: ListGuru_at_fatcity.com (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).
Received on Fri Dec 19 2003 - 09:49:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US