Asp Error 800a01a8 Object Required
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Microsoft Vbscript Runtime Error '800a01a8' Object Required
Meta Discuss the workings and policies of this site About Us microsoft vbscript runtime error '800a01a8' object required ' undefined ' Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with microsoft vbscript runtime error '800a01a8' object required 'wscript' us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
Microsoft Vbscript Runtime Error Object Required ' String
like you, helping each other. Join them; it only takes a minute: Sign up ASP Object required up vote 0 down vote favorite I have the error in Classic ASP: Microsoft VBScript runtime error '800a01a8' Object required: 'SqlStatement' /Data/Database.asp, line 186 The line 186 is: SqlStatement.CommandText = sql. Here is my code: Dim Db, SqlStatement, RS
Vbscript Object Required String
Set Db = Nothing Set SqlStatement = Nothing Set RS = Nothing ' Initialize the database once Private Sub SqlInitDb() If isNull(Db) Or varType(Db) = vbEmpty Or IsObject(Db) = False Then ' Create database connection object Set Db = Server.CreateObject("ADODB.Connection") ' Set connection timeout Db.ConnectionTimeout = Session("ConnectionTimeout") ' Set command timeout Db.CommandTimeout = Session("CommandTimeout") ' Open database Db.Open Session("ConnectionString") End If If isNull(SqlStatement) Or varType(SqlStatement) = vbEmpty Or IsObject(SqlStatement) = False Then ' Create a sql statement Set SqlStatement = Server.CreateObject("ADODB.Command") ' Set opened database as active connection for the SQL statement SqlStatement.ActiveConnection = Db End If End Sub ' Close the database if it is not closed Private Sub SqlClose() If Not isNull(SqlStatement) And varType(SqlStatement) <> vbEmpty And IsObject(SqlStatement) = True Then SqlStatement.ActiveConnection.Close End If Set SqlStatement = Nothing If Not isNull(Db) And varType(Db) <> vbEmpty And IsObject(Db) = True Then For Each objErr In Db.Errors response.write("
") response.write("Description: ") response.write(objErr.Description & "
") response.write("Help context: ") response.write(objErr.HelpContext & "
") response.write("Help file: ") response.write(objErr.HelpFile & "
") response.write("N
required: '' If this is your first visit, be sure to check out the FAQ by clicking the link above. You may microsoft vbscript runtime error 800a01a8 object required xmlroot have to register before you can post: click the register link
Object Required Error In Vbscript
above to proceed. To start viewing messages, select the forum that you want to visit from the microsoft vbscript runtime error '800a000d' selection below. Results 1 to 3 of 3 Thread: Microsoft VBScript runtime error '800a01a8' Object required: '' Tweet Thread Tools Show Printable Version Email this Page… Subscribe http://stackoverflow.com/questions/15973411/asp-object-required to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-18-2013,08:43 AM #1 Mwackers View Profile View Forum Posts Registered User Join Date Apr 2013 Posts 1 Microsoft VBScript runtime error '800a01a8' Object required: '' I setup up a test connection to input data from a form to a mysql database. However, http://www.webdeveloper.com/forum/showthread.php?276549-Microsoft-VBScript-runtime-error-800a01a8-Object-required I received the following error: Microsoft VBScript runtime error '800a01a8' Object required: '' /datainputstatus.asp, line 20 Form- http://www.middletownplanning.com/form2.html Processing ASP- http://www.middletownplanning.com/datainputstatus.asp (I've noted line 20 below with "<---- Line 20") <%@ Language=VBSCRIPT %>