Storedprocedure execution error.

[specialdreamsin]

Hi all, The following code is giving "Error: The rowset is not bookmarkable." error. please help me out.                         Dim cmd As New ADODB.Command                         cmd.ActiveConnection = Vcn                         cmd.CommandType = adCmdStoredProc                         cmd.CommandText = "sp_help('CNSM')"                         If Vrs.State = 1 Then Vrs.Close                         Vrs.CursorLocation = adUseClient                         Vrs.CursorType = adOpenDynamic                         Set Vrs = cmd.Execute                         Set DG1.DataSource = Vrs Set DG1.DataSource = Vrs line is giving above error.. Ramesh Sambari

Knowledge is like honey. Collect it, to make life sweet.

[Moreno Airoldi]

I'm definitely rusty on VB6 & ADO, but I think your problem is here: Vrs.CursorType = adOpenDynamic Try to change it to: Vrs.CursorType = adOpenForwardonly

2+2=5 for very large amounts of 2 (always loved that one hehe!)

[specialdreamsin]

Hi, I have tried all four types of Cursor Types. But no use... Please give me some other solution. Ramesh Sambari

Knowledge is like honey. Collect it, to make life sweet.

[Moreno Airoldi]

Ok I found out where the problem is: see here[^].

2+2=5 for very large amounts of 2 (always loved that one hehe!)

[Dave Kreskowiak]

An easier link to follow: http://support.microsoft.com/kb/278408[^]

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...