1 // sqlconnect,sqldisconnect and then again call sqlconnect.it should pass.
2 // see retrieving ODBC Diagnostics
4 // AUTHOR : Jitendra Lenka
13 //*************************************************************************
15 inline void checkrc(int rc
,int line
)
19 printf("ERROR %d at line %d\n",rc
,line
);
24 //*************************************************************************
32 SQLSMALLINT outstrlen
;
34 // Aloocate an environment handle
35 ret
=SQLAllocHandle(SQL_HANDLE_ENV
,SQL_NULL_HANDLE
,&env
);
36 checkrc(ret
,__LINE__
);
38 //we need odbc3 support
39 SQLSetEnvAttr(env
,SQL_ATTR_ODBC_VERSION
,(void*)SQL_OV_ODBC3
,0);
41 //ALLOCATE A Connection handle
42 ret
= SQLAllocHandle(SQL_HANDLE_DBC
,env
,&dbc
);
43 checkrc(ret
,__LINE__
);
44 //**************************************************************************************************
45 // connect to the DSN mydsn
46 ret
= SQLConnect (dbc
,
47 (SQLCHAR
*) "test", (SQLSMALLINT
) strlen ("test"),
49 (SQLSMALLINT
) strlen ("root"),
50 (SQLCHAR
*) "manager",
51 (SQLSMALLINT
) strlen (""));
54 if(SQL_SUCCEEDED(ret
))
56 printf("\nConnected to the Data Source successfully..\n");
61 printf("connection failed\n");
63 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
64 checkrc(ret
,__LINE__
);
66 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
67 checkrc(ret
,__LINE__
);
72 ret
= SQLDisconnect(dbc
);
73 checkrc(ret
,__LINE__
);
74 printf("Disconnected from the Datasource\n");
75 //**************************************************************************************************
81 ret
= SQLConnect (dbc
,
82 (SQLCHAR
*) "test", (SQLSMALLINT
) strlen ("test"),
84 (SQLSMALLINT
) strlen ("root"),
85 (SQLCHAR
*) "manager",
86 (SQLSMALLINT
) strlen (""));
90 if(SQL_SUCCEEDED(ret
))
92 printf("Again Connected to the Data Source successfully..\n");
98 printf("connection failed\n");
100 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
101 checkrc(ret
,__LINE__
);
103 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
104 checkrc(ret
,__LINE__
);
109 ret
= SQLDisconnect(dbc
);
110 checkrc(ret
,__LINE__
);
112 //**************************************************************************************************
113 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
114 checkrc(ret
,__LINE__
);
116 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
117 checkrc(ret
,__LINE__
);
118 if(rettype
!=0)return 1;