Driver vs Provider

Results 1 to 2 of 2

Thread: Driver vs Provider

  1. #1
    Join Date
    Dec 1969

    Default Driver vs Provider

    Hi,<BR>when should we use "Driver=sqlserver" and "provider=sqloledb" in the connection string.Is there a difference, please let me know<BR><BR>regards<BR>Simhan

  2. #2
    Join Date
    Dec 1969

    Default ODBC vs OLEDB

    I&#039;m no expert but Driver=SQLServer is using ODBC whereas Provider=SQLOLEDB is using OLE DB. You should use OLE DB because ODBC is just another layer on top of OLE DB and is slower. I should think there&#039;s some articles out there somewhere with more details.<BR>HTH<BR>Dom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts