与sql server的javascript连接 [英] javascript connectivity with sql server
本文介绍了与sql server的javascript连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我写了下面显示的代码bt得到错误activexobject未定义。
<％@ 页 语言 = vb AutoEventWireup = false CodeBehind = javascripconn.aspx.vb 继承 = ProjectMidDayMeal .javascripconn ％>
< ！ DOCTYPE html PUBLIC - // W3C // DTD < span class =code-attribute> XHTML 1.0 Transitional // EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd >
< html xmlns = http://www.w3.org/1999/xhtml >
< head runat = server >
< title > Untitled Page < / title >
< script >
function getdata（）
{
调试器;
var connection = new ActiveXObject（ ADODB .Connection）;
var connectionstring = 数据源= NODE5 \ SQLSERVER2005;初始目录= MDM;用户ID = SA;密码=为admin123;提供商= SQLOLEDB;
connection.Open（connectionstring）;
var rs = new ActiveXObject（ ADODB .Recordset）;
rs.Open（ SELECT * FROM BlockMaster，connection）;
rs.MoveFirst
while （！rs.eof）
{
document.write（rs.fields（< span class =code-digit> 1 ））;
rs.movenext;
}
rs.close;
connection.close;
}
< / script >
< / head >
< body >
< 表格 id = form1 runat = server >
< div >
< / div >
< / form >
< 输入 type = button onclick = getdata（） value = 获取数据 / >
< / body >
< / html >
========== ================================================== ==============
请愿。告诉我问题出在哪里。
解决方案
参考这些链接
ActiveXObject未定义且无法找到变量：ActiveXObject
未定义Activexobject错误：javascript
i have written the code shown below bt getting error "activexobject is not defined".
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="javascripconn.aspx.vb" Inherits="ProjectMidDayMeal.javascripconn" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script>
function getdata()
{
debugger;
var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=NODE5\SQLSERVER2005;Initial Catalog=MDM;User ID=sa;Password=admin123;Provider=SQLOLEDB";
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM BlockMaster", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}
rs.close;
connection.close;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
<input type="button" onclick="getdata()" value="get data" />
</body>
</html>
==========================================================================
pls. tell me where is the problem.
解决方案
Refer to these links
ActiveXObject is not defined and can''t find variable: ActiveXObject
Activexobject is not defined Error:javascript
这篇关于与sql server的javascript连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
