1 // Use Connection String "DSN=mycsql;MODE=ADAPTER;SERVER=127.0.0.1;PORT=5678;" for Connect Data Source
2 // SQLConnect, again call SQLConnect.
3 // second SQLConnect should return "connection name in use".
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__
);
44 // connect to the Data source
45 ret
= SQLConnect (dbc
,
46 (SQLCHAR
*) "DSN=mycsql;MODE=ADAPTER;SERVER=127.0.0.1;PORT=5678;", (SQLSMALLINT
) strlen ("DSN=mycsql;MODE=ADAPTER;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..\n");
62 printf("error in connection\n");
63 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
64 checkrc(ret
,__LINE__
);
66 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,env
);
67 checkrc(ret
,__LINE__
);
70 //*********************************************************************
71 //again call to driver connect
73 ret
= SQLConnect (dbc
,
74 (SQLCHAR
*) "DSN=mycsql;MODE=ADAPTER;SERVER=127.0.0.1;PORT=5678;", (SQLSMALLINT
) strlen ("DSN=mycsql;MODE=ADAPTER;SERVER=127.0.0.1;PORT=5678;"),
76 (SQLSMALLINT
) strlen ("root"),
77 (SQLCHAR
*) "manager",
78 (SQLSMALLINT
) strlen (""));
82 if(SQL_SUCCEEDED(ret
))
84 printf("\nConnected to the Data Source..\n");
92 printf("Connection name in use\n");
95 //**********************************************************************
96 ret
= SQLDisconnect(dbc
);
97 checkrc(ret
,__LINE__
);
99 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
100 checkrc(ret
,__LINE__
);
102 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
103 checkrc(ret
,__LINE__
);
104 if(rettype
==0)return 1;