Re: TADOConnection error - connection string

If I installed the MAC myself, what would happen if reinstall SQL Server
2000? Will that replaced by SQL Server 2000's MDAC ?

"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: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... The DSRestore Filter failed to connect to local SAM server. ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... Can I reinstall the files from another SBS2003 server I manage? ... On my install of SLQ2005, I told it to upgrade all instances. ... Installing SQL Server 2005 WorkGroup Edition in Windows Small Business ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Installed VS 2005 want to Manage SQL 2005 Server
    ... I Guess I didn't copy it to the Install Source on the Server. ... To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. ... The Following Components that you chose to install are already installed onthe machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: Any help here???
    ... > start looking for things that are non standard (like having MDAC installed). ... > Format your drive, do a new/clean install of XP, and go from there. ... >>> data provider is optimized for SQL Server. ... >>> I've never had any SQL Server connectivity problems since I've switch to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > Server, doesn't have the right to grant DB access to Domain Groups. ... I didn't know that an SQL Server login as ... > I did the install about a month ago as Domain Admin (default install - mixed ... > site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)