Re: TADOConnection error - connection string

I re-installed SQL Server 2000, still got the same problem.


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




.

Relevant Pages

  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: TADOConnection error - connection string
    ... I tried to build connection string of TADOConnection component by using the ... server name by clicking the down arrow, ... Error enumerating data servers. ... My guess is you have a corrupt MDAC installation ...
    (borland.public.delphi.database.ado)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: vb6 app no longer connects to Access DB on Term Server 2003
    ... we recently upgraded the Terminal Server from the 2000 version to ... we have tried simplifying the connection string by removing the ... Microsoft ActiveX Data Objects 2.8 Library ... We even tried it on Windows Server 2003 ...
    (microsoft.public.data.oledb)