1 // select from non-existing table it should fail
3 // AUTHOR : Jitendra lenka
11 inline void checkrc(int rc
, int line
)
15 printf("ERROR %d at line %d\n",rc
,line
);
19 //**********************************************************************************
28 SQLSMALLINT outstrlen
;
30 ret
= SQLAllocHandle(SQL_HANDLE_ENV
,SQL_NULL_HANDLE
,&env
);
31 checkrc(ret
,__LINE__
);
33 ret
= SQLSetEnvAttr(env
,SQL_ATTR_ODBC_VERSION
,(void*)SQL_OV_ODBC3
,0);
34 checkrc(ret
,__LINE__
);
36 ret
= SQLAllocHandle(SQL_HANDLE_DBC
,env
,&dbc
);
37 checkrc(ret
,__LINE__
);
39 ret
= SQLConnect (dbc
,
40 (SQLCHAR
*) "test", (SQLSMALLINT
) strlen ("test"),
42 (SQLSMALLINT
) strlen ("root"),
43 (SQLCHAR
*) "manager",
44 (SQLSMALLINT
) strlen (""));
46 if(SQL_SUCCEEDED(ret
))
48 printf("Connected to the data source successfully..\n");
54 printf("error in connection\n");
56 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
57 checkrc(ret
,__LINE__
);
59 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
60 checkrc(ret
,__LINE__
);
64 ret
= SQLAllocHandle(SQL_HANDLE_STMT
,dbc
,&stmt
);
65 checkrc(ret
,__LINE__
);
67 ret
= SQLPrepare(stmt
,(unsigned char*)"SELECT * FROM EMP",SQL_NTS
);
70 ret
= SQLExecute(stmt
);
72 if(ret
!= SQL_SUCCESS
&& ret
!= SQL_SUCCESS_WITH_INFO
)
73 printf("Could not SQL Execute\n");
78 ret
= SQLFreeHandle(SQL_HANDLE_STMT
,stmt
);
79 checkrc(ret
,__LINE__
);
81 ret
= SQLDisconnect(dbc
);
82 checkrc(ret
,__LINE__
);
84 ret
= SQLFreeHandle(SQL_HANDLE_DBC
,dbc
);
85 checkrc(ret
,__LINE__
);
87 ret
= SQLFreeHandle(SQL_HANDLE_ENV
,env
);
88 checkrc(ret
,__LINE__
);
91 printf("test script failed\n");
95 printf("Test script passed\n");