Hi,



Can any please tell me what is the diff. between these two objects and wh

ich

should be used and when.





Thanks in Advance



Imtiaz

The latter is for working with the SQL7-and-upwards managed provider. It's

one of the three objects that belong to that provider. they're optimised

for the SQL 7 and (currently, but presumably including all subsequent)

SQL2000 DB managers.



The ADOcommand is the correctsponding object belonging to the more generic

ADO+ managed provider. Its used when accessing

other datastores.



Dan Whalin's article about ADO+/C# on ASP Today has some info on using the

two providers. I haven't got the link, but it'll be listed on my links

page http://p2p.wrox.com/topics/asplinks/asplinks.htm



HTH

Daniel Walker

Wrox Press

> Hi,

> 

> Can any please tell me what is the diff. between these two objects and wh

> ich

> should be used and when.

> 

> 

> Thanks in Advance

> 

> Imtiaz

Hi,



You should use SQLCOmmand if you have a MS SQL Server.

SQLCommand work directly to the database without an OLEDB Provider, this

increase perfomance.



Use ADOCommand when you work with other data sources, such as ORACLE, Sybas

etc.

With ADO you can use OLEDB providers.



/Fredrik Normen







-----Original Message-----

From: Imtiaz ALAM [mailto:imtiaz_alam@u...]

Sent: den 23 november 2000 17:15

To: ASP+

Subject: [aspx] ADOCommand & SQLCommand





Hi,



Can any please tell me what is the diff. between these two objects and which

should be used and when.





Thanks in Advance



Imtiaz