Solved QODBC
-
Hi.
You can follow the suggestions of @mtrch and @beecksche .
Please upgrade to version 5.6.1 or higher or build the source. -
Hi Devopia53
I coulden't find the path : Src\qtbase\src\plugins\sqldrivers\odbc on my computer. however I have the odcb driver in odcb data source administrator window. should I install qt source seprately? where can I download qt source for windows?
-
-
I'm no expert on ODBC, but I had to connect to a Netezza DB last week and all it took was to:
- install the Netezza ODBC driver
- configure the ODBC connection in windows (%windir%\system32\odbcad32.exe) and add the DNS user
- followed the instruction on http://doc.qt.io/qt-5.7/sql-driver.html
a) Be aware that when connecting to an ODBC datasource you must pass in the name of the ODBC datasource to the QSqlDatabase::setDatabaseName() function rather than the actual database name.
b)With Microsoft SQL Server the result set returned by a stored procedure that uses the return statement, or returns multiple result sets, will be accessible only if you set the query's forward only mode to forward using QSqlQuery::setForwardOnly().
Unfortunetly I don't have the code right now.
I will try to post it in the next 12h. -
I downloaded Qt Open Source 5.6. May this version haven't accurate proficiency requirements for using ODCB?
-
I have Qt 5.6.2 Open Source and I have the ODBC driver in C:\Qt\5.6\mingw49_32\plugins\sqldrivers\qsqlodbc.dll
-
I don't have this .dll where can I download that? I would be grateful if you could send it for me.
-
-
@Devopia53 said in QODBC:
on 5.6.0
thank you very much. I use the 5.6.0 version. I hit similar solutions everywhere and never find this path on my computer. I'll install a new version.
-
@lina
Or just use the qt maintenance tool and chose 'update' to 5.6.2 -
@lina
You just need reinstall qt 5.6.0 and in select components step ,choose select all ,or choose Sources in subset of Qt5.6
after installation you have src folder in C:\Qt\Qt5.6.0\5.6 and you can find odbc folder in there@Devopia53
It isn't missing from version 5.6.0 -
yeah. I didn't install qt5.6.0 completely. I re-install it and it works now