Try this:
CAUSE
This error occurs because a dynamic-link library (DLL) that is required by
the Microsoft Data Access Components is not registered.
RESOLUTION
NOTE: This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as
an example. Because the unregistered DLL may vary based on the OLE DB
Provider that you are using, modify step 2 accordingly.
To resolve this problem, reregister the faulty DLL as follows: 1. At a
command prompt, change to the C:\Program Files\Common Files\System\Ole DB
folder.
2. At a command prompt, type the following command:
regsvr32 sqloledb.dll
3. You should receive confirmation that the DLL is registered successfully.
For more information you can take a look in this link :
http://support.microsoft.com/default...b;en-us;278604
Thanks,
Elena Arzac
--------------------
Content-Class: urn:content-classes:message
From: "TOM" <tb***@yahoo.com>
Sender: "TOM" <tb***@yahoo.com>
Subject: Connecting to SQL with VB.NET
Date: Wed, 12 Jan 2005 11:56:36 -0800
Lines: 15
Message-ID: <01****************************@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcT44NKslff+1gX1QyGWK8yp27EP3g==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.languages.vb
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.languages.vb:253415
NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
X-Tomcat-NG: microsoft.public.dotnet.languages.vb
Hello, I am having problems with the server explorer
making a connection to the SQL server. I can see the
instances that i want to connect to but when i try this
error comes up PROVIDER CANNOT BE FOUND. IT MAY NOT BE
PROPERLY INSTALLLED.
I am programming on XP w\SP2 installed, I have MDAC 2.8
installed, i have SQL Client tools install.
When i installed VB on the server it worked fine. So I
think i am missing a piece, that will let VB talk to the
Server.
I could use any help or suggestions?
Tom