Member Avatar for tihomir

Hello
I have an application in vb6 that works on MSAccess 2003. And now I have to change connection to SQL Server 2005. I changed connection string to:
conn.Open "Driver={SQL Server}; Server=server; Database=Base; UID=ID; PWD=pwd"

I open recorset like this
Set rs = cnServer.Execute("SELECT * FROM tbl")
and it is OK.
But if I try to find record in recordset using
rs.find "ID = " & textbox.text I got error msg like
"Rowset does not support scrolling backward."

There is problem wit locking, aren't it?
HELP

  • 3 Contributors
  • 3 Replies
  • 89 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by tihomir
Member Avatar for vb5prgrmr

Yes, it sounds like an adforwardonly flag was set since you did not set them when you opened the rs.

Good Luck

Member Avatar for AndreRet

vb5prgmr is correct in saying that adForwardOnly is probably your problem. Use

rs.MoveFirst

and then call your

rs.Find '.....
Member Avatar for tihomir

Tx guys

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.