git-svn-id: http://root.cern.ch/svn/root/trunk@17176 27541ba8-7e3a-0410-8455-c3a389f83636

1. Workaround for Oracle ODBC driver for Linux. Number of fetched rows is
not set,
   therefore one should calculate this number ourself.
2. TODBCServer::GetDrivers() and TODBCServer::GetDataSources() static
methods are implemented.
   They provide information about available configured ODBC drivers and data
sources respectively.
   Also PrintDrivers() and PrintDataSources() methods are implemented.
3. TODBCServer::ServerInfo() method is implemented. It nows returns server
name and version like:
     "Oracle 10.01.0030" or "MySQL 4.1.11"
   TMySQLServer::ServerInfo() modified to return info in form: "MySQL
4.1.11"
4. TODBCServer::GetTablesList() modified in respect of Oracle ODBC driver
functionality -
    wildcarding is now works correctly.


git-svn-id: http://root.cern.ch/svn/root/trunk@16517 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@16205 27541ba8-7e3a-0410-8455-c3a389f83636

1. Support for MySQL version 3.2.x and 4.0 enabled again. For that old MySQL versions TSQLStatement is not supported.
2. Small fix in TSQLFile. With old MySQL versions it does not try to use TSQLStatement class.
3. Enabling/disabling error output for TSQLStatement class.
4. Fix in error handling in TMySQLServer::Statement() method. Previousely error code was not correctly stored.


git-svn-id: http://root.cern.ch/svn/root/trunk@15538 27541ba8-7e3a-0410-8455-c3a389f83636

1. New methods of TSQLServer class (also for Oracle, MySQL, ODBC):
     Exec() - execute query which does not produce any result
     GetTablesList() - return list of tables names in data-base independent form
     IsTableExists() - check if table of given name exists
     GetTableInfo() - returns instance of TSQLTableInfo with list of columns.
2. New methods of TSQLStatement class (also for Oracle, MySQL, ODBC):
     IsNull() - checks, if field value is NULL
     SetNull() - sets parameter value to NULL


New TSQLTableInfo contains information about table and table columns.
For MySQL additional information like engine type, creation and last update time is provided


New TSQLColumnInfo class contains information about single column from SQL table
Has following methods:
   GetTypeName() - field type name in string form as it is reported by correspondent
          database method. Some databases providing full type name like "numeric(20)",
          other showing only "NUMERIC". As a result, one cannot use this string directly
          to create new field of similar types in other table
   IsNullable() - says if field value can be NULL or not
   GetSQLType() - returns kind of sql type. Possible values:
      TSQLServer::kSQL_NONE        data type unknown
      TSQLServer::kSQL_CHAR        CHAR(n) - string with fixed length n
      TSQLServer::kSQL_VARCHAR     VARCHAR(n) - string with variable length upto n
      TSQLServer::kSQL_INTEGER     INTEGER, INT, TINYINT - any integer types
      TSQLServer::kSQL_FLOAT       FLOAT - float value
      TSQLServer::kSQL_DOUBLE      DOUBLE - double precision value
      TSQLServer::kSQL_NUMERIC     NUMERIC(n,s), NUMBER(n,s) - numeric values with length and precion
      TSQLServer::kSQL_BINARY      BLOB, VARBINARY  - binary data (vriable or fixed size)
      TSQLServer::kSQL_TIMESTAMP   TIMESTAMP - time and date stamp
   GetSize() - size of field in database. -1 if not known.
   GetLength() - length argument in type declaration like CHAR(len) or NUMERIC(len), -1 if not defined
   GetScale() - second argument in declarations like NUMERIC(len, s), -1 if not defined
   GetSigned() - is type signed(==1) or unsigned(==0), -1 if not defined


git-svn-id: http://root.cern.ch/svn/root/trunk@15305 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@15136 27541ba8-7e3a-0410-8455-c3a389f83636

1. Error handling is introduced. Now TSQLServer/TSQLStatement returns error code - GetErrorCode()
   and message - GetErrorMsg() of last operation.
   If desired, error output can be suppressed for TSQLServer. Correspondent changes done in implementation
   for Oracle, MySQL, ODBC
2. New methods of TSQLServer class for transactions control: StartTransaction() / Commit() / Rollback().
   As desfault implmenetaion in TSQLServer class they corresopnd to SQL "START TRANSACTION", "COMMIT", "ROLLBACK" queries.
   For Oracle, MySQL and ODBC specific implmentaion were done while there special methods should be called.
3. Some other new methods of TSQLServer class:
     IsSupportStatement() - return kTRUE if plugin has TSQLStatement implementation
     GetMaxIdentifierLength() - return maximum allowed length of identifiers
4. Bugfix in TODBCRow class


git-svn-id: http://root.cern.ch/svn/root/trunk@15124 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@15091 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@15062 27541ba8-7e3a-0410-8455-c3a389f83636

use correct SQL(U)LEN instead of SQL(U)INTEGER.


git-svn-id: http://root.cern.ch/svn/root/trunk@14818 27541ba8-7e3a-0410-8455-c3a389f83636

git-svn-id: http://root.cern.ch/svn/root/trunk@14728 27541ba8-7e3a-0410-8455-c3a389f83636

ODBC driver that allows generic access to many DB's. This version should
also compile on Win32 for access to MS DB's (Access, SQLServer). For this
driver to compile one needs either to install unixiODBC (unixodbc.org)
or iODBC (iodbc.org). [One Mac OS X it compiles fine with the system
installed iODBC libraries - Fons].


git-svn-id: http://root.cern.ch/svn/root/trunk@14715 27541ba8-7e3a-0410-8455-c3a389f83636