OraOLEDB.Oracle Provider not found

[Extinct]

Hi,

I am trying to connect to an oracle database from an ASP page using an ADO connection.

It's a trusted connection so I don't have a Userid and password.

When I try to use OraOLEDB.Oracle (which as far as I found is the only way to connect with OS authentication) as provider I get the eror that the Provider can not be found.

1. Does the OraOLEDB.Oracle provider have to be insalled on the server?

2. Is there another way to connect through server authentication?

 

[vbkris]

>>Does the OraOLEDB.Oracle provider have to be insalled on the server?
yes.

>>Is there another way to connect through server authentication?
Not that i know of.

Known is handfull, Unknown is worldfull

 

[Extinct]

How does the provider have to be installed? Where can the installation files be found?

 

[Genimuse]

Though it's been several years since I did it, back then you installation files came with the Oracle installation disks. It has to be installed on the server containing the database, not the web server (IIRC).

 

[vbkris]

>>It has to be installed on the server containing the database, not the web server

even the drivers???

Known is handfull, Unknown is worldfull

 

[Genimuse]

That's what I recall, as on the local machine you're just using oledb (which it already knows how to do) -- seems like the provider is just doing translations on the database side.

But like I said, it's been several years and my memory could easily be faulty.