ADO vs SQL

<i><b>Originally posted by : Barry Schneider (bschneider@lvi.com)</b></i><br /><br />What are the benefits and drawbacks when using ASP with ADO vs SQL.<br /><br />Is it just personal preference or does no method providemore functionality and or performance?<br />

<i><b>Originally posted by : Brenda Gorecki (bgorecki@everbrite.com)</b></i><br />Does it matter if you mix ADO and SQL? IE:can you update a record with ADO and add a new record using SQL?<br /><br />Thank You<br /><br />------------<br />Barry Schneider at 3/10/2000 7:56:42 AM<br /><br /><br />What are the benefits and drawbacks when using ASP with ADO vs SQL.<br /><br />Is it just personal preference or does no method providemore functionality and or performance?<br />

<i><b>Originally posted by : Mike B (mikeb811@hotmail.com)</b></i><br />You can mix ADO and SQL. There are some advantages to using SQL and the Command object as no connection or recordset objects must be created.<br /><br />I have also found that it is sometimes easier to use AddNew and Update methods of ADO than SQL even though overall SQL may be a little faster.<br /><br />Mike<br /><br /><br />------------<br />Brenda Gorecki at 3/13/2000 10:19:06 AM<br /><br />Does it matter if you mix ADO and SQL? IE:can you update a record with ADO and add a new record using SQL?<br /><br />Thank You<br /><br />------------<br />Barry Schneider at 3/10/2000 7:56:42 AM<br /><br /><br />What are the benefits and drawbacks when using ASP with ADO vs SQL.<br /><br />Is it just personal preference or does no method providemore functionality and or performance?<br />