473,387 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

ADODB.Recordset error '800a0bb9'

Hi
I am suddenly getting this message:

ADODB.Recordset error '800a0bb9'

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

/include/vars.asp, line 52

This is a copy of lines 52-69:

Expand|Select|Wrap|Line Numbers
  1. objRS.Open "table1", Application("strConnect"), adOpenForwardOnly, adLockReadOnly, adCmdTable
  2.         If objRS.EOF Then
  3.             objRS.AddNew
  4.             objRS("VisitDay") = Application("VisitDay")
  5.         ElseIf objRS("VisitorCount") < Application("VisitorCount") Then
  6.             objRS("VisitorCount") = Application("VisitorCount")
  7.             objRS("EditorCount") = Application("EditorCount")
  8.             objRS("HitCount") = Application("HitCount")
  9.         End if
  10.         objrS.Update
  11.         objRS.Close
  12.  
  13.         Application.Lock
  14.         Application("VisitDay") = strStatDate
  15.         Application("VisitorCount") = 1
  16.         Application("EditorCount") = 0
  17.         Application("HitCount") = 1
  18.         Application.Unlock
  19.  
Can anyone help me? :)
Nov 1 '14 #1
0 2262

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DC | last post by:
Im getting the error ADODB.Fields error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. In the following script to copy and...
0
by: elcc1958 | last post by:
I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a...
0
by: Dot Netizen | last post by:
I am having trouble passing an ADODB.Recordset from a VB6 application to a VB.Net class library using COM Interop. I am running this on XP SP2 with the .Net Framework 1.1 and MDAC 2.8 SP1. I've...
1
by: Beau | last post by:
Hi all, thanks in advance. Ok, heres the story. What is happening...... -------------------------------- I've got an ASP page that loops. It loops in order to get data in different,...
3
by: ching | last post by:
Hi I've seen many posting in the web on the similar problem I encountered below, but I still couldn't find any solution to it. I built an ASP.NET application, which is migrated from ASP. the...
2
by: wolverine1654 | last post by:
I have an application that we are moving to a 2003 server using IIS6. Currently, it works fine with IIS5 on a NT server. When I try to log into the application and connect to an Oracle DB, I get...
5
by: Simone | last post by:
Hello I hope you guys can help me. I am very new to ADO... I am creating a ADODB connection in a module and trying to access it from a command button in a form. Function fxEIDAssgn(plngEID As...
5
by: dradcnn | last post by:
I built an ASP.NET application.The application was built using ASP initially. Recently we migrated to ASP.NET, but we didn't recode the script using .NET. We just add the aspcompat=true at each...
3
by: | last post by:
Hello ppl, I have snippet that works fine udner ADODB with VB6, but something wrong with it in Vb.NET. Anyone can help? Recordset1 (ADODB.Recordset) Error: Arguments are of the wrong type, are...
4
nitindel
by: nitindel | last post by:
Hi All, I am using DbCom Handler for my DataBase Connectivity. But the Query is not firing i.e recordset is not getting populated... it is Showing the error as follows: ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.