Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is wrong with my code?

Status
Not open for further replies.
BeeDeeBee

BeeDeeBee

Programmer
Dec 18, 2000
5
US
Please help. I may be overlooking something obvious. I have included the error message when the page is published.

<html>

<head>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1252&quot;>
<meta name=&quot;GENERATOR&quot; content=&quot;Microsoft FrontPage 4.0&quot;>
<meta name=&quot;ProgId&quot; content=&quot;FrontPage.Editor.Document&quot;>
<title>CheckData</title>
</head>

<body>
<%
' Create Connection
Set InormConn=Server.CreateObject (&quot;ADODB.Connection&quot;)
InormConn.Open &quot;DSN=RapidWeb&quot;
'
' Create Recordset Object
set rsInorm=Server.CreateObject (&quot;ADODB.Recordset&quot;)
'
'Set rsInorm methods
rsInorm.ActiveConnection=InormConn
rsInorm.CursorType = adOpenKeyset
rsInorm.LockType=adLockOptimistic ' Line 22
rsInorm.Source=&quot;tabApprovals&quot;
rsInorm.Open


ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/CheckData.asp, line 22
 
Sort by date Sort by votes
Hi

In your case these values would be
rsInorm.CursorType = 1 'adOpenKeySet
rsInorm.LockType = 3 ' adLockOptimistic

Have fun
caf
 
Upvote 0 Downvote
1. On the connection you need to specified the database name and table name:
Set mCon = &quot;DSN=yourDSN;DataBase=yourDB&quot;
2. On the Recordset need to have the query string:
mRecord.Open &quot;SELECT * FROM yourTable&quot;, mConn(Active Connection)


Try that tvuong@kempercm.com
Programmer.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jtm2020hyo
  • Locked
  • Question
What is wrong with this code?
Replies
3
Views
492
strongm
strongm
Peterdo
  • Locked
  • Question
Read code
Replies
1
Views
389
strongm
strongm
bdwilcox
  • Locked
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
1K
SoftwareRT
SoftwareRT
wchull
  • Locked
  • Question
How do I resolve this permissions error in my script?
Replies
0
Views
429
wchull
wchull
Palito1916
  • Locked
  • Question
Disable multiple computer accounts using TXT file with computer names
Replies
2
Views
496
Palito1916
Palito1916

Part and Inventory Search

Sponsor

Back
Top