QSqlDatabase and Sql Server Native Client

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!

JonB

@MrShawn
Qt does not support SQL Server Native Client.

mrjj

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

MrShawn

Interesting... Appreciate the responses.