Can someone help me? Here is my code. When I get to 'Set rs = Server.CreateObject("ADODB.Recordset"' I get the following runtime error message: an Exception Type 'Microsoft Vbscript runtime error' object required 'server" was not handled. How do I fix this error. If I take out Server, it won't work.
<SCRIPT ID = serverEventHandlersVBS language=vbscript event=onclick for=Command1 RUNAT=SERVER>
<!--
<!--#include virtual= "C:\Program files\Common files\system\ado\msado15.dll"-->
Dim oConn, rs
Set oConn = CreateObject("ADODB.Connection"
oConn.Open = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Forms;Data Source=SEIMS"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open "Contractors", oConn, adOpenForwardOnly,adLockReadOnly
<SCRIPT ID = serverEventHandlersVBS language=vbscript event=onclick for=Command1 RUNAT=SERVER>
<!--
<!--#include virtual= "C:\Program files\Common files\system\ado\msado15.dll"-->
Dim oConn, rs
Set oConn = CreateObject("ADODB.Connection"
oConn.Open = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Forms;Data Source=SEIMS"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open "Contractors", oConn, adOpenForwardOnly,adLockReadOnly