SQL Server 2008 R2 Express v SQL Server 2012 Express

Posted on 2014-08-06
Last Modified: 2014-08-06
What is the difference between this connection string:
conn.Open "Provider=SQLNCLI10;Server=localhost\SQLExpress;Database=xxx;Uid=xxx;Pwd=xxx;"

And this one:
conn.Open "Provider=SQLNCLI11;Server=localhost\SQLExpress;Database=xxx;Uid=xxx;Pwd=xxx;"

The first one I used when I used SQL Server 2008 and it also works with 2012 on my web pages but on my windows apps I had to change to the second one in order to get them to run once I upgraded to 2012.

Just wondering about the apparent inconsistencies.

Question by:Bob Schneider
    LVL 32

    Assisted Solution

    Obviously the provider... and a provider is nothing else then - may be you may guess?? - a driver. The correct driver must be installed, otherwise it won't work. btw, SQLNCLI is short for SQL Server Native Client.
    LVL 32

    Assisted Solution

    by:Big Monty
    I don't believe sqlncli10 is a valid provider for sql server 2012. looking for some documentation to back that up right now.....
    LVL 32

    Accepted Solution

    according to here, it isn't compatible with sql server 2012:

    i'm not sure how you're getting it work with your web apps. I recommend using the correct provider for sql server 2012, which is version 11

    Author Closing Comment

    by:Bob Schneider
    Thanks.  I will switch it all over to the preferred provider.
    LVL 32

    Expert Comment

    Both native clients work with both server versions. The problem is that the provider string is used to look up only this driver, not a compatible one. So, in one of the scenarios the provider pointed to an uninstalled version.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now