Using ADO to connect to SQL 2000

TheMSsForum.com: The Microsoft Software Forum

Hi guys,

just a little info...I use ADO to query active directory without major
problems, however I would like to use ADO in other scripts to query a
SQL db...because I have never done it before and have not seen many
examples on the MS site or other ones, I would like to see if anybody
has a basic example of a vbscript that uses ADO to make a simple query
to a SQL db so that I can develop my own.

Thanks in advance,
Bar
Top

Re: Using ADO to connect to SQL 2000 by Bob

Bob
Thu Sep 18 06:10:16 CDT 2003

barabba wrote:
> Hi guys,
>
> just a little info...I use ADO to query active directory without major
> problems, however I would like to use ADO in other scripts to query a
> SQL db...because I have never done it before and have not seen many
> examples on the MS site or other ones, I would like to see if anybody
> has a basic example of a vbscript that uses ADO to make a simple query
> to a SQL db so that I can develop my own.
>
> Thanks in advance,
> Bar

Do an advanced google groups search on microsoft.public.inetserver.asp.db
(keywords ADODB SQL Server) - you will find plenty of examples, especially
if you search for posts from me.

For demos, go to http://www.davidpenton.com/testsite/

See www.able-conlulting.com/ado_conn.htm for connection string examples.
Concentrate on the SQLOLEDB examples.

HTH,
Bob Barrows


Top

Re: Using ADO to connect to SQL 2000 by barabba72

barabba72
Fri Sep 19 10:18:36 CDT 2003

Thanx !
Bar

"Bob Barrows" <reb_01501@yahoo.com> wrote in message news:<Oha#uVdfDHA.2352@TK2MSFTNGP09.phx.gbl>...
> barabba wrote:
> > Hi guys,
> >
> > just a little info...I use ADO to query active directory without major
> > problems, however I would like to use ADO in other scripts to query a
> > SQL db...because I have never done it before and have not seen many
> > examples on the MS site or other ones, I would like to see if anybody
> > has a basic example of a vbscript that uses ADO to make a simple query
> > to a SQL db so that I can develop my own.
> >
> > Thanks in advance,
> > Bar
>
> Do an advanced google groups search on microsoft.public.inetserver.asp.db
> (keywords ADODB SQL Server) - you will find plenty of examples, especially
> if you search for posts from me.
>
> For demos, go to http://www.davidpenton.com/testsite/
>
> See www.able-conlulting.com/ado_conn.htm for connection string examples.
> Concentrate on the SQLOLEDB examples.
>
> HTH,
> Bob Barrows
Top