troubleshooting Question

Change Recordset Cursor Type ASP VBScript

Avatar of garethtnash
garethtnashFlag for United Kingdom of Great Britain and Northern Ireland asked on
ASPVB ScriptMicrosoft SQL Server 2008
28 Comments1 Solution1220 ViewsLast Modified:
Hello,

I've just got the following error, which would indicate to me that I need to change the recordset cursor type.....

How do I do this, in my recordset or connection string,

assuming my recordset is -

<%
Dim RsProductDetail
Dim RsProductDetail_cmd
Dim RsProductDetail_numRows

Set RsProductDetail_cmd = Server.CreateObject ("ADODB.Command")
RsProductDetail_cmd.ActiveConnection = MM_Connection_STRING
RsProductDetail_cmd.CommandText = "SELECT Something from dbo.somewhere" 
RsProductDetail_cmd.Prepared = true
RsProductDetail_cmd.Parameters.Append RsProductDetail_cmd.CreateParameter("param1", 5, 1, -1, RsProductDetail__MMColParam) ' adDouble

Set RsProductDetail = RsProductDetail_cmd.Execute
RsProductDetail_numRows = 0
%>

OR my connection string is -

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Connection_STRING
MM_Connection_STRING = "Provider=SQLOLEDB.1;Password=APassword;User ID=AUserID;Initial Catalog=ACatologue;Data Source=111.111.111.11"
%>
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 28 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 28 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros