ADO best way for JScript to talk to Access?

[kaeli]

All,
I am making a very simple application for my own personal use on my
Windows XP box. I want one that looks and feels like a web app. I don't
have too many languages to choose from on my home computer, and I don't
feel like installing a web server, and it already has Access on it, so I
was thinking HTA with JScript and Access. I see a way for JScript to
talk to Access is with ADO. Is this the best way, or is that the "old
way"? Sometimes net searches can bring up a lot of old crap.

TIA

--
--
~kaeli~
Those who get too big for their britches will be exposed in
the end.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

 

[Martin Honnen]

I am making a very simple application for my own personal use on my
Windows XP box. I want one that looks and feels like a web app. I don't
have too many languages to choose from on my home computer, and I don't
feel like installing a web server, and it already has Access on it, so I
was thinking HTA with JScript and Access. I see a way for JScript to
talk to Access is with ADO. Is this the best way, or is that the "old
way"? Sometimes net searches can bring up a lot of old crap.

No, the ADODB.whatever objects instantiated with new ActiveXObject are
the proper way, and Windows XP has the proper MDAC version so I don't
think you need to download anything.
There are however different ways of accessing the database/establishing
the connection, you shouldn't use ODBC/DSN as that is antiquated
compared to ADO with a OLEDB provider, see
http://www.aspfaq.com/show.asp?id=2126
for instance, it is part of the ASP FAQ (and uses VBScript) but of
course the connection strings are the same whether your script is
JScript or VBScript and runs in HTA or ASP.

 

[kaeli]

No, the ADODB.whatever objects instantiated with new ActiveXObject are
the proper way, and Windows XP has the proper MDAC version so I don't
think you need to download anything.
There are however different ways of accessing the database/establishing
the connection, you shouldn't use ODBC/DSN as that is antiquated

Good to know. That's what I would have used. *g*
The last time I did anything with VB I used a DSN, so I would have just
done it again.

compared to ADO with a OLEDB provider, see
http://www.aspfaq.com/show.asp?id=2126
for instance, it is part of the ASP FAQ (and uses VBScript) but of
course the connection strings are the same whether your script is
JScript or VBScript and runs in HTA or ASP.

Either language is fine by me. I know enough VBScript to be dangerous.

I was considering doing this little project in VB6, but figured I'd be
quicker using an HTA and JScript, since I know html and jscript a lot
better.

Thanks for the link!

--