README.md

Description

I have not found any sample that shows database access with javaScript. Well, I created one.

It is very simple since Javascript has the activeXObject that allow us to call an external object in the same way that vbscript uses CreateObject.

More Info

You need SQL Server, a valid login, and know the name of a table and at least one column to test the sample.

Submitted On
By	Marcio Coelho
Level	Intermediate
User Rating	4.5 (94 globes from 21 users)
Compatibility
Category	Databases/ JDBC
World	Java
Archive File

Source Code

<SCRIPT LANGUAGE=javascript>
	<!--
	var conn = new ActiveXObject("ADODB.Connection") ;
	var connectionstring = "Provider=sqloledb; Data Source=itdev; Initial Catalog=pubs; User ID=sa;Password=yourpassword"
	conn.Open(connectionstring)
	var rs = new ActiveXObject("ADODB.Recordset")
	rs.Open("SELECT gif, description, page, location FROM menu1", conn)
// Be aware that I am selecting from this table, but you need to pick your own table
	while(!rs.eof)
	{
		alert(rs(0));
		rs.movenext
	}
	 rs.close
	conn.close
	//-->
	</SCRIPT>