ASP connection to Oracle database

[MARELUAD]

Hello
I get next error with a ASP page

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the wyc09 home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.


I have instal Oracle 9I and Oracle client and networking components
But it don't work

mareluad

 

[tonylnng]

What is the provider you use in connection string? Are you using ADO?

Please try following connection string, it works on my project but Oracle 8i

Provider=OraOLEDB.Oracle.1;Password=yourpwrd;Persist Security Info=True;User ID=login;Data Source=[sia or service name]

Good Luck!

Tony

 

[MARELUAD]

Thanks for your answer.
I have solved the problem with this Oracle9I database.
The user must have the authorisation for ORACLE_HOME
Oracle_home = like C:\Oracle
Look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES
for the directory.
Select this folder and look in properties > security

Ad