Re: Problems with ado

> My computer recently crashed. After finally recovering most functionality,
I
> discovered that 1) the ado control in VB 6 no longer worked (Couldn't
create
> a connection string), and 2) Couldn't view tables in SQL2000 Enterprise
> manager (which after messing about with registrations ultimately wound up
> with me not even being able to create a registration (Error at end of
Wizard
> said "Data Source Name not found and no default driver specified).
>
> Not sure where to begin looking. The components in VB6 are registered
> properly and the files exist. In SQL, I'm mystified.

Start small. You don't need an ADO Control - yet.
You use divide-and-conquer techniques to work out what is intact, what is
damaged.

1. See if you can create a database using SQL2000 Enterprise Manager
If yes => Must be allright
If no => SQL2000 damaged, uninstall and reinstall

2. See if you can view all databases using Query Analyser, SQL2000
Enterprise Manager
If none can be seen by QA => QA damaged, uninstall SQL2000 and reinstall
+ SP4
If none all can be seen by EM => EM damaged, uninstall SQL2000 and
reinstall + SP4
If a particular database is damaged => repair or replace

3. See if VB6 can produce non-database executables
If yes => Must be allright
If no => uninstall and reinstall

4. See if you can create RecordSet to SQL Server database and/or other
databases like Access or Text file.
If all prove negative => reinstall MDAC
If some prove negative => examine providers etc.

5. If using ADO is a success but ADO control is not
=> Control must be damaged isn some way, etc.

Stephen Howe


.

Relevant Pages

  • VB6 SP6 problem with SQL 2000 Enterprise Manager
    ... Since installing SP6 I have had periodic problems with SQL 2000 Enterprise ... Manager. ... Needless to say I also have my database diagrams disappear. ...
    (microsoft.public.vb.bugs)
  • Re: Enterprise Manager "New Window from Here" Hack or Whatever
    ... > Do you have the latest Service Pack on the client where Enterprise ... > work for every database while it is opening it. ... >> databases on the server in SQL Server Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • Re: Profiling an Application
    ... You have a 10g database so my tip is: ... Actually the Enterprise Manager was one of the first things I wanted ... is (I didn't do the installation) or if it can be installed after the ...
    (comp.databases.oracle.server)
  • Database size / table size?
    ... current database size (as per what you see in the GUI via enterprise ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)