Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ado - Server not handled

Status
Not open for further replies.

sharonc

Programmer
Jan 16, 2001
189
US
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= &quot;C:\Program files\Common files\system\ado\msado15.dll&quot;-->

Dim oConn, rs

Set oConn = CreateObject(&quot;ADODB.Connection&quot;)

oConn.Open = &quot;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Forms;Data Source=SEIMS&quot;

Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
rs.Open &quot;Contractors&quot;, oConn, adOpenForwardOnly,adLockReadOnly
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top