Re: Here's a rather broad question...

I've gone through too many to start enumerating here; this is why I'm
taking
the "I'm a dumbass user and I've never done this before and I wanna know
what steps I have to go through" approach instead of going through every
single problem I've encountered so far. At this point I'm not interested
in
diagnosing any specific error; I'm looking for the general steps you
normally would have to take starting from a clean install of the
components
listed in my original message.

I don't know any general steps or aware of any general steps.
I use ADO but I have never used IIS or ASP's.

If you can't be bothered with general advice
for n00bs, I'm cool with letting somebody else help me along.

<shrill laugh> Your attitude is plain wrong.
With this newsgroup, there are too many combinations of use of ADO in terms
of

Version of MDAC
Version of Windows
Database being used at the back end
Provider being used
Language - VB,C++,Delphi,VBScript,JavaScript

for anybody here to be an expert in all combinations. That is also true of
others lurking in the newsgroup as well - their knowledge will be certain
combinations. I only know a limited set - my experience to date so far of
using ADO for 6 years mostly VC++ (most versions), some of ADOX, nearly all
versions of MDAC since 2.0, SQL Server provider and various versions SQL
Server, some use of Access & Jet provider - and that is it.
So I and others are reliant on you posting _EXACT_ messages of problems you
have encountered and maybe, maybe... it might overlap with some of the
problems I have experienced and then I might be able to say something.

There is no general advice, AFAIK. If your thinking there is some special
arcane answers and I am holding out on you - for the combination your using
or Microsoft KB articles, or some list of "gotchas" - none that I have
seen. There is Carl Prothman's FAQ on ADO but that covers exact problems
using ADO (e.g. RecordCount returning -1), not general advice about using
ADO. There are some specific Microsoft KB articles on ADO but again they are
specific not general.

There is some general overview infomation Microsoft's MSDN site but I don't
know what you are really after.
You might want to start here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_dataaccess.asp?frame=true

Stephen Howe



.

Relevant Pages

  • Re: Why not use DAO?
    ... You have been refering to DAO vs. ADO when these two things (in the context ... you must have ALREADY used a provider to get to. ... interface for working with JET databases. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Why not use DAO?
    ... All reall life programmers i know of use the jet oledb 3.5 or 4.0 provider ... ADO for ACCESS ... The TS asked "Why not used DAO ?" ... interface for working with JET databases. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Regarding fastest database interaction with Oracle in VC++
    ... If you are using ADO, then you will have a Connection object. ... is a lightweight COM API that sits on top of OLEDB. ... If you install MDAC 2.8, it will install some providers for you. ... It will install the MS Oracle provider. ...
    (microsoft.public.vc.database)
  • Re: Mysterious OLE DB DBID propids
    ... strange properties, interfaces, etc. ... ADO that causes ADO to ask for the DBIDs? ... provider is related to it. ... msdshape.h file and adc.h file (for the client ...
    (microsoft.public.data.oledb)
  • Re: Using crystal reports with MySQL ADO connector
    ... to use ADO components with our application. ... The database we're developing with is MySQL. ... Connector/NET components which are ADO compliant. ... The example in the above link uses a wizard to link to OLE DB provider ...
    (microsoft.public.dotnet.framework.adonet)