This example demonstrates how OTL/ODBC works with MS SQL Server's GUIDs. Briefly, GUIDs get mapped to C++ null terminated strings on both input and output. GUIDs are supported only by MS SQL Server 7.x and MS SQL Server 2000.
#include <iostream.h> #include <stdio.h>
#define OTL_ODBC // Compile OTL 4.0/ODBC #include <otlv4.h> // include the OTL 4.0 header file otl_connect db; // connect object void insert() // insert rows into table { otl_stream o(5, // buffer size "insert into test_tab values(:f1<int>,newid())", // SQL statement db // connect object ); for(int i=1;i<=13;++i) o<<i; } void select() { otl_stream i(5, // buffer size "select * from test_tab", // SELECT statement db // connect object ); // create select stream otl_stream o(7, // buffer size "insert into test_tab2 values(:f1<int>,:f2<char[37]>)", // INSERT statement db // connect object ); // create insert stream o.set_commit(0); // turnin off the otl_stream's autocommit flag int f1; char f2[37]; while(!i.eof()){ // while not end-of-data i>>f1>>f2; cout<<"f1="<<f1<<", f2="<<f2<<endl; o<<f1<<f2; } o.flush(); // flushing the otl_stream's buffer db.commit(); // committing transaction } int main() { otl_connect::otl_initialize(); // initialize ODBC environment try{ db.rlogon("UID=scott;PWD=tiger;DSN=mssql"); // connect to ODBC otl_cursor::direct_exec ( db, "drop table test_tab", otl_exception::disabled // disable OTL exceptions ); // drop table otl_cursor::direct_exec ( db, "create table test_tab(f1 int, f2 uniqueidentifier)" ); // create table otl_cursor::direct_exec ( db, "drop table test_tab2", otl_exception::disabled // disable OTL exceptions ); // drop table otl_cursor::direct_exec ( db, "create table test_tab2(f1 int, f2 uniqueidentifier)" ); // create table insert(); // insert records into table select(); // select records from test_tab and insert them into test_tab2 } 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; }
The actual GUID values will be different on each run of this example.
f1=1, f2=15B6CB56-F9CD-11D4-A633-86FF6E6A224E f1=2, f2=15B6CB57-F9CD-11D4-A633-86FF6E6A224E f1=3, f2=15B6CB58-F9CD-11D4-A633-86FF6E6A224E f1=4, f2=15B6CB59-F9CD-11D4-A633-86FF6E6A224E f1=5, f2=15B6CB5A-F9CD-11D4-A633-86FF6E6A224E f1=6, f2=15B6CB5B-F9CD-11D4-A633-86FF6E6A224E f1=7, f2=15B6CB5C-F9CD-11D4-A633-86FF6E6A224E f1=8, f2=15B6CB5D-F9CD-11D4-A633-86FF6E6A224E f1=9, f2=15B6CB5E-F9CD-11D4-A633-86FF6E6A224E f1=10, f2=15B6CB5F-F9CD-11D4-A633-86FF6E6A224E f1=11, f2=15B6CB60-F9CD-11D4-A633-86FF6E6A224E f1=12, f2=15B6CB61-F9CD-11D4-A633-86FF6E6A224E f1=13, f2=15B6CB62-F9CD-11D4-A633-86FF6E6A224E
Copyright © 1996, 2001, Sergei Kuchin, email: skuchin@sprynet.com, kuchin@hotmail.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.