Hi all,

Is it possible to run a VBScript client side with access to an Access
Database? If so where should I look to learn the syntax.

I can use ADO in VBScript through ASP, however I want to develop a small
script to run from the desktop.

Cheers, Bill.

Re: VBScript & ADO by McKirahan

McKirahan
Fri May 21 09:03:40 CDT 2004

"William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
news:uDjN0uzPEHA.640@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> Is it possible to run a VBScript client side with access to an Access
> Database? If so where should I look to learn the syntax.
>
> I can use ADO in VBScript through ASP, however I want to develop a small
> script to run from the desktop.
>
> Cheers, Bill.


You can use ADO with a VBS file or, if you want an interface, use HTA (HTML
Application):

Introduction to HTML Applications (HTAs)
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/hta/overv
iew/htaoverview.asp

HTML Applications
http://www.htmlgoodies.com/beyond/hta.html



Re: VBScript & ADO by William

William
Fri May 21 09:20:46 CDT 2004

Thanks,

Is there any difference in the syntax when using ADO in VB Script not in
ASP.

Bill.


"McKirahan" <News@McKirahan.com> wrote in message
news:0%nrc.4206$ny.887496@attbi_s53...
> "William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
> news:uDjN0uzPEHA.640@TK2MSFTNGP09.phx.gbl...
> > Hi all,
> >
> > Is it possible to run a VBScript client side with access to an Access
> > Database? If so where should I look to learn the syntax.
> >
> > I can use ADO in VBScript through ASP, however I want to develop a small
> > script to run from the desktop.
> >
> > Cheers, Bill.
>
>
> You can use ADO with a VBS file or, if you want an interface, use HTA
(HTML
> Application):
>
> Introduction to HTML Applications (HTAs)
>
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/hta/overv
> iew/htaoverview.asp
>
> HTML Applications
> http://www.htmlgoodies.com/beyond/hta.html
>
>



Re: VBScript & ADO by Viatcheslav

Viatcheslav
Fri May 21 09:50:04 CDT 2004

No, syntax is the same except that you have no ASP objects (Request,
Response, Session etc.).

//------------------------------------
Regards,
Vassiliev V. V.
http://www-sharp.com -
Scripting/HTA/.Net Framework IDE

"William E Hatto" <xxnospamxxweh@bigpond.net.au> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:egN5Q7zPEHA.2348@TK2MSFTNGP10.phx.gbl...
> Thanks,
>
> Is there any difference in the syntax when using ADO in VB Script not in
> ASP.
>
> Bill.
>
>
> "McKirahan" <News@McKirahan.com> wrote in message
> news:0%nrc.4206$ny.887496@attbi_s53...
> > "William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
> > news:uDjN0uzPEHA.640@TK2MSFTNGP09.phx.gbl...
> > > Hi all,
> > >
> > > Is it possible to run a VBScript client side with access to an Access
> > > Database? If so where should I look to learn the syntax.
> > >
> > > I can use ADO in VBScript through ASP, however I want to develop a
small
> > > script to run from the desktop.
> > >
> > > Cheers, Bill.
> >
> >
> > You can use ADO with a VBS file or, if you want an interface, use HTA
> (HTML
> > Application):
> >
> > Introduction to HTML Applications (HTAs)
> >
>
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/hta/overv
> > iew/htaoverview.asp
> >
> > HTML Applications
> > http://www.htmlgoodies.com/beyond/hta.html
> >
> >
>
>



Re: VBScript & ADO by William

William
Fri May 21 10:38:30 CDT 2004

Ok thanks,

have got the gist of it. Up and running :-P

Cheers, Bill.


"Viatcheslav V. Vassiliev" <msnewsgroup@www-sharp.com> wrote in message
news:eLDBoL0PEHA.3044@TK2MSFTNGP10.phx.gbl...
> No, syntax is the same except that you have no ASP objects (Request,
> Response, Session etc.).
>
> //------------------------------------
> Regards,
> Vassiliev V. V.
> http://www-sharp.com -
> Scripting/HTA/.Net Framework IDE
>
> "William E Hatto" <xxnospamxxweh@bigpond.net.au> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ: news:egN5Q7zPEHA.2348@TK2MSFTNGP10.phx.gbl...
> > Thanks,
> >
> > Is there any difference in the syntax when using ADO in VB Script not in
> > ASP.
> >
> > Bill.
> >
> >
> > "McKirahan" <News@McKirahan.com> wrote in message
> > news:0%nrc.4206$ny.887496@attbi_s53...
> > > "William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
> > > news:uDjN0uzPEHA.640@TK2MSFTNGP09.phx.gbl...
> > > > Hi all,
> > > >
> > > > Is it possible to run a VBScript client side with access to an
Access
> > > > Database? If so where should I look to learn the syntax.
> > > >
> > > > I can use ADO in VBScript through ASP, however I want to develop a
> small
> > > > script to run from the desktop.
> > > >
> > > > Cheers, Bill.
> > >
> > >
> > > You can use ADO with a VBS file or, if you want an interface, use HTA
> > (HTML
> > > Application):
> > >
> > > Introduction to HTML Applications (HTAs)
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/hta/overv
> > > iew/htaoverview.asp
> > >
> > > HTML Applications
> > > http://www.htmlgoodies.com/beyond/hta.html
> > >
> > >
> >
> >
>
>



Re: VBScript & ADO by McKirahan

McKirahan
Fri May 21 10:44:32 CDT 2004

"William E Hatto" <xxnospamxxweh@bigpond.net.au> wrote in message
news:egN5Q7zPEHA.2348@TK2MSFTNGP10.phx.gbl...
> Thanks,
>
> Is there any difference in the syntax when using ADO in VB Script not in
> ASP.
>
> Bill.


"Server." prefix should be removed from "CreateObject()".

"Request.", "Response." and "MapPath" are not supported.

You can now use "WScript.Echo" and "MsgBox".

"<%@ Language=VBScript %>" and all "<%" and "%>" should be removed.