Beginner ADO Question

Keywords:  ADODB

---

Question:

I've gotten so much help from this board and I've always been told to "dance with the one that brought you" so here I go again.

I wrote a script (with the help of the people here) to put information into an Access database. My next step is to do the same with a SQL 2000 database. I found a great example on how to do this on this site but I have a question first.

In the example, one of the lines is:

DB = ObjectOpen("ADODB.Connection")

Now, in previous examples, the ObjectOpen command used "Access.Document" or "Word.Document", etc where Access/Word are well known apps. Is ADODB an application that I need to install on my workstation like Word/Access? Is it an ODBC connection that needs to be created? How can I verify that my ObjectOpen command using the ADODB will work?

The Microsoft site isn't very clear on this.

Thanks everyone in advance!!!

Answer:

ADO (ADODB) is available with MDAC. Check the following tech support articles:

Article ID: W14906

Article ID: W14659

Article ID: W14660

---

Article ID:   W15240