Php -Oracle 8i connection

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Php -Oracle 8i connection

Post by devork »

I have worked on mysql with php and want to make connection of php with oracle 8 i
my oracle and php ,apache are on windows machine
please guide me how to load all the extensions for that
error call to undefined function OCILogin.....
.....
User avatar
trollll
Forum Contributor
Posts: 181
Joined: Tue Jun 10, 2003 11:56 pm
Location: Round Rock, TX
Contact:

Post by trollll »

Started off trying to get Oracle functions to communicate with it, but ended up just using ODBC instead. Got too many unexplained errors using Oracle functions.
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

what type of unexplained errors
the only thing that i have to do with oracle 8i db is to query and show results in (php) no insertion ,no updates ....
just need that help about that ....where to get that oracle 8i dll extension
i have used the oracle and ora8i .dll extension in php.ini files
php_oracle.dll is available in my extension dir ...
i have to use the oracle directly .....
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post by hedge »

You need to install the Oracle client... the php_oci8.dll is dependent on that.

Once you can connect with sqlplus (part of the oracle client install) then you are usually on your way.

The only other issue I have ran into is that it can't seem to find my tnsnames.ora so I just put the entire connect string in the oci_connect
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

I have solved it and got some result through
ora_login("user@TSN","PAsswd"); oracle functions
but trying to do with OCI oracle 8i functions ....
and also trying to do with other methods....


where from i can get this php_oci8.dll extension [download] ?
Post Reply