Skip to Content.
Sympa Menu

freetds - [freetds] SQLGetInfo SQL_CONVERT_BIGINT support

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Byron Collins [DATACOM]" <Byron.Collins AT datacom.co.nz>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQLGetInfo SQL_CONVERT_BIGINT support
  • Date: Mon, 11 Jul 2011 18:04:36 +1200

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




Archive powered by MHonArc 2.6.24.

Top of Page