Re: ODBC connection to Oracle Rdb database

Try using a direct ODBC connection: $con = odbc_connect( "DSN={Mozaic - Live};UID=xxxx;PWD=yyyy;", "", "" ) or die; -- bob On Mon, 19 May 2003, PHodd (Peter) wrote: > HI all, > > Hope someone can help with an inability to connect via ODBC to an Oracle Rdb > database. Here is my code: > > $MozaicUser ="xxxxxxxx"; > $MozaicPassword ="yyyyyyyy"; > $conMozaic=odbc_connect("Mozaic - Live", $MozaicUser, $MozaicPassword, "") > or die("<p class='error'>Aborting after Mozaic connection failure - see > your IS support person.</p>"); > > Here is the error messages I get: > Warning: SQL error: [Oracle][ODBC][Rdb]%SQLSRV-F-GETACCINF, Oracle > SQL/Services authorization failed, SQL state S1000 in SQLConnect in > c:\www\prh\Includes\OpenMozaicDBConnection.php on line 4 > Aborting after Mozaic connection failure - see your IS support person. > I am sure the user name and password are correct, as they are used to make a > connection via vbscript and .asp in an IIS environment. > > Thanks all, > > Peter Hodd > > ###################################################################### > Disclaimer: > > This e-mail message and any attachments is privileged and confidential. > It may contain information that is subject to statutory restrictions on > its use. > > If you are not the intended recipient, you must not peruse, use, pass > on or copy this message or its attachments. If you have received this > message in error, please advise us by return e-mail, and delete the > message and attachments from your system. > > This e-mail has been scanned and cleared by MailMarshal > www.marshalsoftware.com > ###################################################################### > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >