[Firebird-odbc-devel] Two questions

[Carlos G.A. <car...@ho...>]

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