Hi,
on my very simple HTML-Site (not an ASP !) I try to connect to a
sql-server:
<html><head>
<SCRIPT LANGUAGE="vbscript">
<!--
Function Test()
dim rst
dim dsn
dim sql
Set rst = CreateObject("ADODB.Recordset")
set dsn = createObject("ADODB.Connection")
dsn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=myid;Initial Catalog=Projects;Data Source=SQLServer;pwd=mypass"
sql = "select id, bez from H_Titel"
rst.Open sql, dsn
dim newWindow = window.open("","")
while not (rst.EOF)
newWindow.document.write(rst(0) & " " & rst(1))
newWindow.document.write("<br>")
rst.moveNext
loop
rst.Close
set rst=Nothing
End Function
-->
</SCRIPT>
</head>
<title>VB_Test</title>
<body>
<form name="myForm" action="">
<input type="button" name="but1" value="Klick"
onClick="vbscript:Test()">
</form>
</body>
</html>
When I try to run it, I get en error "a wrong type" (I'm trying to
translate it from german, so I hope it's the same errror message in
english). I suppose there is something wrong with the cration of an
connection object.
SQL Server is running, password and user ID are right, there is no a
network problem. What's wrong?
Andy