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
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
