Home Database Mysql Tutorial QT 连接SQLServer

QT 连接SQLServer

Jun 07, 2016 pm 03:52 PM
sqlserver supply data use connect

QtSql虽说提供了通用的数据库访问接口,可是有些数据库就是不太通用, 在windows下用QT连接sqlserver,折腾了半天. 一. 配置 1. 启用TCP/IP 安装好sqlserver2005后, 开始菜单找到 配置工具-SQL Server配置管理器: SQLEXPRESS 的协议,启用TCP/IP,启用相应IP地址;

    QtSql虽说提供了通用的数据库访问接口,可是有些数据库就是不太通用, 在windows下用QT连接sqlserver,折腾了半天. 

 

一. 配置

    1. 启用TCP/IP

     安装好sqlserver2005后, 开始菜单找到 配置工具->SQL Server配置管理器:

     SQLEXPRESS 的协议,启用TCP/IP,启用相应IP地址; SQL Native Client 配置, 客户端协议, 启动TCP/IP, TCP/IP属性设置监听1433端口 

    

    2. 启用远程连接

    配置工具->SQL Server外围应用配置器-> 本地连接和远程连接,勾选同时使用TCP/IP和named pipes即可

 

二. 测试

   方法一: 

Cpp代码  QT 连接SQLServer

  1. QSqlDatabase OpenDB()  
  2. {  
  3.     QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");  
  4.     // 注意,对于express版本数据库, 一定要加\\sqlexpress这种后缀  
  5.     QString dsn="DRIVER={SQL SERVER};SERVER=192.168.10.22\\sqlexpress;DATABASE=sqlscada";  
  6.     db.setDatabaseName(dsn);  
  7.     db.setUserName("sa");  
  8.     db.setPassword("scada");  
  9.       
  10.     if(!db.open())  
  11.     {  
  12.         qDebug("Error:%s",qPrintable(db.lastError().text()));  
  13.         return db;  
  14.     }  
  15.     return db;  
  16. }  

   连接数据库时, 一直连不上报错: ConnectionOpen (Invalid Instance()) , 连接无效, 结果发现微软对express版本数据库是有限制的, 在SERVER字段添加\\sqlexpress这样后缀, 连接OK

 

   方法二: 设置数据源,指定dsn即可

   控制面板->系统和安全->管理工具->数据源(ODBC)

   QT 连接SQLServer

 

   QT 连接SQLServer

   

   代码:

Cpp代码  QT 连接SQLServer

  1. QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");  
  2. db.setDatabaseName("testdsn");  
  3. db.setUserName("sa");  
  4. db.setPassword("scada");  

 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to solve the problem that the object named already exists in the sqlserver database How to solve the problem that the object named already exists in the sqlserver database Apr 05, 2024 pm 09:42 PM

How to solve the problem that the object named already exists in the sqlserver database

How to import mdf file into sqlserver How to import mdf file into sqlserver Apr 08, 2024 am 11:41 AM

How to import mdf file into sqlserver

What to do if the sqlserver service cannot be started What to do if the sqlserver service cannot be started Apr 05, 2024 pm 10:00 PM

What to do if the sqlserver service cannot be started

How to check sqlserver port number How to check sqlserver port number Apr 05, 2024 pm 09:57 PM

How to check sqlserver port number

How to recover accidentally deleted database in sqlserver How to recover accidentally deleted database in sqlserver Apr 05, 2024 pm 10:39 PM

How to recover accidentally deleted database in sqlserver

Where is the sqlserver database? Where is the sqlserver database? Apr 05, 2024 pm 08:21 PM

Where is the sqlserver database?

The vitality of super intelligence awakens! But with the arrival of self-updating AI, mothers no longer have to worry about data bottlenecks The vitality of super intelligence awakens! But with the arrival of self-updating AI, mothers no longer have to worry about data bottlenecks Apr 29, 2024 pm 06:55 PM

The vitality of super intelligence awakens! But with the arrival of self-updating AI, mothers no longer have to worry about data bottlenecks

How to delete sqlserver if the installation fails? How to delete sqlserver if the installation fails? Apr 05, 2024 pm 11:27 PM

How to delete sqlserver if the installation fails?

See all articles