Re: HELP Please! Provider Cannot Be Found, It may not be properly inst
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 04 Oct 2005 20:17:26 -0600
I've seen similar things before - usually from uninstalling
or reinstalling other apps that cause a dlls to become
unregistered. Generally, reinstalling MDAC will fix it but
not always. Sometime you have to manually unregister and
register the OLE DB providers using regsvr32.
The providers are by default located in:
C:\Program Files\Common Files\System\Ole DB
You'd want to start with sqloledb.dll and msdasql.dll.
You probably should run component checker first to make sure
there isn't something else messed up with your mdac
installation. You can download component checker from:
http://msdn.microsoft.com/data/mdac/downloads/default.aspx
-Sue
On Tue, 4 Oct 2005 10:20:06 -0700, "Brad Ashforth"
<banospam@xxxxxxxxxxxxx> wrote:
>On an XP PRo SP2 machine connecting to both a local and/or network SQL Server
>2000 machine (unknown SP at this time), only ONE machine is getting this
>error "Provider cannot be found. It may not be properly installed.". While
>the answer looks simple (reinstall), this does not solve the problem. To make
>matters even more interesting, this user WAS successfully using his SQL
>Enterprise Manager and SQL applications (some are custom "front ends" using
>MDAC/ADO) and suddenly this error occurred. The user has not proactively
>installed any new software, but of course any background update may have
>occurred. The error manifests itself when trying to READ records. Using
>Enterprise Mgr, the user CAN access the databases and CAN access the db
>objects in Design view, but cannot view records (i.e tables/views). Even
>stranger, if SQL Query Analyzer is used, the user CAN read records from the
>same tables that can't read records from Enterprise Manager. Now for even
>wierder ... the user had this problem last month and when we could not solve
>it the user got a new notebook and reinstalled everything. All was fine for
>several weeks only to have it happen again, now, on a new notebook! The
>machine has active firewall, antivirus and antispyware.
>
>Reinstallation of SQL, or the client utilities, or the custom front end apps
>does not solve the problem, and so far it has not happened on any other pc on
>the network.
>
>Suggestions are appreciated! :)
>
>Thank you,
>
>Brad Ashforth
.
- Follow-Ups:
- Re: HELP Please! Provider Cannot Be Found, It may not be properly
- From: Brad Ashforth
- Re: HELP Please! Provider Cannot Be Found, It may not be properly
- Prev by Date: Re: Driver
- Next by Date: Re: PHP and Navision C/ODBC
- Previous by thread: Re: Driver
- Next by thread: Re: HELP Please! Provider Cannot Be Found, It may not be properly
- Index(es):
Relevant Pages
|
