Hi,
I'm desperate...
I've been installed Oracle Client. 9.1i in some computers and 9.2i in
others. The installation was sucefull, because, I can use SQL Plus,
without problems...
Now I'm trying to connect, PHP with Oracle, and I'm experimented to
diferents problems:
1) When I start PHP, I get the error message: 'Unable to load dynamic
library c:\php\extensio ns\php_oci8.dll '
.. I'm quite sure that this file exist!!. More than this, I already use
php_socket.dll, and this library is loaded ok.
.. I've been already check PATH, and "c:\oracle\ora9 x\bin" is there.
.. I tried to copy "php_oci8.d ll" and "oci8.dll" to "system32" folder but
doesn't work.
What I'm missing????
2) In just one machine working with Oracle 9.2i client, I can load
php_oci8.dll (i get this installing an uninstalling php, iis, and oracle
client too many times, so I don't know why it's working...). But, (there is
always a but...), when I try to connect, I get the following error:
"Warning: ocilogon(): _oci_open_serve r: ès":
.. Enviroment variables like "ORACLE_SID ", "ORACLE_HOM E" "TNS_ADMIN"
"LD_LIBRARY_PAT H" are OK!
.. "tsnames.or a" is ok to (I know that because I can use SQLPlus, and tnsping
is fine)
Again: Wha't I'm missing???
I'm using PHP version 4.x (I already tried 4.0, 4.1, 4.2 and 4.3.4, and
always get the same problem), IIS 4.5, and Windows XP Pro.
Thanks a lot!! 1 4195
On Thu, 20 Nov 2003 12:27:44 -0300, "Gustavo Oliveira"
<lg************ ****@matrix.inf .br> wrote: I've been installed Oracle Client. 9.1i in some computers and 9.2i in others. The installation was sucefull, because, I can use SQL Plus, without problems...
Now I'm trying to connect, PHP with Oracle, and I'm experimented to diferents problems:
1) When I start PHP, I get the error message: 'Unable to load dynamic library c:\php\extensio ns\php_oci8.dll ' . I'm quite sure that this file exist!!. More than this, I already use php_socket.dll , and this library is loaded ok.
That error can mean a bit more than it says; e.g. one of the libraries that
library depends on can't be loaded.
. I've been already check PATH, and "c:\oracle\ora9 x\bin" is there.
OK... but is it there in the environment the web server sees? This can be
different to your user's environment.
. I tried to copy "php_oci8.d ll" and "oci8.dll" to "system32" folder but doesn't work.
Don't do that. Remove them from system32 else you'll get into a worse mess.
Besides, it's oci.dll on Windows, not oci8.dll.
What I'm missing????
The usual things are:
(a) Environment for the webserver different from that of your user, so it works
for you, but not for your webserver.
(b) Oracle 9i installs the Oracle home with tighter permissions than it did in
8i, so make sure your webserver user has at least read and execute permissions
on the Oracle home directories and files.
As a test, you could alter the service for your webserver to log on as your
user, rather than the system user it's probably set to. If this works, then
it's one of the issues above.
2) In just one machine working with Oracle 9.2i client, I can load php_oci8.dll (i get this installing an uninstalling php, iis, and oracle client too many times, so I don't know why it's working...). But, (there is always a but...), when I try to connect, I get the following error: "Warning: ocilogon(): _oci_open_serve r: è
s":
Is that what appears? Corrupted characters like that? Looks bad.
What sort of client install did you do? Did it install the OCI libraries? I
can't remember off the top of my head what gets installed in a client install
since I usually do a Custom install to pick and choose the bits I want.
. Enviroment variables like "ORACLE_SID ", "ORACLE_HOM E" "TNS_ADMIN" "LD_LIBRARY_PA TH" are OK!
LD_LIBRARY_PATH doesn't apply to Windows; it just uses PATH for both libraries
and executables.
. "tsnames.or a" is ok to (I know that because I can use SQLPlus, and tnsping is fine)
--
Andy Hassall (an**@andyh.co. uk) icq(5747695) ( http://www.andyh.co.uk)
Space: disk usage analysis tool ( http://www.andyhsoftware.co.uk/space) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Patricia |
last post by:
I am a new Oracle user. I am trying to install Oracle 9i Personal
Edition on Windows ME; however, I am getting the following error
during the installation:
Oracle Database Configuration Assistant failed during install. Error
message:
java.lang.NoClassDefFoundError:
com/inprise/vbroker/CORBA/ObjectException in thread "main"
at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:437)
at...
|
by: Nick Palmer |
last post by:
Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two
DB2 databases and I need to get access to the tables in one from the other.
In Oracle I would just create a DB Link between the two instances. Is such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
by: Mark A |
last post by:
Here is Mark Townsend's (Oracle Product Manager) explanation and
justification for posting in the DB2 newsgroup, as posted on the Oracle
newsgroup, and my response:
"Mark Townsend" <markbtownsend@comcast.net> wrote in message
>
> By an large you will find that they
> all fall into 1 of 3 categorires.
>
> 1) Explaining how Oracle does something when somebody asks how to do the
|
by: Budd |
last post by:
I don't know how to connect to oracle database by asp.net
Anyone have any simple or step for me to connect??
i have no idea.... i have search from google and get the code
But it seen i have miss some step ....
My case is....school have provided the oracle for me to connect
so i need to install oracle client for my pc??
|
by: Medhatithi |
last post by:
Hi,
I am facing a strange problem with decode function in oracle. My table name is status_hist. Below is the query I am hitting on this table:
select max(decode(voided_flag,'Y',null,decode(status_hist.status,'WD',status_date)))
from status_hist
where sk_seq=6574
The result returned is '29-SEP-05'
However, I checked out the table status_hist to see that for sk_seq=6574 and voided_flag not equals to 'Y' and status='WD', the maximum...
| |
by: arunbalait |
last post by:
Hi all
Somebody plz help me.. How to store/retrieve images from the oracle8i table.
I tried using the article BLOB in this forum.. It works for SQLServer, But I want to know how to implement in Oracle. I tried that article, am getting error that Object or Block variable not set.
CN.Open "Provider=MSDAORA.1;Password=manager;User ID=system;Persist Security Info=True"
The above is the connection string I have given.
My table name is...
|
by: ramorac |
last post by:
Hi..
My requirement is to populate the fields in the front end screen(application screen) points weightage and rating when a particular answer is chosen from the combobox in front end.
For illustration:
I m using a cursor to get the fields from a table say.,Points and Weightage which in turn is used in a formula to calculate Rating.I used a function for this Rating.With cursor i fetch the point and weightage.. and a function for the...
|
by: yashwanth |
last post by:
Hi,
I am new to oracle and i wanted to use oracle as data base for my java project,i need to use files for saving data how can i use it...?
|
by: ravi |
last post by:
hi friends,
The below given query is work on oracle.Help me out write same query
on sqlserve i want the same resule.
select * from (select trunc(sysdate) + level from dual
2 connect by level <= 10);
TRUNC(SYS
---------
28-OCT-06
29-OCT-06
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |