A
Andy Wawa
Hi,
on a simple HTML (not an ASP!)-Site I try to connect to a sql server
(MS):
<html>
<title>Test</title>
<head>
<script language="javascript">
<!--
Function showForm(){
var conn
conn = CreateObject("ADODB.Connection");
var rst
var = CreateObject("ADODB.recordset");
var sql
sql = "select f01, f02 from IT_ASP where id < 10";
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Initial Catalog=Projekt;Data Source=MYSERVER\MYSQL;pwd=123Abc.";
rst.Open (sql, conn);
while (!rst.EOF){
document.write(rst(0));
document.write("<br>");
rst.MoveNext;
}
rst.Close;
rst=Nothing;
document.close;
}
//-->
</script>
</head>
<body>
<form name="myform" action="">
<input name="but1" type="button" value="klick"
onClick="javascript:showForm()">
</form>
</body>
</html>
I'm still getting an error: object expected.
What's wrong? (I know, it's late...)
Andy
on a simple HTML (not an ASP!)-Site I try to connect to a sql server
(MS):
<html>
<title>Test</title>
<head>
<script language="javascript">
<!--
Function showForm(){
var conn
conn = CreateObject("ADODB.Connection");
var rst
var = CreateObject("ADODB.recordset");
var sql
sql = "select f01, f02 from IT_ASP where id < 10";
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Initial Catalog=Projekt;Data Source=MYSERVER\MYSQL;pwd=123Abc.";
rst.Open (sql, conn);
while (!rst.EOF){
document.write(rst(0));
document.write("<br>");
rst.MoveNext;
}
rst.Close;
rst=Nothing;
document.close;
}
//-->
</script>
</head>
<body>
<form name="myform" action="">
<input name="but1" type="button" value="klick"
onClick="javascript:showForm()">
</form>
</body>
</html>
I'm still getting an error: object expected.
What's wrong? (I know, it's late...)
Andy