Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. QSqlDatabase and Sql Server Native Client

QSqlDatabase and Sql Server Native Client

Scheduled Pinned Locked Moved Solved General and Desktop
4 Posts 3 Posters 842 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    MrShawn
    wrote on last edited by
    #1

    Hello,

    I was talking to my peer about SQL server connections and he tells me ODBC drivers are old and antiquated. He says he uses Sql Server Native Client, and that it is (supposedly) a lot faster and has more features. I am slightly disturbed by this because it appears to me in Qt I am unable to use Sql Server Native Client.

    Some research I have done, does seem to point that there are at least more features which may not be supported by ODBC, but I also read that the SQL Native Client actually uses ODBC or OLE type connections. Not sure exactly, if people have more information on it I would be happy to hear about it.

    My main question is, is there a way to use the SQL Server Native Client (easily) with Qt? I have tried to use it by editing my connection string
    to:

    DRIVER={SQL Server Native Client 11}
    

    from

    DRIVER={SQL Server}
    

    I sadly get the error

    "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect"
    

    Does anyone know if its possible, maybe it is already using the Sql Server Native Client and I don't even know?

    Thanks!

    JonBJ 1 Reply Last reply
    0
    • M MrShawn

      Hello,

      I was talking to my peer about SQL server connections and he tells me ODBC drivers are old and antiquated. He says he uses Sql Server Native Client, and that it is (supposedly) a lot faster and has more features. I am slightly disturbed by this because it appears to me in Qt I am unable to use Sql Server Native Client.

      Some research I have done, does seem to point that there are at least more features which may not be supported by ODBC, but I also read that the SQL Native Client actually uses ODBC or OLE type connections. Not sure exactly, if people have more information on it I would be happy to hear about it.

      My main question is, is there a way to use the SQL Server Native Client (easily) with Qt? I have tried to use it by editing my connection string
      to:

      DRIVER={SQL Server Native Client 11}
      

      from

      DRIVER={SQL Server}
      

      I sadly get the error

      "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect"
      

      Does anyone know if its possible, maybe it is already using the Sql Server Native Client and I don't even know?

      Thanks!

      JonBJ Offline
      JonBJ Offline
      JonB
      wrote on last edited by
      #2

      @MrShawn
      Qt does not support SQL Server Native Client.

      1 Reply Last reply
      1
      • mrjjM Offline
        mrjjM Offline
        mrjj
        Lifetime Qt Champion
        wrote on last edited by mrjj
        #3

        Hi

        Did you read about

        Sql Server Native Client

        https://docs.microsoft.com/en-us/sql/relational-databases/native-client/sql-server-native-client?view=sql-server-ver15

        "The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. "

        Besides ODBC is not old and antiquated

        https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

        1 Reply Last reply
        1
        • M Offline
          M Offline
          MrShawn
          wrote on last edited by
          #4

          Interesting... Appreciate the responses.

          1 Reply Last reply
          0

          • Login

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Users
          • Groups
          • Search
          • Get Qt Extensions
          • Unsolved