#include <iostream>
#include <stdio.h>
using namespace std;
#define OTL_ODBC // Compile OTL 4.0/ODBC
#include <otlv4.h> // include the OTL 4.0 header file
otl_connect db; // connect object
void select()
{
otl_stream s;
s.set_all_column_types(otl_all_num2str|otl_all_date2str);
// map all numeric and date/time output columns to strings for simplicity.
s.open(100, // buffer size
"$SQLTables $1:'%' $2:'' $3:''",
// get a list of databases on the current connection's server.
db // connect object
);
otl_column_desc* desc;
int desc_len;
desc=s.describe_select(desc_len);
// describe the structure of the output columns of the result set.
int rpc=0;
while(!s.eof()){
++rpc;
char str[512];
cout<<"ROW#"<<rpc<<" ";
for(int col_num=0;col_num<desc_len;++col_num){
s>>str;
if(s.is_null())
cout<<desc[col_num].name<<"=NULL ";
else
cout<<desc[col_num].name<<"="<<str<<" ";
}
cout<<endl;
}
}
int main()
{
otl_connect::otl_initialize(); // initialize ODBC environment
try{
db.rlogon("scott/tiger@mssql"); // connect to ODBC
select(); // query the system data dictionary via ODBC functions.
}
catch(otl_exception& p){ // intercept OTL exceptions
cerr<<p.msg<<endl; // print out error message
cerr<<p.stm_text<<endl; // print out SQL that caused the error
cerr<<p.sqlstate<<endl; // print out SQLSTATE message
cerr<<p.var_info<<endl; // print out the variable that caused the error
}
db.logoff(); // disconnect from ODBC
return 0;
}Output
ROW#1 TABLE_CAT=DMS TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL
ROW#2 TABLE_CAT=master TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL
ROW#3 TABLE_CAT=msdb TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL
ROW#4 TABLE_CAT=Northwind TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL
ROW#5 TABLE_CAT=pubs TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULL
ROW#6 TABLE_CAT=tempdb TABLE_SCHEM=NULL TABLE_NAME=NULL TABLE_TYPE=NULL REMARKS=NULLExamples ContentsGo Home Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.com, skuchin@gmail.com
. Permission to use, copy, modify and redistribute this document
for any purpose is hereby granted without fee, provided that the above
copyright notice appear in all copies.