ADODB.Recordset error '800a0bb9'

Expand Post »

I am trying to use an ASP upload file to upload banners. I am receiving this error:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/links/add_banner_upload.asp, line 98

Below is the code

Query = "SELECT * FROM banner"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open Query, Connector, 3, 3 ( THIS IS LINE 98)
RS.AddNew
RS("name") = Uploader.Form("name")
RS("email") = Uploader.Form("email")
RS("site") = Uploader.Form("site")
RS("link_address") = Uploader.Form("link_address")
RS("link_back") = Uploader.Form("link_back")
RS("image") = File.FileName
RS("size") = File.FileSize
RS("type") = File.ContentType
RS("date") = date()
RS.Update
RS.close
Connector.close

I am new at this so having difficulty.

Similar Threads

Bind ListBox to ADODB.Recordset in Visual Basic 4 / 5 / 6
Recordset Error in Visual Basic 4 / 5 / 6
ADODB.Field error '80020009' in ASP
ADODB.Field error '80020009' in ASP
ADODB.Recordset (0x800A0E78):Operation is not allowed when the object is closed. in ASP

raywood5

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

10 posts
since Jan 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: changing the image dynamically

Next Thread in ASP Forum Timeline: Cant figure this error out: "The page you requested, has produced an error"

DaniWeb Message

Cancel Changes

User Name
Password