1 // sqlconnect,sqldisconnect and then again call sqlconnect.it should pass.
2 // connect to the DATA SOURCE with the connection string "DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;"
3 // see retrieving ODBC Diagnostics
12 //*************************************************************************
14 inline void checkrc(int rc
,int line
)
18 printf("ERROR %d at line %d\n",rc
,line
);
23 //*************************************************************************
31 SQLSMALLINT outstrlen
;
33 // Aloocate an environment handle
34 ret
=SQLAllocHandle(SQL_HANDLE_ENV
,SQL_NULL_HANDLE
,&env
);
35 checkrc(ret
,__LINE__
);
37 //we need odbc3 support
38 SQLSetEnvAttr(env
,SQL_ATTR_ODBC_VERSION
,(void*)SQL_OV_ODBC3
,0);
40 //ALLOCATE A Connection handle
41 ret
= SQLAllocHandle(SQL_HANDLE_DBC
,env
,&dbc
);
42 checkrc(ret
,__LINE__
);
43 //**************************************************************************************************
44 // connect to the DSN mydsn
45 ret
= SQLConnect (dbc
,
46 (SQLCHAR
*) "DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;", (SQLSMALLINT
) strlen ("DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;"),
48 (SQLSMALLINT
) strlen ("root"),
49 (SQLCHAR
*) "manager",
50 (SQLSMALLINT
) strlen (""));
53 if(SQL_SUCCEEDED(ret
))
55 printf("\nConnected to the Data Source successfully..\n");
60 printf("connection failed\n");
62 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
63 checkrc(ret
,__LINE__
);
65 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
66 checkrc(ret
,__LINE__
);
71 ret
= SQLDisconnect(dbc
);
72 checkrc(ret
,__LINE__
);
73 printf("Disconnected from the Datasource\n");
74 //**************************************************************************************************
80 ret
= SQLConnect (dbc
,
81 (SQLCHAR
*) "DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;", (SQLSMALLINT
) strlen ("DSN=mycsql;MODE=GATEWAY;SERVER=127.0.0.1;PORT=5678;"),
83 (SQLSMALLINT
) strlen ("root"),
84 (SQLCHAR
*) "manager",
85 (SQLSMALLINT
) strlen (""));
89 if(SQL_SUCCEEDED(ret
))
91 printf("Again Connected to the Data Source successfully..\n");
97 printf("connection failed\n");
99 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
100 checkrc(ret
,__LINE__
);
102 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
103 checkrc(ret
,__LINE__
);
108 ret
= SQLDisconnect(dbc
);
109 checkrc(ret
,__LINE__
);
111 //**************************************************************************************************
112 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
113 checkrc(ret
,__LINE__
);
115 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
116 checkrc(ret
,__LINE__
);
117 if(rettype
!=0)return 1;