Re: TADOConnection error - connection string

I just wonder I looked at the SQL Server Enterprise Manager, the instance I
got is Local, but not my PC name.

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:2i66a2dtqvjoion8vci0bg2896nm9h78s8@xxxxxxxxxx

That is possible. You are getting into a problem that is really a
Microsoft
support issue.
However I would first suggest you install the latest version of MDAC like
I
first suggested.

You might also just type in the name of the server you want to use rather
than
using the Expert to find it.


Will it because I installed the SQL Server 2005 Express before installing
the SQLServer 2000 ?

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:1lh3a2p7807n16oaruev4d13mifqad6j9a@xxxxxxxxxx

I installed SQLServer 2000 Enterprise.
I tried to build connection string of TADOConnection component by using
the
wizard.
After selecting the provider, click Next to the Connection tab, select
the
server name by clicking the down arrow, I got the error:
Error enumerating data servers. Enumerator reports 'Unspecified error'

My guess is you have a corrupt MDAC installation
Try downloading the most recent version of MDAC and installing it.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • RE: SQL 2000 & Null Values...
    ... > reinstalled the server we skipped putting SP3 in place. ... during the install of SP3a I had a problem on the MDAC piece of the ... How do I tell if the current MDAC 2.71 is in place? ... is there any suggested code that we should put into place that will ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Updates KB924667, 927779, 923723
    ... Server W2K SP4 was running MDAC 2.80. ... The other server is running MDAC 2.53 SP3. ... attempting to install Security Update for Microsoft Data Access Components ... Thinking about upgrading to newer version of MDAC ...
    (microsoft.public.windowsupdate)
  • Re: Errors after upgrade
    ... I tried the MDAC 2.8 install, ... >This is a known issue with some installations of Windows ... >Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: TADOConnection error - connection string
    ... If I installed the MAC myself, what would happen if reinstall SQL Server ... Will that replaced by SQL Server 2000's MDAC? ... However I would first suggest you install the latest version of MDAC like ...
    (borland.public.delphi.database.ado)
  • Re: TADOConnection error - connection string
    ... However I would first suggest you install the latest version of MDAC like I ... You might also just type in the name of the server you want to use rather than ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)