To Bob (Robert Twitty): Thanks for the reply below, and the reply suggesting using the "DSN=x;UID=y;PWD=z" construct for the connection string. Unfortunately ODBTP is not a solution initially, as I am running Apache/PHP on a Windows 2000 platform, and I understand that ODBTP runs only on Linux. I will in time transfer to running Apache/PHP on a Linux platform, but I am not ready for the leap just yet (confessions of a Windows person: I am heading into the open source world cautiously!). I also tried the "DSN=x;UID=y;PWD=z" construct but this just returns this error... Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\www\prh\Includes\OpenMozaicDBConnection.php on line 4 ... which looks like the construct is not supported. If anyone has any other ideas, I would be pleased to hear them. I am currently working on trying to examine the various log files on the client and server platforms, to see if they give any clues, but I would not expect the logs to reveal exactly what user and password strings are being passed. Regards, Peter Hodd. -----Original Message----- From: Robert Twitty [mailto:rtwitty@neutron.ushmm.org] Sent: Tuesday, 20 May 2003 5:10 a.m. To: PHodd (Peter) Subject: Re: ODBC connection to Oracle Rdb database Hi Peter If you want to try an alternative method for connecting to ODBC, I can provide you the URL to download it. It is called ODBTP (Open Database Transport Protocol). ODBTP provides remote access to any ODBC driver residing on Windows NT, XP Pro or 2000 machine. It is faster, easier to use, and provides more support for ODBC than the odbc extension. It is also an open source solution. Even if you would prefer to use the odbc extension, you could try to see if you connect with odbtp as another sanity test. * 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 > > ###################################################################### 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
