MSSql and bookmarks

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am running D7, MSSQL Server 2000 - 8.00.760. I connect to a MSSQL via the "SQLOLEDB.1" provider. My cursorlocation is set to clUseServer.

I have two databases on two PC's, one is a backup of the other.


My problem is that I get:

"Datasets do not support bookmarks, which are required to ..."

when I connect to one of the two MSSQL servers, while it works fine on the other one.

I have compared all the differences I could think of, but I cant find out why it only works on one of the 2 db's.

Any idears?


Thanks

Thomas K
.