Tech Off Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SQL Connection String refresher

Back to Forum: Tech Off
  • User profile image
    qwert231

    What are the performance differences between these connection strings?

    Provider=SQLNCLI.1;Password=******;Persist Security Info=True;User ID=*****;Initial Catalog=OrderProcessing;Data Source=192.168.255.3

    Provider=SQLOLEDB.1;Password=******;Persist Security Info=True;User ID=*****;Initial Catalog=OrderProcessing;Data Source=192.168.255.3

  • User profile image
    W3bbo

    The top one is the SQL Native Client, presumably that would be faster than doing it via OleDB.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.