andre
/
qt-sql-example
mirror of https://github.com/andre-wojtowicz/qt-sql-example.git
1
1
Fork 1
Code Releases Activity
An exemplary Qt app that connects to SQL server and displays a table from a database
12 Commits 1 Branch 3 Tags 112 KiB
C++ 96.7%
QMake 3.3%
Go to file
Andrzej Wójtowicz 5296dbb540
Create FUNDING.yml 		2022-09-23 11:16:50 +02:00
.github Create FUNDING.yml 2022-09-23 11:16:50 +02:00
res Added project files 2017-09-01 22:53:26 +02:00
src Fixed table view Tab switch; 2017-09-03 19:04:05 +02:00
.gitignore Added project files 2017-09-01 22:53:26 +02:00
README.md Update README.md 2018-05-19 13:45:17 +02:00
config.ini Added project files 2017-09-01 22:53:26 +02:00
qt-sql-example.pro Version update 2017-09-03 19:32:02 +02:00
screenshot.png Minors along with readme update 2017-09-02 23:55:18 +02:00

README.md

Qt SQL Example

An exemplary Qt app that connects to SQL server and displays a table from a database. The program was made for educational purposes.

Compiled Windows and Linux applications with statically-linked libraries can be downloaded from Releases.

The application is developed with Qt 5.9.1 on Windows 10 and Ubuntu 16.04. The program was tested on MySQL Server 5.5.57 and Microsoft SQL Server 2008 R2 SP3.

Client config

The program reads config.ini on startup. The file must be in the app working directory.

SQL database drivers

A comprehensive discussion about SQL database drivers (Qt driver plugins as well as system drivers) can be found in Qt Documentation. MSSQL is handled by the ODBC driver.

Although binaries of the program have statically-linked libraries, in order to connect from Linux to MSSQL server, one should install ODBC SQL Server driver (e.g. msodbcsql17*).

The following section covers the essential tools to develop app with dynamically-linked SQL libraries.

Windows 10

  • Both Qt SQL driver plugins (QMYSQL and QODBC) should be already bundled with Qt SDK.
  • MySQL driver can be installed by placing libmysql.dll from C API for MySQL (mysqlclient) in the app working directory.
  • ODBC Driver Manager and SQL Server driver are built in; hence, no further installation is necessary. Alternatively, instead of SQL Server driver, one can use Microsoft ODBC Driver; see Microsoft Docs.

Ubuntu 16.04

Packages with Qt driver plugins and system SQL drivers:

  • MySQL - libqt5sql5-mysql libmysqlclient20,
  • ODBC (unixODBC Driver Manager and Microsoft ODBC Driver) - libqt5sql5-odbc libodbc1 unixodbc odbcinst msodbcsql17*.

* How to install msodbcsql17 - Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS.