CodeWeblog.com » lt,data source,sql connection » javaScript connect to database

javaScript connect to database

js connect to database
Key words: js connected database, javascript connection database, js operation database, js read a database, javascript link data
Database on the Desktop
<script language="javascript">
/ / Use javascript to write server-side sample code to connect database
function conn () (
var db_bbs
db_bbs = "dd.mdb" / / definition of a database
var conn = new ActiveXObject ( "ADODB.Connection");
conn.Open ( "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + db_bbs +"");

var rs = new ActiveXObject ( "ADODB.Recordset");
var sql = "select name from authors"; / / database in the authors table, name field
rs.open (sql, conn);
alert (rs (0)) / / Remove the first to

conn.close ();
conn = null;
)
</ script>
The following is the sql connection
<script language="javascript">
/ / Use javascript to write server-side sample code to connect database
var conn = new ActiveXObject ( "ADODB.Connection");
conn.Open ( "Provider = SQLOLEDB.1; Data Source = localhost; User"
+ "Password =; Initial Catalog = pubs");
var rs = new ActiveXObject ( "ADODB.Recordset");
var sql = "select * from authors";
rs.open (sql, conn);

rs.close ();
rs = null;
conn.close ();
conn = null;
</ script>
Digg Technorati StumbleUpon Mixx del.icio.us Reddit BlinkList Furl YahooMyWeb feedburner

Tags: lt (RSS), data source (RSS), sql connection (RSS), connection database (RSS), quot quot (RSS), script language (RSS), server side (RSS), pubs (RSS), new activexobject (RSS), microsoft (RSS), conn (RSS), select name (RSS), key words (RSS), initial catalog (RSS), dd (RSS), jet oledb (RSS), database javascript (RSS), open sql (RSS), database function (RSS), microsoft jet (RSS)

Permalink: http://www.codeweblog.com/javascript-connect-to-database/

Leave a reply