|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi,
I am a newbie to database, I read there are many connection ways such as ADO.NET, OLE DB, ODBC, SQLHELPER. What are their difference in connecting to a MS SQL 2000? What criteria to decide to use which one? Thanks |
|
#2
|
||||
|
||||
|
If you want to code for the .NET runtime, you can use ADO.NET. ADO.NET is probably the most optimized for SQL2000. Otherwise, I would recommend ADO. Those are the latest and greatest. ADO is a replacement for DAO and RDO (more acronyms). OLEDB is a layer that ADO sits on top off. So ADO uses OLEDB.
|
|
#3
|
|||
|
|||
|
Thanks for your suggestion
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Compare ADO, OLE DB, ODBC, SQLHELPER |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|