Re: 80004005 error with Oracle


"Darryl" <Darryl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD3D7B53-CEE3-4FFE-8115-1933C6F66944@xxxxxxxxxxxxxxxx
Ralph,

no joy with any of your suggestions. I had already checked permissions and
on all the files that I could see were relevant, the permissions were
identical.

The web site you referenced deals with SQL Server and Access, and I
couldn't
see anything relevant to the particular Oracle problem that we have. The
text
of the message is "Oracle error occurred, but error message could not be
retrieved from Oracle."

I have been working on Citrix 1 and 2 and ignoring 3 for the moment. On
both
servers, I can connect to the Oracle databases directly via sqlplus, which
tells me that all the Oracle database and networking is functioning
correctly. I have also found that the Citrix 2 VBA is not making the
connection to the listener on the database server, where both Citrix 1 and
sqlplus on Citrix 2 do connect. Somewhere between connection.open and the
Oracle host listener is where the problem occurs. I have also swapped from
ver 2.5 to 2.7 on the problem machine, and the situation is unchanged.

Another curious piece of the puzzle i have just found out, if you run
outside of debug mode and click on "End" when the error message comes up,
the
data is loaded anyway! I don't think it is a good idea though to get users
used to ignoring error messages.


"Ralph" wrote:


Darryl


I believe the technical definition of your problem is called "Chewing
on
the
wrong animal."

The ADO Error 80004005 has many specific causes but they are all
related
to
an inability to make a "Connection". If you have installed the correct
MDAC
for your platform then it is highly unlikely you are experiencing any
"backward compatibility" issues.

It is more likely you are experiencing a "permissions" problem either
in
accessing Oracle or in accessing the COM components. Stop worrying
about
MDAC and start looking at why your app can't "see" oracle.

hth
-ralph



Here is a website that provides a good summary of all the issues that
can
cause this error:
http://www.aspfaq.com/show.asp?id=2009

Also while the Error Code is the same - there are quite different Error
Descriptions. What is the one for your error?

Also I suggest you download and use Oracle's OLE DB provider for the
version
of Oracle you are using.

-ralph


I agree. Providing instructions to ignore error messages does usually
install much customer convidence. <g>

ADO is a data access library which works with an Oracle OLE DB provider to
access the Oracle database. The fact that sqlplus works only indicates that
Oracle is installed - not whether the ADO provider and Oracle are configured
correctly.

By "permissions" I was referring to the whole gambit of properties
associated with a particular "Profile" which includes not only ACLs, but
environ variables, registery entries, logical paths, etc.

The fact you can still receive data leads me to suspect some kind of
datatype issue (eg, the ToDate() fix mentioned in a link below.)

http://www.intranetjournal.com/ix/msg/39969.html
http://support.microsoft.com/kb/q264012/
http://www.bauerfoto.com/OracleConnectFix_EnvVariable.html

Oracle OLE DB providers:
http://www.oracle.com/technology/software/index.html

And now for the silly question - you did install the Oracle Client on the
Citrix 2/3 servers using /install mode, right?

-ralph





.

Relevant Pages

  • Re: Crystal XI troubles
    ... It turned out to be a permissions issue. ... was that I am using the OLE DB provider for Oracle. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Required permissions cannot be acquired?
    ... Changing the file permissions was one of the things I tried. ... >¤ I have forms authentication in SQL RS working like a charm. ... I am now trying to do some authentication against an Oracle ... >Any application that is using the Authenticated User privilege will not work. ...
    (microsoft.public.dotnet.security)
  • Re: Mounted volume, different permissions
    ... > some other stuff we were going to be installing, ... > Oracle software, and, using Veritas Volume manager, we created a 30GB ... > What exactly is going on between the permissions of the underlying mount ...
    (comp.sys.sun.admin)
  • Re: 80004005 error with Oracle
    ... on all the files that I could see were relevant, the permissions were ... see anything relevant to the particular Oracle problem that we have. ... I have also found that the Citrix 2 VBA is not making the ... outside of debug mode and click on "End" when the error message comes up, ...
    (microsoft.public.vb.database.ado)
  • 10gR2 tru64 permissions
    ... I have some problems on a TRU64 box running a 10gR2 database. ... found some notes from oracle saying the owner group of Oracle_home ... Seems there are a lot of permissions problems on this box. ... cluster if I restart the computer an another node will restart the ...
    (comp.databases.oracle.server)