Skip to Content.
Sympa Menu

freetds - [freetds] tds version = 7.1 causes dbbind to find for me

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Norm Lastovica <lastovica AT sciinc.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] tds version = 7.1 causes dbbind to find for me
  • Date: Tue, 4 Oct 2016 12:26:42 +0000

OpenVMS IA64 V8.4. FREETDS-1_00_15. SQL Server 2014 - 12.0.4213.0.

When tds version = 7.0, everything is good. But when I set to 7.1 or later,
dbbind fails with (TDS Msg 20033, Level 7, "User attempted a dbbind with
mismatched column and variable types").

My sequence code is approximately this:

char tt[128] = {0};
strcpy (command_string, "SELECT SERVERPROPERTY ('productversion')");
EXECUTE_CHECK_ERC (dbcmd (dbproc, command_string), "dbcmd",
(char*)command_string);
EXECUTE_CHECK_ERC (dbsqlsend (dbproc), "dbsqlsend",
(char*)command_string);
EXECUTE_CHECK_ERC (dbsqlok (dbproc), "dbsqlok", (char*)command_string);

while ((erc = dbresults (dbproc)) != NO_MORE_RESULTS)
{
CHECK_ERC ("dbresults", command_string);
EXECUTE_CHECK_ERC (dbbind (dbproc, 1, NTBSTRINGBIND, sizeof(tt),
(BYTE *) &tt), "dbbind", command_string);
}

Is tds version 7.1 something that should be expected to work?

Norman Lastovica / SCI / +1.603.879.9022 x135 / www.sciinc.com





Archive powered by MHonArc 2.6.24.

Top of Page