Error Type: ADODB.Recordset (0x80

[heathL]

I'm not sure how to fix this error ----

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/intranetadmin/communications/PersonnelAnnouncementEmployeeReviewPost.asp, line 34

Here is the code. Line 34 is red.

Dim rsNewsStories 'Recordset variable
Dim sql 'Holds the SQL statement
Dim ipaddress 'Holds the users IP Address
Dim sFullUser 'Holds the users NT ID
Dim pkey 'Holds the information from the pkey field on the previous form

'Setting pkey equal to the pkey field on the previous form
pkey = request.form("pkey&quot

'Selecting all from tblPersonnelAnnouncement where pkey equals the local variable pkey
sql = "SELECT * FROM tblPersonnelAnnouncements WHERE pkey =" & pkey

'Creating recordset and opening it and sql and connection
Set rsNewsStories = Server.CreateObject("adodb.recordset&quot
rsNewsStories.open strSQLDB, strCON, 3, 3

Thanks.

 

[JamesLean]

You should maybe try posting this in the ASP forum. But as a start hint - your SQL string is called sql but you use strSQLDB when opening the recordset.

Also, I take it you just haven't included the code which opens the connection object strCON? --James