| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sys as sysdba with password through ODBC
Craig,
the correct syntax is
sys/password_at_connectstring 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: thomas.mercadante_at_labor.state.ny.us; ORACLE-L_at_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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: thomas.mercadante_at_labor.state.ny.us 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 - 10:14:25 CST
 |
 |