Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ODBC problem: How to setup if my oracle client and oracle server are put together?

Re: ODBC problem: How to setup if my oracle client and oracle server are put together?

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Thu, 22 Mar 2001 22:40:33 GMT
Message-ID: <3aba7cfe.58518475@news.online.de>

PHP can talk to Oracle via ODBC, and from your first posting, I assume you use PHP with an ODBC driver. So in detail : 1. On the server you set up ODBC as you did on the client, but leave the "server" field blank. Depending on the ODBC driver (we use MS ODBC for Oracle) you only fill in the ODBC Name, Login-ID and PW if it asks for it.
2. Check if ODBC works by using something like ODBC Test (comes with Oracle ODBC driver/client). You just need to get the connect to work. 3. Just set up the ODBC Name in PHP and try to connect with UID,PW (do not use the DSN method for now).
4. If it does not work, do what I said before, check your NET8 Listener configuration on the server.

Hth  

On Thu, 22 Mar 2001 17:42:26 +0800, "¨þ¨þ" <jasondro_at_ms.chttl.com.tw> wrote:

>>Oracle Client & Oracle Server together ? You mean you moved PHP and
>>Apache onto the NT/2000 server ?
>
>Yes!
>
>>Then you need to change the net8 configuration from something like TCP/IP
 to BEQUETH or change the
>>TCP/IP adresse to localhost. It should work.
>
>
>I tried them, but it didn't work. The same error message (can't resolve
>service name) appears.
>If anyone ever tried this case and successed, would you please share your
>experience and tell me the steps
>in detail? Anyway, thank you for your response.
>
>Jason
>
>

EMail: knijff_at_bigfoot.com Received on Thu Mar 22 2001 - 16:40:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US