no way <% @LANGUAGE="JScript" %>
<!--#include File="adojavas.inc"-->
<HTML>
<BODY BGCOLOR="White" topmargin="10" leftmargin="10">
<%var Source = "SELECT * FROM authors";
var Connect = "Provider=sqloledb;DataSource=srv;" +
"Initial Catalog=pubs;User Id=sa;Password=;"
var Rs1 = Server.CreateObject( "ADODB.Recordset.2.5" );
debugger;
Rs1.Open(Source,Connect,adOpenForwardOnly);
Response.Write("ok");
%>
</BODY>
</HTML>保存成.asp文件并放到web服务器下
<!--#include File="adojavas.inc"-->
<HTML>
<BODY BGCOLOR="White" topmargin="10" leftmargin="10">
<%var Source = "SELECT * FROM authors";
var Connect = "Provider=sqloledb;DataSource=srv;" +
"Initial Catalog=pubs;User Id=sa;Password=;"
var Rs1 = Server.CreateObject( "ADODB.Recordset.2.5" );
debugger;
Rs1.Open(Source,Connect,adOpenForwardOnly);
Response.Write("ok");
%>
</BODY>
</HTML>保存成.asp文件并放到web服务器下
/** 公用变量 **/
var db_name = "netBook.mdb"; // Access数据库名/**
* 函数: connect
* 功能: 连接 Access 数据库
* 返回连接
* 要求数据库文件在本文档一起
*/
function connect() {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
// var dbcon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
dbc.Open(dbcon);
return dbc;
}function gen() {
var conn = connect();
var rs = conn.Execute("select * from manage where type='netBook'");
var s = rs("content").value;
rs.Close();
conn.Close();
document.open("text/html", "replace");
document.write(s);
document.close();
}
</script>
ID=dsoComposer HEIGHT=0 WIDTH=0>
<PARAM NAME="Server" VALUE="http://musicserver">
<PARAM NAME="Connect" VALUE="dsn=music;uid=guest;pwd=">
<PARAM NAME="SQL" VALUE="select compsr_name from composer">
</OBJECT>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
<script language=javascript>
function connectDb()
{
var ConnDB = new ActiveXObject("ADODB.Connection");
ConnDB.ConnectionString="dsn=orc2;uid=webstat;pwd=khkj;";
ConnDB.Open();
var Rs = new ActiveXObject("ADODB.Recordset");
var tempstr="";
Rs.Open("select * from tab",ConnDB,1,3);
while(!Rs.EOF)
{
tempstr = tempstr + Rs("TNAME") + "<br>";
Rs.MoveNext;
}
test.innerHTML=tempstr;
}
</script>
</HEAD>
<BODY><P><div id=test> </div>
<P><INPUT id=button1 type=button value=显示 name=button1 onclick="connectDb()"></P></BODY>
</HTML>