1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| #include <stdio.h> // for printf
#include <SQLAPI.h> // main SQLAPI++ header
#include <iostream>
using namespace std;
int main(int argc, char* argv[])
{
SAConnection con; // create connection object
try
{
// connect to database
// in this example it is Oracle,
// but can also be Sybase, Informix, DB2
// SQLServer, InterBase, SQLBase and ODBC
con.Connect(
"SQLEXPRESS\\MaDataBase.db", // database name
"sa", // user name
"azerty", // password
SA_SQLServer_Client);
cout << "Connected !" <<endl;
// Disconnect is optional
// autodisconnect will ocur in destructor if needed
con.Disconnect();
cout << "Disconnected !" <<endl;
}
catch(SAException &x)
{
// SAConnection::Rollback()
// can also throw an exception
// (if a network error for example),
// we will be ready
try
{
// on error rollback changes
con.Rollback();
}
catch(SAException &)
{
}
// print error message
printf("%s\n", (const char*)x.ErrText());
}
return 0;
} |
Partager