By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,402 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,402 IT Pros & Developers. It's quick & easy.

ADO best way for JScript to talk to Access?

P: n/a

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

Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


kaeli wrote:
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.

--

Martin Honnen
http://JavaScript.FAQTs.com/

Jul 20 '05 #2

P: n/a
In article <40********@olaf.komtel.net>, ma*******@yahoo.de enlightened
us with...

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!

--
--
~kaeli~
Reading while sunbathing makes you well red.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.