SQLGetInfo SQL_CONVERT_BIGINT support

"Byron Collins [DATACOM]" <[email protected]> Mon, 11 Jul 2011 18:04:36 +1200

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<9BAC443567932C429837071BCD1C709C04B862F915@DNZWGEX2.datacom.co.nz>

Hi,

Has anyone managed to build a version of freeTDS that supports SQL_CONVERT_BIGINT for SQLGetInfo?

We are getting the following error trying to connect to a MSSQL 2000 database from a redhat server running unixODBC/freeTDS 0.82

[ODBC][22215][SQLGetInfo.c][214]
                Entry:
                        Connection = 0x893f620
                        Info Type = SQL_CONVERT_BIGINT (53)
                        Info Value = 0xfffe6670
                        Buffer Length = 1028
                        StrLen = 0xfffe646e
[ODBC][22215][SQLGetInfo.c][528]
                Exit:[SQL_ERROR]
                DIAG [HY092] [FreeTDS][SQL Server]Option not supported




We've notice that there is a comment in odbc/odbc.c in the statics function _SQLGetInfo



/* TODO SQL_CONVERT_BIGINT SQL_CONVERT_GUID SQL_CONVERT_DATE SQL_CONVERT_TIME */



What would be involved in enabling the SQL_CONVERT_BIGINT option?



We're trying to get Cognos Data Manager working via UnixODBC/freeTDS with the catalog situated on a Sql Server 2000



select @@version

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

        May  3 2005 23:18:38

        Copyright (c) 1988-2003 Microsoft Corporation

        Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack





Cheers

Byron

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

FreeTDS_trace.log (application/octet-stream, 1.5 KB)

[ODBC][22215][SQLGetInfo.c][214]
                Entry:
                        Connection = 0x893f620
                        Info Type = SQL_CONVERT_BIGINT (53)
                        Info Value = 0xfffe6670
                        Buffer Length = 1028
                        StrLen = 0xfffe646e
[ODBC][22215][SQLGetInfo.c][528]
                Exit:[SQL_ERROR]
                DIAG [HY092] [FreeTDS][SQL Server]Option not supported

[ODBC][22215][SQLGetDiagRec.c][632]
                Entry:
                        Connection = 0x893f620
                        Rec Number = 1
                        SQLState = 0x89430d8
                        Native = 0xfffe61e8
                        Message Text = 0x8945210
                        Buffer Length = 512
                        Text Len Ptr = 0xfffe61ee
[ODBC][22215][SQLGetDiagRec.c][669]
                Exit:[SQL_SUCCESS]
                        SQLState = HY092
                        Native = 0xfffe61e8 -> 0
                        Message Text = [[FreeTDS][SQL Server]Option not supported]
[ODBC][22215][SQLGetDiagRec.c][632]
                Entry:
                        Connection = 0x893f620
                        Rec Number = 2
                        SQLState = 0x89430d8
                        Native = 0xfffe61e8
                        Message Text = 0x8945210
                        Buffer Length = 512
                        Text Len Ptr = 0xfffe61ee
[ODBC][22215][SQLGetDiagRec.c][669]
                Exit:[SQL_NO_DATA]