Rowset position cannot be started error message in

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Rowset position cannot be started error message in

Author

Topic

thermo_ll
Starting Member

1 Post

Posted - 2010-10-11 : 03:08:15

my Old program in running in the SQL 2003 calling a stored procedure using recordset program created from vb6 ... when i migrate to sql 2008 this program giving me an error of "rowset position cannot be started " when im trying to execute movenext command ...but this is working in old SQL server

is there any security i have to configure in the SQL 2008 regarding this issue

Program below

Set rsDN = New ADODB.Recordset
With cmd
.ActiveConnection = SoftArcConnect
.CommandText = "SAL_Pump_Tx_Print_SELECT"
.CommandType = adCmdStoredProc
.NamedParameters = True
Set pTxID = .CreateParameter("@TxID", adBigInt, adParamInput)
.Parameters.Append pTxID

pTxID.Value = dbDeliveryRefNumber
rsDN.Open cmd, , adOpenKeyset, adLockOptimistic
If Not rsDN Is Nothing Then
If rsDN.State = adStateOpen Then
If rsDN.BOF = False And rsDN.EOF = False Then

rsDN.MoveFirst <--- error came here

sCouponNo = rsDN.Fields("CouponNo_Charged")
rptDNPrint.Database.SetDataSource rsDN, 3, 1

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-11 : 09:12:47

you don't need that line at all anyway. i'd just comment it out.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources