Re: TADOConnection error - connection string

On my Win2000 partition, after uninstalled VS 2005 and reinstall SQL Server
2000, then install MDAC 2.8 SP1, now I can create connection string in
Delphi.

However, on WinXP, I still have VS 2005. I installed MDAC 2.7 but the still
got the same error.
May be I need to uninstall VS 2005 and then reinstalled MDAC 2.7.

"Alan T" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:44a50117@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Is MDAC required on client for Windows app on shared drive?
    ... I have a Windows .NET 1.1 application that accesses data from a SQL Server ... our clients are installing the .NET Framework 1.1 ... one of the prerequisites for our installation is MDAC 2.7 SP1 since ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Visual studio denying access to database in Server Explorer
    ... if re-installing MDAC can resolve this issue. ... installing MDAC 2.8 does no harm to your machine. ... connecting to a remote server or a local database server? ...
    (microsoft.public.dotnet.general)
  • Re: Getting strange MDAC Message
    ... is there a way to forcibly reinstall MDAC? ... > ODBC providers, and those providers link with the old MDAC. ... because installing MDAC should give you new providers. ... >> Robert W. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Visual studio denying access to database in Server Explorer
    ... I am connecting to a local database server. ... I am running under service pack 2 so I will not be reinstalling mdac 2.8. ... installing MDAC 2.8 does no harm to your machine. ...
    (microsoft.public.dotnet.general)
  • Re: MDAC
    ... Without knowing too many details you could try installing the latest version ... MDAC you'll see links to the different versions there. ... > updatimg Microsoft data Access Components 2.5 on your ...
    (microsoft.public.windowsxp.newusers)