ODBC connection to Oracle Rdb database

ODBC connection to Oracle Rdb database

am 19.05.2003 06:28:03 von phodd

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("

Aborting after Mozaic connection failure - see
your IS support person.

");

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

Re: ODBC connection to Oracle Rdb database

am 19.05.2003 18:29:13 von Robert Twitty

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("

Aborting after Mozaic connection failure - see
> your IS support person.

");
>
> 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