Oracle 8i Connection Probs

Anon

Hi,

I'm having major problems connecting remotely to Oracle via ODBC. I've read that some environment values should be set before you run the connect - can anyone tell me what these commands are?

For those wondering why I'm using ODBC, I've tried using the oci8 and oracle PHP extensions but I keep getting an alert box popup saying that PHP cannot find the relevant dll file.

However I have my extensions_dir variable in php.ini set correctly, because other dlls in the same extensions directory (Eg: SQL Server extension) are working with no problems!

If anyone can help me with either of these problems, I'd appreciate it 🙂

Daniel

Anon

Hi again,

Seems I've solved my problem, and even have the Oracle and Oracle 8 dll's working now 🙂

Although they only seem to work with Apache - when I run them using IIS 5.0 (I'm using Win2000) I get the error "Fatal error: Call to undefined function: ocilogon()"

Strangely though I'm not getting the popup windows about missing dll's, so I'm confused! 🙂

Since I need to get this running under IIS instead of Apache, does anyone have an idea as to how to get the Oracle commands running with IIS? I don't want to go back to the ODBC drivers 😉

Daniel

gfvarone

First of all sorry 4 my english.

This prob is typical when u don't have Oracle client installed on the machine that hosted your web server software...
So, the doc says this too, verify if u have properly installed an Oracle Client on your web server!

After this u can access to your Oracle server without probs.

Bye
GFranco Varone
Novara Lumellogno, IT

toma42

As for IIS, clicking the stop then start button isn't enough if you've made changes to the php.ini.

From start:run type iisreset
to restart the web server and reload php.ini values.