GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → andre-wojtowicz → qt-sql-example

andre-wojtowicz / qt-sql-example

Licence: other
Example Qt application that connects to SQL Server and displays a table from the database

Programming Languages

C++
36643 projects - #6 most used programming language
QMake
1090 projects

Labels

mysqlqtsqlodbcmssql

Projects that are alternatives of or similar to qt-sql-example

django-pyodbc-azure
Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
Stars: ✭ 327 (+1027.59%)
Mutual labels:  odbc, mssql
TelephoneDirectory
microservices-> .net 6, golang - Docker, Ocelot, RabbitMq, MassTransit, mssql, postgresql, elasticsearch, kibana, jwt
Stars: ✭ 40 (+37.93%)
Mutual labels:  mssql
sql exporter
Database agnostic SQL exporter for Prometheus
Stars: ✭ 72 (+148.28%)
Mutual labels:  mssql
laravel-db2
laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.
Stars: ✭ 56 (+93.1%)
Mutual labels:  odbc
php-mssql-alpine
Docker image with Microsoft SQL Server Driver into php image alpine
Stars: ✭ 28 (-3.45%)
Mutual labels:  mssql
dbclient
데이터배이스 관리 / 자동 메일링 / Admin 자동화 / Database IDE Tool. SQL Development Helper. Support DBMS Oracle/Mysql/MS-SQL
Stars: ✭ 35 (+20.69%)
Mutual labels:  mssql
sql-hunting-dog
Quick Search Tool (AddIn) for Microsoft SQL Management Studio
Stars: ✭ 33 (+13.79%)
Mutual labels:  mssql
db.rstudio.com
Website dedicated to all things R and Databases
Stars: ✭ 13 (-55.17%)
Mutual labels:  odbc
sql-surveyor
High-level SQL parser. Identify tables, columns, aliases and more from your SQL script in one easy to consume object. Supports PostgreSQL, MySQL, SQL Server and Oracle (PL/SQL) dialects.
Stars: ✭ 19 (-34.48%)
Mutual labels:  mssql
simple-ddl-parser
Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. & table properties, types, domains, etc.
Stars: ✭ 76 (+162.07%)
Mutual labels:  mssql
tsql-scripts
Transact-SQL scripts and gists
Stars: ✭ 35 (+20.69%)
Mutual labels:  mssql
laravel-sybase
Connection and Laravel Eloquent driver for Sybase
Stars: ✭ 29 (+0%)
Mutual labels:  odbc
loopback-connector-mssql
LoopBack connector for Microsoft SQL Server
Stars: ✭ 50 (+72.41%)
Mutual labels:  mssql
eReports-open-source
Sistema de envio e agendamento de relatórios
Stars: ✭ 30 (+3.45%)
Mutual labels:  mssql
uzbekistan-regions-data
Full Database of regions Uzbekistan available in JSON, SQL & CSV Format All Regions, Districts & Quarters with Latin, Cyrillic and Russian versions. (Районы (туманы) Республики Узбекистан и Города областного (республиканского) подчинения)
Stars: ✭ 46 (+58.62%)
Mutual labels:  mssql
QuickDAO
Simple Data Access Object library with LinQ and multiengine support for (Windows,Linux,OSX/IOS/Android) and freepascal (Windows/Linux)
Stars: ✭ 49 (+68.97%)
Mutual labels:  mssql
pypyodbc
pypyodbc is a pure Python cross platform ODBC interface module (pyodbc compatible as of 2017)
Stars: ✭ 39 (+34.48%)
Mutual labels:  odbc
SACK
System Abstraction Component Kit
Stars: ✭ 18 (-37.93%)
Mutual labels:  odbc
sqlserver
GORM sqlserver driver
Stars: ✭ 33 (+13.79%)
Mutual labels:  mssql
implyr
SQL backend to dplyr for Impala
Stars: ✭ 74 (+155.17%)
Mutual labels:  odbc
View All Similar Projects ➔

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.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].