Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ODBC problem: How to setup if my oracle client and oracle server are put together?
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
![]() |
![]() |