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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
| #include <windows.h>
#include <sql.h>
#include <sqlext.h>
#include <cstdlib>
#include <iostream>
using namespace std;
int main(int argc, char *argv[])
{
SQLHENV env;
if ( !SQL_SUCCEEDED(SQLAllocHandle(SQL_HANDLE_ENV, NULL, &env)) )
cout<<"La fonction SQLAllocHandle a echoue (SQL_HANDLE_ENV)."<<endl;
else
{
if ( !SQL_SUCCEEDED(SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0)) )
cout<<"La fonction SQLSetEnvAttr a echoue."<<endl;
else
{
SQLHDBC con;
if ( !SQL_SUCCEEDED(SQLAllocHandle(SQL_HANDLE_DBC, env, &con)) )
cout<<"La fonction SQLAllocHandle a echoue (SQL_HANDLE_DBC)."<<endl;
else
{
SQLCHAR dsn[] = "musique_andalouse";
if ( !SQL_SUCCEEDED(SQLConnect(con, dsn, SQL_NTS, NULL, SQL_NTS, NULL, SQL_NTS)) )
cout<<"La fonction SQLConnect a echoue."<<endl;
else
{
SQLHSTMT stmt;
if ( !SQL_SUCCEEDED(SQLAllocHandle(SQL_HANDLE_STMT, con, &stmt)) )
cout<<"La fonction SQLAllocHandle a echoue (SQL_HANDLE_STMT)."<<endl;
else
{
SQLCHAR req[] = "SELECT * FROM NOUBAT;";
if ( !SQL_SUCCEEDED(SQLExecDirect(stmt, req, SQL_NTS)) )
fprintf(stderr, "La fonction SQLExecDirect a echoue.\n");
else
{
SQLSMALLINT nbcolumns;
SQLCHAR (*columns) [15];
SQLNumResultCols(stmt, &nbcolumns);
columns = malloc (nbcolumns * sizeof(columns[0]));
if (columns != NULL)
{
printf("TABLE : PAYS_TBL\n\n");
while (SQL_SUCCEEDED(SQLFetch(stmt)))
{
SQLSMALLINT i;
for(i = 0; i < nbcolumns; i++)
{
SQLGetData(stmt, i + 1, SQL_C_CHAR, columns[i], sizeof(columns[i]), NULL);
cout<<columns[i];
}
cout<<endl;;
}
free(columns);
}
}
SQLFreeHandle(SQL_HANDLE_STMT, stmt);
}
SQLDisconnect(con);
}
SQLFreeHandle(SQL_HANDLE_DBC, con);
}
}
SQLFreeHandle(SQL_HANDLE_ENV, env);
}
system("PAUSE");
return EXIT_SUCCESS;
} |
