View Single Post
 
Old March 11th, 2004, 08:29 PM
jmurrayhead jmurrayhead is offline
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to jmurrayhead
Default Problem with my database query

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!!!!