RE: sys as sysdba with password through ODBC
Craig, did you try: $username = SYS $password = syspassword AS SYSDBA $dsn=dsn Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L 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). -- 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).
RE: sys as sysdba with password through ODBC
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: 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).
RE: sys as sysdba with password through ODBC
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).
RE: sys as sysdba with password through ODBC
Oh yes From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sys as sysdba with password through ODBC Date: Fri, 19 Dec 2003 07:39:26 -0800 Craig, did you try: $username = SYS $password = syspassword AS SYSDBA $dsn=dsn Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L 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). -- 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). _ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband -- 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).