Problem with my database query

jmurrayhead · March 11th, 2004, 08:29 PM

I receive this message when my page loads:

Code:

Microsoft VBScript runtime error '800a01a8' 

Object required: '' 

/testdata.asp, line 18

This is the script:

Code:

<% 
dim objRS 
dim strSQL 
Set oConn=Server.CreateObject("ADODB.Connection") 
filePath = Server.MapPath("mydatabase.mdb") 
oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myroot\fpdb\mydatabase.mdb") 

set objRS = oConn.execute(strSQL) 
%> 
<% 
strSQL = strSQL & " WHERE UserName = '" & Session(appName & "UserName")& "'" 
%>

Any ideas as to what may be wrong..please let me know!! Thanks!!!!

U.N.C.L.E. · March 12th, 2004, 01:39 AM

Please try:

<%
dim objRS
dim strSQL
Set oConn=Server.CreateObject("ADODB.Connection")
Set objRS=Server.CreateObject("ADODB.Recordset")

oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("mydatabase.mdb"))

'...
%>

Imar · March 12th, 2004, 03:48 AM

What is line 18?

Do you have Option Explicit at the top of your page?
If so, you should declare the variable oConn with a Dim oConn statement. In fact, it's pretty good practice to do that anyway.....

Otherwise, post some more information and/or code.

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.