Hi, Can you do database calls in

[bangalibhai]

Hi,

Can you do database calls in JavaScript or JScript? If so please point me to some examples on how to perform that.

thanks,
nihad

 

[dilettante]

Sure you can!

If your database is Access prior to the version now in beta, you have the option of DAO (haven't worked through the beta yet, but DAO seems to be gone).

Most people will use ADO (ActiveX Data Objects) in Windows script right now though. As .Net penetrates the market we'll see a move to ADO.Net (very different from Classic ADO) but today you don't need to worry about it for general scripting chores.

There are a couple of ADO FAQs in this forum, albeit somewhat specialized.

There are some important articles, columns, sample code, and the definitive ADO reference located at:

http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28001860&frame=true

Be sure to expand the navigation tree under the "Data Access" topic at the left of this page. One classic article here is "Implementing ADO with Various Development Languages: The ADO Rosetta Stone" that covers how to use ADO in various languages, including VBScript and JScript:

http://msdn.microsoft.com/library/d...n-us/dnado/html/msdn_adorosest.asp?frame=true

Simple "here you go" sample code rather than instructional or reference material is available all over the web. Try a Google search using keywords like ADO and VBScript.

 

[bangalibhai]

Thanks, I will check it out.