From: "Eric Givler" Newsgroups: comp.databases.oracle.misc References: <8p7ovc$dda$1@fe1.cs.interbusiness.it> Subject: Re: problem with ORACLE, OLE-DB, ASP Lines: 36 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 Message-ID: Date: Sat, 09 Sep 2000 17:13:06 GMT NNTP-Posting-Host: 63.254.26.2 X-Complaints-To: abuse@flash.net X-Trace: news.flash.net 968519586 63.254.26.2 (Sat, 09 Sep 2000 12:13:06 CDT) NNTP-Posting-Date: Sat, 09 Sep 2000 12:13:06 CDT Organization: FlashNet Communications, http://www.flash.net 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" wrote in message news:8p7ovc$dda$1@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 > >