Hello All,
I have reviewed various posts in regard to Oracle and PHP.
I am running Apache 2.0.59, on Windows XP, with PHP 5.2.
I would like to connect using PHP to a remote oracle db (ver. 7)
I have uncommented out the php_oci8.dll and the older php_oracle.dll
in the php.ini file
the ini file resides in c:\php\php.ini
The oracle info page ( http://www.oracle.com/technology/pub/notes/
technote_php_instant.html) outlines the steps for this.
I have stopped and restarted apache, no luck, I do not see support for
oracle on the info page.
I do see mysql, etc.
I have the path set to the location for the oracle dlls, etc.
I can connect to the db using MS Access and the file dsn.
any idea what I am missing?
eholz1 7 21896
eholz1 wrote:
I have uncommented out the php_oci8.dll and the older php_oracle.dll
in the php.ini file
the ini file resides in c:\php\php.ini
Let's make sure, just for the sake of it...
Put a call in any one of your pages to phpinfo(); check that the.ini file
loaded matches the oen you modified, and that there is some information
about the oci8 module being loaded.
--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
Más vale ser cobarde un minuto, que muerto todo el resto de la vida.
On Jun 19, 2:34 pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
escomposlinux.-.punto.-.orgwrote:
eholz1 wrote:
I have uncommented out the php_oci8.dll and the older php_oracle.dll
in the php.ini file
the ini file resides in c:\php\php.ini
Let's make sure, just for the sake of it...
Put a call in any one of your pages to phpinfo(); check that the.ini file
loaded matches the oen you modified, and that there is some information
about the oci8 module being loaded.
--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
Más vale ser cobarde un minuto, que muerto todo el resto de la vida.
Ha, I did think of that. I went to my php.ini file, and added a
comment char (;) to the mysqli extension line to see if it WOULD NOT
SHOW in my phpinfo page if I had a comment in front of the line. It
worked, put semi-colon in front of line, and no mysqli info on my
phpinfo page. if I remove the comment from that line, the mysqli
extension info appears.
So, for some unknown reason, the oci8 extension, commented or not does
not show. I do have a PATH statement that has the path to the oracle
dlls (for Oracle instantclient), and the php_oci8.dll file does exist
in my c:\php\ext directory. I guess I am out of luck.
Muchas Gracias
eholz1
eholz1 wrote:
[...] and the php_oci8.dll file does exist
in my c:\php\ext directory. I guess I am out of luck.
Well, I'm not a windows kind of guy, so let me ask: from where did you
download both PHP and the oracle libraries?
Also, have you tried to put the full path to the oracle library in php.ini?
Any relevant messages in the Apache logs?
Cheers,
--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
Proudly running Debian Linux with 2.6.24-1-amd64 kernel, KDE 3.5.9, and PHP
5.2.6-1 generating this signature.
Uptime: 00:54:42 up 11 days, 8:42, 4 users, load average: 0.93, 0.91,
0.82
eholz1 wrote:
On Jun 19, 2:34 pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
escomposlinux.-.punto.-.orgwrote:
>eholz1 wrote:
>>I have uncommented out the php_oci8.dll and the older php_oracle.dll in the php.ini file the ini file resides in c:\php\php.ini
Let's make sure, just for the sake of it...
Put a call in any one of your pages to phpinfo(); check that the.ini file loaded matches the oen you modified, and that there is some information about the oci8 module being loaded.
-- ---------------------------------- Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
Más vale ser cobarde un minuto, que muerto todo el resto de la vida.
Ha, I did think of that. I went to my php.ini file, and added a
comment char (;) to the mysqli extension line to see if it WOULD NOT
SHOW in my phpinfo page if I had a comment in front of the line. It
worked, put semi-colon in front of line, and no mysqli info on my
phpinfo page. if I remove the comment from that line, the mysqli
extension info appears.
So, for some unknown reason, the oci8 extension, commented or not does
not show. I do have a PATH statement that has the path to the oracle
dlls (for Oracle instantclient), and the php_oci8.dll file does exist
in my c:\php\ext directory. I guess I am out of luck.
Muchas Gracias
eholz1
This is a typical symptom of not having the correct libraries loaded.
It could be your extension directory, or more likely, the oracle
libraries (or something they require) are not available.
Check your phpinfo() command. Exactly what does it show for
"Configuration File (php.ini) Path". Also, under the "Apache
Environment" section, verify the PATH value - and ensure your Oracle
libraries (and everything they require) are in the PATH.
Also ensure you have the latest Oracle libraries on your system.
Finally - are you loading PHP as a CGI or Apache module?
It's a bit tricky to set up sometimes, but it does work.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attglobal.net
==================
On Jun 19, 4:59 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
eholz1 wrote:
On Jun 19, 2:34 pm, Iván Sánchez Ortega <ivansanchez-...@rroba-
escomposlinux.-.punto.-.orgwrote:
eholz1 wrote: I have uncommented out the php_oci8.dll and the older php_oracle.dll in the php.ini file the ini file resides in c:\php\php.ini
Let's make sure, just for the sake of it...
Put a call in any one of your pages to phpinfo(); check that the.ini file
loaded matches the oen you modified, and that there is some information
about the oci8 module being loaded.
--
----------------------------------
Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org-
Más vale ser cobarde un minuto, que muerto todo el resto de la vida.
Ha, I did think of that. I went to my php.ini file, and added a
comment char (;) to the mysqli extension line to see if it WOULD NOT
SHOW in my phpinfo page if I had a comment in front of the line. It
worked, put semi-colon in front of line, and no mysqli info on my
phpinfo page. if I remove the comment from that line, the mysqli
extension info appears.
So, for some unknown reason, the oci8 extension, commented or not does
not show. I do have a PATH statement that has the path to the oracle
dlls (for Oracle instantclient), and the php_oci8.dll file does exist
in my c:\php\ext directory. I guess I am out of luck.
Muchas Gracias
eholz1
This is a typical symptom of not having the correct libraries loaded.
It could be your extension directory, or more likely, the oracle
libraries (or something they require) are not available.
Check your phpinfo() command. Exactly what does it show for
"Configuration File (php.ini) Path". Also, under the "Apache
Environment" section, verify the PATH value - and ensure your Oracle
libraries (and everything they require) are in the PATH.
Also ensure you have the latest Oracle libraries on your system.
Finally - are you loading PHP as a CGI or Apache module?
It's a bit tricky to set up sometimes, but it does work.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Hello again,
I will check the items that Jerry mentions - there is a lot to double
check.
I will get back to the group, if successful!
Thanks
eric
eholz1 wrote:
On Jun 19, 4:59 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
>eholz1 wrote:
>>On Jun 19, 2:34 pm, Iván Sánchez Ortega <ivansanchez-...@rroba- escomposlinux.-.punto.-.orgwrote: eholz1 wrote: I have uncommented out the php_oci8.dll and the older php_oracle.dll in the php.ini file the ini file resides in c:\php\php.ini Let's make sure, just for the sake of it... Put a call in any one of your pages to phpinfo(); check that the.ini file loaded matches the oen you modified, and that there is some information about the oci8 module being loaded. -- ---------------------------------- Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org- Más vale ser cobarde un minuto, que muerto todo el resto de la vida. Ha, I did think of that. I went to my php.ini file, and added a comment char (;) to the mysqli extension line to see if it WOULD NOT SHOW in my phpinfo page if I had a comment in front of the line. It worked, put semi-colon in front of line, and no mysqli info on my phpinfo page. if I remove the comment from that line, the mysqli extension info appears. So, for some unknown reason, the oci8 extension, commented or not does not show. I do have a PATH statement that has the path to the oracle dlls (for Oracle instantclient), and the php_oci8.dll file does exist in my c:\php\ext directory. I guess I am out of luck. Muchas Gracias eholz1
This is a typical symptom of not having the correct libraries loaded. It could be your extension directory, or more likely, the oracle libraries (or something they require) are not available.
Check your phpinfo() command. Exactly what does it show for "Configuration File (php.ini) Path". Also, under the "Apache Environment" section, verify the PATH value - and ensure your Oracle libraries (and everything they require) are in the PATH.
Also ensure you have the latest Oracle libraries on your system.
Finally - are you loading PHP as a CGI or Apache module?
It's a bit tricky to set up sometimes, but it does work.
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================
Hello again,
I will check the items that Jerry mentions - there is a lot to double
check.
I will get back to the group, if successful!
Thanks
eric
Come back if you're not successful, also - we'll try some other things! :-)
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attglobal.net
==================
On Jun 24, 1:07 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
eholz1 wrote:
On Jun 19, 4:59 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
eholz1 wrote: On Jun 19, 2:34 pm, Iván Sánchez Ortega <ivansanchez-...@rroba- escomposlinux.-.punto.-.orgwrote: eholz1 wrote: I have uncommented out the php_oci8.dll and the older php_oracle.dll in the php.ini file the ini file resides in c:\php\php.ini Let's make sure, just for the sake of it... Put a call in any one of your pages to phpinfo(); check that the.inifile loaded matches the oen you modified, and that there is some information about the oci8 module being loaded. -- ---------------------------------- Iván Sánchez Ortega -ivansanchez-algarroba-escomposlinux-punto-org- Más vale ser cobarde un minuto, que muerto todo el resto de la vida. Ha, I did think of that. I went to my php.ini file, and added a comment char (;) to the mysqli extension line to see if it WOULD NOT SHOW in my phpinfo page if I had a comment in front of the line. It worked, put semi-colon in front of line, and no mysqli info on my phpinfo page. if I remove the comment from that line, the mysqli extension info appears. So, for some unknown reason, the oci8 extension, commented or not does not show. I do have a PATH statement that has the path to the oracle dlls (for Oracle instantclient), and the php_oci8.dll file does exist in my c:\php\ext directory. I guess I am out of luck. Muchas Gracias eholz1
This is a typical symptom of not having the correct libraries loaded.
It could be your extension directory, or more likely, the oracle
libraries (or something they require) are not available.
Check your phpinfo() command. Exactly what does it show for
"Configuration File (php.ini) Path". Also, under the "Apache
Environment" section, verify the PATH value - and ensure your Oracle
libraries (and everything they require) are in the PATH.
Also ensure you have the latest Oracle libraries on your system.
Finally - are you loading PHP as a CGI or Apache module?
It's a bit tricky to set up sometimes, but it does work.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Hello again,
I will check the items that Jerry mentions - there is a lot to double
check.
I will get back to the group, if successful!
Thanks
eric
Come back if you're not successful, also - we'll try some other things! :-)
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Hello Again,
I got the oracle stuff to show up in the phpinfo() area. Here is what
I did:
First - I double checked the items in your (Jerry's) email. Made sure
I thought I had the correct settings, etc.
Went back to this page from Oracle: http://www.oracle.com/technology/pub...p_instant.html
Re-read (3 times) the section on windows install - me have PHP 5.2,
Apache loads it as a module (running Window XP SP2).
Made sure I had the dlls from the instant client. Then saw the note
in technote page,
add the instantclient path BEFORE ANY OTHER ORACLE PATH VAR.
I then modified my ENV vars (both PATH, and Path) with the path to the
Oracle dlls to put location before any others.
Rebooted the computer (!) - This put the PATH in the PHP info page,
and the "oci8" stuff showed up in the info page.
I have not tried to connect to the db yet....!:)
Thanks for the help,
eric This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Chad The Man |
last post by:
I have been developing some applications on suse 9 / apache 1.37 / php
4.3.4 / Oracle 9i / OCI8. We recently moved servers, apache works
fine, php works fine, oracle works fine... however, trying...
|
by: PIII450 |
last post by:
Hi all,
We had to switch to windows 2003 server with IIS and now i've got a
problem with the OCI8 :(( Big time!
I know php works. I have tested this.
I know the oracle\bin is in the path. I...
|
by: watayoune |
last post by:
Hi,
My apache (on win) crash when i start it, after i had oci8 extensions in
php.ini !
1. i had extension phph_oci8.dll in php.ini
2. i've got a php_oci8.dll in my php extensions dir
3. my...
|
by: Ben Fitzgerald |
last post by:
Hi
I'm having an irritating problem.
I've got php installed with the compile-time flag --oci8=$ORACLE_HOME.
I can make connections to the oracle db no problem. Updating, selecting etc.
is...
|
by: Mladen Gogala |
last post by:
The latest version of OCI8 1.2.1 doesn't work with LOB fields. There was
an open bug, but Tony2001 was his usual helpful self, so he removed the
bug and flatly denied its existence. I had to...
|
by: danish |
last post by:
I download the oci-1.2.2.tgz file and generated the oci8.so file. After
adding the
extension=oci8.so
in php.ini
I get the error
unable to load dynamic library /usr/lib/php4/oci8.so
|
by: ravinder1983 |
last post by:
Hi All,
I am new to this world of php. I tried getting oci8 work with php but to no avail. The error i recieve is "Warning: ocilogon() : OCIEnvNlsCreate() failed. There is something wrong with...
|
by: SmartPHP |
last post by:
Hello friends,
I'm using PHP with apache...my problem is i'm not able to load OCI8.dll....when i'm trying to make connection to database i'm not able to connect and it's not showing any error...my...
|
by: kovidranjan |
last post by:
Dear Sir,
I have installed oracle 11.1.0.6 on windows 2003 sp2 and sqlplus etc everything is running fine.I have iis6 with cgi
I have installed php 5.3.1 non thread safe and has done everything...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |