Re: Can't open tables in Enterprise Manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/20/04 

Date: Sun, 20 Jun 2004 09:45:56 +0100

Hi

You may want to try checking out MDAC with the component checker and
re-install if necessary.

http://www.microsoft.com/downloads/results.aspx?productID=B7ADDC23-DEC1-4C5F-8479-EAD9245A8D61&freetext=&DisplayLang=en

John

"MCSD Student" <anonymous@discussions.microsoft.com> wrote in message
news:1e84301c4568d$84df2310$a601280a@phx.gbl...
> I have SQL Server 2000 Developer Edition and Windows XP
> Professional O/S. I installed SQL Server 2000 as the
> default server, a typical installation, Local system
> account, with Windows authentication.
>
> The problem is that when I try to open any table in
> Enterprise Manager, I get a "catastrophic failure" (OBDC
> error). However, I have no problem opening a table in
> Query Analyzer. Anybody have any ideas?
>
> I also had a problem trying to import data from an Access
> database table into a SQL Server 2000 database table
> using DTS Import Wizard. I have a feeling that the two
> problems are related.
>
> Any help will be greatly appreciated, thanks!

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • RE: Executing a DTS package from a Web application.
    ... >> I’ve been only able to find examples of Windows and VB applications. ... >> to a SQL Server database table. ... The SQL Server database is not local. ... the DTS package specifies the full UNC file name. ...
    (microsoft.public.sqlserver.dts)