From: "Sylvie L'Heureux" Newsgroups: cern.oracle.cde,comp.database.oracle,comp.databases.oracle,comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Provider for VB? SP% and Oracle version 8.1.5.0.2 Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Sun, 3 Mar 2002 10:02:33 -0500 NNTP-Posting-Host: 65.93.165.149 X-Complaints-To: abuse@sympatico.ca X-Trace: news20.bellglobal.com 1015167574 65.93.165.149 (Sun, 03 Mar 2002 09:59:34 EST) NNTP-Posting-Date: Sun, 03 Mar 2002 09:59:34 EST Organization: Bell Sympatico Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!newshub.northeast.verio.net!verio!netnews.com!xfer02.netnews.com!newsin.iconnet.net!feed.tor.primus.ca!feed.nntp.primus.ca!newsfeed.torontointernetxchange.net!radon.golden.net!news1.tor.metronet.ca!webster!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail Xref: easynews cern.oracle.cde:625 comp.database.oracle:8022 comp.databases.oracle:13730 comp.databases.oracle.marketplace:117870 comp.databases.oracle.misc:77563 comp.databases.oracle.server:137303 comp.databases.oracle.tools:49294 X-Received-Date: Sun, 03 Mar 2002 07:59:29 MST (news.easynews.com) Hello I get the following message when I'm trying to access Oracle 8.1.5.0.2 with VB6 SP5 : " Oracle client and networking components where 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. Microsoft OLEDB provider for Oracle.error no : -2147467259". Until now, I was using successfully the ADODB.CONNECTION string with "provider=msdaora;" What is the problem ? Is it the SP5 that I use. Before I was using SP3/Sp4. Thank you Sylvie L'Heureux