|
|
Databases and Drivers
Started by samir at 06-06-2008 7:39 AM. Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 06-06-2008, 7:39 AM
|
samir
Joined on 05-21-2008
Posts 28
|
SQL server 2005 native driver or through OLEDB
|
|
|
|
|
Hi All,
What are the pros and cons of accessing a SQL server database using the native driver versus through OLEDB ?
Thanks in advance.
Samir
|
|
|
|
|
Report
|
|
|
|
|
06-06-2008, 9:50 PM
|
Shankar
Joined on 10-24-2005
Dubai, UAE
Posts 219
|
Re: SQL server 2005 native driver or through OLEDB
|
|
|
|
|
|
Hi Samir,
The Native Driver in C6.3 works fine with SQL Server 2005. Look in the help for MARS support. The ODBC driver also works fine. You have to install the "SQL Native Client" though. OLEDB access is possible via ADO but the ADO templates are not as feature-rich as the ABC ones.
Regards
Shankar
|
|
|
|
|
Report
|
|
|
|
|
|