none
SQLOLEDB depricated ?? RRS feed

  • Question

  • Hi,

    I am using SQLOLEDB provider for my MFC Application to access the database. We are using SQL Server 2008 R2 and SQL Server 2012.

    Right now i am making some modification in my code and i have SQL Server 2008 R2. I need to enable SSL for my sql server and i am able to do it.

    The doubts i have are :

    1. Does SQLOLEDB depricated in SQL Server 2012 ? Reference https://social.msdn.microsoft.com/Forums/sqlserver/en-US/19e0c306-0be4-46b5-b207-0937931d63a7/difference-between-sql-server-native-client-100-and-oledb-for-sql-sever-?forum=sqlintegrationservices

    2. I have installed certificate on server machine and client machine and added "Use Encryption For Data=True" in connection string and it is able to establish SSL Connection.But i am not attaching that certificate to SQL Server(SQL Server Configuration Manager->Protocols for MSSQLSERVER->properties->certificate). Then how it is working ?? Am i missing anything??

    Please help me clearing my doubt.

    Many thanks



    • Edited by Nihal_dev Sunday, July 10, 2016 11:06 AM
    Sunday, July 10, 2016 8:29 AM

Answers

  • how come  it is working with SQL Server 2012 and SQL Server 2014?


    Deprecated only means MS won't release further versions in the future, OleDB does not stop working from on to the other day.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Nihal_dev Wednesday, July 13, 2016 3:55 AM
    Tuesday, July 12, 2016 5:12 PM

All replies

  • 1. Does SQLOLEDB depricated in SQL Server 2012 ?

    Yes.  The legacy SQLOLEDB provider has been deprecated in favor of SQL Server Native Client since SQL Server 2005.  Furthermore, ODBC is preferred over OLE DB for relational database access as described in the announcement in this forum:  https://social.msdn.microsoft.com/Forums/en-US/e696d0ac-f8e2-4b19-8a08-7a357d3d780f/microsoft-is-aligning-with-odbc-for-native-relational-data-access-faq?forum=sqldataaccess

    2. I have installed certificate on server machine and client machine and added "Use Encryption For Data=True" in connection string and it is able to establish SSL Connection.But i am not attaching that certificate to SQL Server(SQL Server Configuration Manager->Protocols for MSSQLSERVER->properties->certificate). Then how it is working ?? Am i missing anything??

    A self-signed certificate can be used for SSL when encryption is requested but no cert is installed.  See https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Sunday, July 10, 2016 2:25 PM
    Moderator
  • Hello,

    Please read the following resource:

    http://blogs.msdn.com/b/adonet/archive/2011/09/13/microsoft-sql-server-oledb-provider-deprecation-announcement.aspx



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 10, 2016 6:28 PM
    Moderator
  • Thanks for reply but not able to convince myself.

    Please have a look at my doubt:

    I am using self signed certificate.But i need to install it on client machine too otherwise the connection string is failing with SSL Security error.

    So shall i conclude that "To establish a SSL connection with SQL server just have a self signed certificate installed on client and server machine without attaching it to SQL Server and ""Use Encryption For Data=True" 

    in connection string".

    If not then how can i make my SSL channel secured on client's demand with SQL Server by using SQLOLEDB provider ??

    Second doubt : 

    It it is deprecated then how the same code is working for SQL Server 2012 ??

    (i mean the connection string is same but it doesn't have "Use Encryption For Data=True")



    • Edited by Nihal_dev Monday, July 11, 2016 8:51 AM
    Monday, July 11, 2016 8:39 AM
  • What about this 

    https://msdn.microsoft.com/en-us/library/dn538994(v=sql.120).aspx

    Monday, July 11, 2016 2:26 PM
  • That's an article about Installing Data Provider; where do you see a relation to your first question?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, July 11, 2016 5:47 PM
  • Please check the link below : 

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/19e0c306-0be4-46b5-b207-0937931d63a7/difference-between-sql-server-native-client-100-and-oledb-for-sql-sever-?forum=sqlintegrationservices

    I am a kind of not visualize if SQLOLEDB is deprecated then how come  it is working with SQL Server 2012 and SQL Server 2014?

    Tuesday, July 12, 2016 4:41 AM
  • how come  it is working with SQL Server 2012 and SQL Server 2014?


    Deprecated only means MS won't release further versions in the future, OleDB does not stop working from on to the other day.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Nihal_dev Wednesday, July 13, 2016 3:55 AM
    Tuesday, July 12, 2016 5:12 PM