I am having a peculiar problem when i am using a DSN
Connection i am getting Record count but when i am using
Provider=SQLOLEDB.1.............
i am getting Record count -1

Anybody can show a reason for this

thanks in advance

Probably due to the cursor type.
Try setting to a client side cursor.
The record count is only set when the data is delivered.

Nigel Rivett (SQL Server MVP)
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!