FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2011/7/11 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
>

I think we support it but not claim to. Cfr however
http://technet.microsoft.com/en-us/library/ms131672%28SQL.100%29.aspx,
mssql 2008 does NOT support it.

freddy77