FreeTDS Development Group

["Byron Collins [DATACOM]" <Byron.Collins AT 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

Attachment: FreeTDS_trace.log
Description: FreeTDS_trace.log