Hello:
Two things:
1. The SQLSetConnectOption isn´t in the list of supported functions of the
driver, to change this:
OdbcConnection.cpp ( line 70 ):
static const int supportedFunctions [] = {
// Deprecated but important stuff
SQL_API_SQLALLOCCONNECT,
SQL_API_SQLALLOCENV,
SQL_API_SQLALLOCSTMT,
SQL_API_SQLFREECONNECT,
SQL_API_SQLFREEENV,
SQL_API_SQLFREESTMT,
SQL_API_SQLCOLATTRIBUTES,
SQL_API_SQLERROR,
SQL_API_SQLSETPARAM,
SQL_API_SQLTRANSACT,
SQL_API_SQLSETCONNECTOPTION,
SQL_API_SQLENDTRAN,
SQL_API_SQLALLOCHANDLE,
SQL_API_SQLGETDESCFIELD,
SQL_API_SQLBINDCOL,
SQL_API_SQLGETDESCREC,
SQL_API_SQLCANCEL,
SQL_API_SQLGETDIAGFIELD,
SQL_API_SQLCLOSECURSOR,
SQL_API_SQLGETDIAGREC,
SQL_API_SQLCOLATTRIBUTE,
SQL_API_SQLGETENVATTR,
SQL_API_SQLCONNECT,
SQL_API_SQLGETFUNCTIONS,
SQL_API_SQLCOPYDESC,
SQL_API_SQLGETINFO,
SQL_API_SQLDATASOURCES,
SQL_API_SQLGETSTMTATTR,
SQL_API_SQLDESCRIBECOL,
SQL_API_SQLGETTYPEINFO,
SQL_API_SQLDISCONNECT,
SQL_API_SQLNUMRESULTCOLS,
SQL_API_SQLDRIVERS,
SQL_API_SQLPARAMDATA,
SQL_API_SQLENDTRAN,
SQL_API_SQLPREPARE,
SQL_API_SQLEXECDIRECT,
SQL_API_SQLPUTDATA,
SQL_API_SQLEXECUTE,
SQL_API_SQLROWCOUNT,
SQL_API_SQLFETCH,
SQL_API_SQLSETCONNECTATTR,
SQL_API_SQLFETCHSCROLL,
SQL_API_SQLSETCURSORNAME,
SQL_API_SQLFREEHANDLE,
SQL_API_SQLSETDESCFIELD,
SQL_API_SQLFREESTMT,
SQL_API_SQLSETDESCREC,
SQL_API_SQLGETCONNECTATTR,
SQL_API_SQLSETENVATTR,
SQL_API_SQLGETCURSORNAME,
SQL_API_SQLSETSTMTATTR,
SQL_API_SQLGETDATA,
// The following is a list of valid values for FunctionId for functions
conforming to the X/Open standards - compliance level,,
SQL_API_SQLCOLUMNS,
SQL_API_SQLSTATISTICS,
SQL_API_SQLSPECIALCOLUMNS,
SQL_API_SQLTABLES,
//The following is a list of valid values for FunctionId for functions
conforming to the ODBC standards - compliance level,,
SQL_API_SQLBINDPARAMETER,
SQL_API_SQLNATIVESQL,
SQL_API_SQLBROWSECONNECT,
SQL_API_SQLNUMPARAMS,
SQL_API_SQLBULKOPERATIONS,
SQL_API_SQLPRIMARYKEYS,
SQL_API_SQLCOLUMNPRIVILEGES,
SQL_API_SQLPROCEDURECOLUMNS,
SQL_API_SQLDESCRIBEPARAM,
SQL_API_SQLPROCEDURES,
SQL_API_SQLDRIVERCONNECT,
SQL_API_SQLSETPOS,
SQL_API_SQLFOREIGNKEYS,
SQL_API_SQLTABLEPRIVILEGES,
SQL_API_SQLMORERESULTS,
};
2. I have more modifications for the SQLGetTypeInfo function ( i send the
files ), with this modifications an application can create tables and make
selects with the information returned by this function.
Best Regards
Carlos Guzmán Álvarez
Vigo - España
_________________________________________________________________
Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com
|
