Run this job to get the databaseVersionNumbers of ur system
static void databaseVersionNumbers()
{
#define.SQL_DBMS_NAME(17)
#define.SQL_DBMS_VER(18)
#define.SQL_DATABASE_NAME(16)
#define.SQL_DRIVER_ODBC_VER(77)
#define.SQL_DRIVER_VER(7)
#define.SQL_ODBC_VER(10)
Connection mainConnection = new Connection();
;
setPrefix("Information about database and ODBC version numbers.");
info(strFmt("Name of the database product: '%1",
mainConnection.odbcGetInfoStr(#SQL_DBMS_NAME)));
info(strFmt("Name of the database: '%1",
mainConnection.odbcGetInfoStr(#SQL_DATABASE_NAME)));
info(strFmt("Database version number: '%1",
mainConnection.odbcGetInfoStr(#SQL_DBMS_VER)));
info(strFmt("ODBC driver version: '%1",
mainConnection.odbcGetInfoStr(#SQL_DRIVER_VER)));
info(strFmt("ODBC Driver Manager version: '%1",
mainConnection.odbcGetInfoStr(#SQL_DRIVER_ODBC_VER)));
info(strFmt("ODBC API version: '%1",
mainConnection.odbcGetInfoStr(#SQL_ODBC_VER)));
}
Monday, June 02, 2008
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment