Re: problem with ORACLE, OLE-DB, ASP

I had this working with the oracle ole db driver but I installed the 8.1.6 client on my machine to do it.
When you use the MSDAORA, you are using the Microsoft OleDB driver, not Oracle's. You still need to have an Oracle client loaded. I had some problems getting this all straightened out when I had older oracle products that used SQL*Net V2 vs the newer products using Net8. Removing all the junk and installing the latest client and ole-db drivers worked fine. I think there was also an OCIW32.dll (or something like that) located in an incorrect directory (like \winnt\system32) instead of \%Oraroot%\bin

Good luck.

"Maru" <marucanc_at_tin.it> wrote in message news:8p7ovc$dda$1_at_fe1.cs.interbusiness.it...
> Hi everyone. I am new in programming.. I do need help!!!
> I have a problem connecting an Oracle db using ASP tecnology and OLE-DB.
> In my asp page I put:
>
> dbConn="Provider=MSDAORA.1;Data
> Source=source_name;Database=database_name;User
> ID=user_id;Password=password;"
> set rs = Server.CreateObject("ADODB.Recordset")
> rs.Open ......., dbConn
>
> This page will run on a server with windows 2000 and IIS 5.0.
> The connection doesn' work.
> Do I have to install something special on my server? somthing like an
 oracle
> client?
> Please! Help me :)
>
> Marusca
>
>
Received on Sat Sep 09 2000 - 12:13:06 CDT