FreeTDS Development Group

[Alex Hornby <alex AT anvil.co.uk>]

Hi,

Here are few more stubbed out handlers - unixODBC seems to substitute in
sensible values for the empty strings.

I also changed info to report only DML as being available in
transactions. I think this is correct, as I'd be surprised if sybase or
sql server could roll back a create table statement!

Cheers,
Alex.

Index: src/odbc/odbc.c
===================================================================
RCS file: /cvsroot/freetds/freetds/src/odbc/odbc.c,v
retrieving revision 1.82
diff -u -r1.82 odbc.c
--- src/odbc/odbc.c     4 Nov 2002 19:49:19 -0000       1.82
+++ src/odbc/odbc.c     6 Nov 2002 12:04:28 -0000
@@ -2252,12 +2252,32 @@
         *uiInfoValue  = SQL_SCCO_READ_ONLY;
                break;
        case SQL_TXN_CAPABLE:
-               /* transaction for DML and DDL */
-               *siInfoValue = SQL_TC_ALL;
+               /* transaction for DML only */
+               *siInfoValue = SQL_TC_DML;
                break;
        case SQL_DEFAULT_TXN_ISOLATION:
                *uiInfoValue  = SQL_TXN_READ_COMMITTED;
                break;
+       case SQL_TXN_ISOLATION_OPTION:
+               *uiInfoValue  = (SQL_TXN_READ_UNCOMMITTED |
+                       SQL_TXN_READ_COMMITTED | SQL_TXN_REPEATABLE_READ |
+                       SQL_TXN_SERIALIZABLE);
+               break;
+       case SQL_KEYWORDS:
+               rgbInfoValue = "";
+               break;
+       case SQL_NUMERIC_FUNCTIONS:
+               rgbInfoValue = "";
+               break;
+       case SQL_TIMEDATE_FUNCTIONS:
+               rgbInfoValue = "";
+               break;
+       case SQL_STRING_FUNCTIONS:
+               rgbInfoValue = "";
+               break;
+       case SQL_SYSTEM_FUNCTIONS:
+               rgbInfoValue = "";
+               break;          
        /* TODO support for other options */
        default:
                /* error HYC00*/