Accessing SQL server Database using java script

oxygen · #1 (**permalink**) 07-17-2007, 12:09 AM

Accessing SQL server Database using java script

Connecting Database using javascript:

Goal:

This is a pure javascript project and it is used to access tables.

Source:

<html>
<head>
<SCRIPT LANGUAGE=javascript>

function ConDB()
{
var conn = new ActiveXObject("ADODB.Connection") ;
alert(conn);

// replace <server ip>,<ur catalog>,<user> and <password> with apporpriate values

var connectionstring="Data Source=<server ip>";Initial Catalog=<ur catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";

alert(connectionstring);
conn.Open(connectionstring);
alert(conn);
var rs = new ActiveXObject("ADODB.Recordset");
alert(rs);
rs.Open("SELECT * FROM users ", conn);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}

rs.close;
conn.close;
}
</SCRIPT>
</head>
<body OnLoad="javascript:ConDB()">
</body>
</html>

save this as a html page to run.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Client side JavaScript and and Server side Java Script	sathian	HTML, CSS and Javascript Coding Techniques	2	11-09-2007 10:30 PM
how to rectify java script runtime error	vel.m8	HTML, CSS and Javascript Coding Techniques	1	11-04-2007 09:42 PM
Can an html and Java script be separated and the script placed in the cgi-bin?	Pvinothkumar	HTML, CSS and Javascript Coding Techniques	1	09-13-2007 06:11 AM
difference between Client side JavaScript and and Server side Java Script?	Sundaram	HTML, CSS and Javascript Coding Techniques	1	09-05-2007 11:46 AM
Accessing COM component using java script	oxygen	HTML, CSS and Javascript Coding Techniques	1	07-18-2007 02:25 AM