Odbc: Difference between revisions

From Qt Wiki
Jump to navigation Jump to search
(Connection strings for ODBC to MS SQL Server)
 
m (redirect)
 
Line 1: Line 1:
 
#REDIRECT [[ODBC]]
==ODBC==
ODBC stands for Open Database Connectivity and provides an open API for DBMS access, where the ODBC layer acts as an transition layer. Therefor the client and the server itself will have to implement an interface to the ODBC layer.
 
==Opening MS SQL Server Database Connection using QODBC==
When trying to open a Database Connection with QODBC please ensure
* You have QODBC driver available (this depends on your ODBC driver installations)
* Your server has an ODBC interface and is enabled to
** use shared memory access or
** use TCP/IP connections or
** use named pipe connection
 
All connections only require the ''DatabaseName'' to be set by calling {{DocLinkRef|ref=QSqlDatabase|anchor=setDatabaseName|label=QSqlDatabase::setDatabaseName}}
 
===Open Connection using shared memory access===
For this option to work you will need to have access to memory of the machine and must have permissions to access shared memory. For using a shared memory connection it is required to set ''lpc:'' in front of the '''Server''' string. Connection using the SQL Server Native Client 11 is made using these steps:
<syntaxhighlight lang="cpp">
QString connectString = "Driver={SQL Server Native Client 11.0};";                    // Driver is now {SQL Server Native Client 11.0}
connectString.append("Server=lpc:"+QHostInfo::localHostName()+"\\SQLINSTANCENAME;");  // IP,Port
connectString.append("Database=SQLDBSCHEMA;");  // Schema
connectString.append("Uid=SQLUSER;");          // User
connectString.append("Pwd=SQLPASS;");          // Pass
db.setDatabaseName(connectString);
if(db.open())
{
    ui->statusBar->showMessage("Connected");
}else{
    ui->statusBar->showMessage("Not Connected");
}
</syntaxhighlight>
 
===Open Connection using Named Pipe===
This option requires your ODBC Connection to have a full DSN. The ''Server'' string is setup by using the Windows Computername and the Instancename of the SQL Server. The example connection will be opened using SQL Server Native Client 10.0
<syntaxhighlight lang="cpp">
QString connectString = "Driver={SQL Server Native Client 10.0};"; // Driver can also be {SQL Server Native Client 11.0}
connectString.append("Server=SERVERHOSTNAME\\SQLINSTANCENAME;");  // IP,Port
connectString.append("Database=SQLDBSCHEMA;");  // Schema
connectString.append("Uid=SQLUSER;");          // User
connectString.append("Pwd=SQLPASS;");          // Pass
db.setDatabaseName(connectString);
if(db.open())
{
    ui->statusBar->showMessage("Connected");
}else{
    ui->statusBar->showMessage("Not Connected");
}
</syntaxhighlight>
 
===Open Connection using TCP/IP===
For opening a TCP/IP connection the server should be configured to allow connections on a fixed port, otherwise you will first have to query for the currently active port. In this example we have a fixed port at 5171. You can find an example for setting up the server to allow connections on a fixed port at [http://web.synametrics.com/sqlexpressremote.htm]. For open a connection using TCP/IP use a tuple of the servers IP and Port:
<syntaxhighlight lang="cpp">
QString connectString = "Driver={SQL Server};"; // Driver is now {SQL Server}
connectString.append("Server=10.1.1.15,5171;"); // IP,Port
connectString.append("Database=SQLDBSCHEMA;");  // Schema
connectString.append("Uid=SQLUSER;");          // User
connectString.append("Pwd=SQLPASS;");          // Pass
db.setDatabaseName(connectString);
if(db.open())
{
    ui->statusBar->showMessage("Connected");
}else{
    ui->statusBar->showMessage("Not Connected");
}
</syntaxhighlight>
 
[[Category:QtSql]]

Latest revision as of 13:23, 2 June 2015

Redirect to:

Retrieved from "https://wiki.qt.io/index.php?title=Odbc&oldid=17729"