Announcement

Collapse
No announcement yet.

MS Update and ODBC problems with SQL Server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MS Update and ODBC problems with SQL Server



    Applications using the Open Database Connectivity (ODBC) interface may fail to connect after installing the November Patch Tuesday Windows updates, according to Microsoft.

    Users may see the apps that use the Microsoft ODBC SQL Server Driver have problems, with some attempts to access databases generating an error message when the connection fails, the software maker wrote this week in its Windows Health Dashboard.





  • #2
    Strange the article it links to is from June?

    Comment


    • #3
      Originally posted by Carlo Pagani View Post
      Strange the article it links to is from June?
      Don't know where you are getting June from.
      It's dated "Thu 8 Dec 2022 // 00:01 UTC​" and refers to the 8 November 2022 update. KB5019980

      Comment


      • #4
        My bad - Who would have thought that a company like M$ would serve me a date in American format instead of my locale settings
        • 12/06/2022

        Comment


        • #5
          FWIW since no one else suggested it... does the new Windows update require a new ODBC driver?

          Also since no one else suggested it ... do you have to use the ODBC interface? Might you be better off using OLE (with ADO) ? I'd say this might be a real thought when using any Microsoft-brand database. I think MS regards ODBC for their DBs as a secondary thing, as all their "in language" (VB, VB.NET) or " .NET-based" support has always been OLE.
          Michael Mattias
          Tal Systems (retired)
          Port Washington WI USA
          [email protected]
          http://www.talsystems.com

          Comment


          • #6
            From the horses mouth: ODBC is the primary native data access API for applications written in C and C++ for SQL Server

            Comment


            • #7
              From the horses mouth: ODBC is the primary native data access API for applications written in C and C++ for SQL Server

              ???

              Location of that horse's stall? (SOURCE?)


              Not that I doubt you, but I doubt you here. ODBC is "just one more way" of accessing a database. MS has used OLE for databases in the language syntax for at least VB and VB.NET.. although I do believe it utilizes ADO and its predecessors.

              Or maybe I'm just biased... I find OLE+ADO the most convenient way to access SQL/Server, Oracle and other DBs. ODBC always seems to hang me up either with PB programs or thru a third-party product offering both OLE and ODBC interfaces (i.e., Mercator) to supporting DBs - which MS claims for Access and SQL/Server.
              Michael Mattias
              Tal Systems (retired)
              Port Washington WI USA
              [email protected]
              http://www.talsystems.com

              Comment


              • #8
                MCM, from the horse's mouth to the horse's...

                Dated November 2022:

                https://learn.microsoft.com/en-us/sq...l-server-ver16
                "Not my circus, not my monkeys."

                Comment


                • #9
                  Originally posted by Eric Pearson View Post
                  MCM, from the horse's mouth to the horse's...

                  Dated November 2022:

                  https://learn.microsoft.com/en-us/sq...l-server-ver16
                  Yep, it took me two seconds to plug that statement into a search engine and get that MS link as the first hit

                  Comment

                  Working...
                  X