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 2000 Forums
 SQL Server Development (2000)
 Recordcount property not work in ADO using SQL server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-11-13 : 07:56:13
Balamurugan writes "hi,
I have developed one application in Visual basic and MS-Access.
I am trying to change MS-Acess to SQl server.
Recordcount property does't support in SQL server. but it support MS Access.

Please help me

Regards,
R.Balamurugan"

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-11-13 : 08:30:37
Dont know but what cursor type u r using in your recordset? try using adopenkeyset

Chirag

http://chirikworld.blogspot.com/
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-13 : 08:33:49
Are you using Clientside cursor on serverside cursor.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-13 : 08:34:30
It depends on the type of recordset you are using!

Use Keyset or Static cursor.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -