Qt and MS Sql Server
-
wrote on 22 Sept 2017, 14:01 last edited by mrdebug
Can someone show and example on how to connect to a ms sql server from Qt, without to use odbc?
Is there a library to connect to all the sql server type similar to ado? -
Can someone show and example on how to connect to a ms sql server from Qt, without to use odbc?
Is there a library to connect to all the sql server type similar to ado?@mrdebug said in Qt and MS Sql Server:
Can someone show and example on how to connect to a ms sql server from Qt, without to use odbc?
i am not sure if that this is possible at all (with Qt's default sql plugins).
Whats wrong with ODBC? -
wrote on 22 Sept 2017, 14:08 last edited by mrdebug
Because my software has to be easy to install.
During the installation the customer has to extract all the data from the old software and it is not possible that the customer has to create the odbc dsn.
The best way is to use ado but QAxObject does not work.
Strangely QAxObject works through odbc but not with a ado string connection to a ms sql server.I did a research of an external library to do this but I haven't found nothing.
-
wrote on 23 Sept 2017, 07:10 last edited by
Many thanks!
I see it is necessary to register to the website. Is there another place where I can download it? -
wrote on 25 Sept 2017, 15:53 last edited by
Finally I had to implement directly the ado api, found in the Microsoft website.
I did not understood why QAXObject works only through odbc. -
wrote on 25 Sept 2017, 18:49 last edited by
Does this shed some light?
https://stackoverflow.com/questions/41198357/how-to-use-adodb-connection-in-qt-and-query-database
-
wrote on 25 Sept 2017, 20:16 last edited by
Unfortunately not. My problem is related to the access at a MS Sql Server database through Ado across the network, without using odbc.
6/8