tds version = 7.1 causes dbbind to find for me
Norm Lastovica <[email protected]> Tue, 4 Oct 2016 12:26:42 +0000
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <BY1PR11MB04850A1FA575178CCE8E9D7ED0C50@BY1PR11MB0485.namprd11.prod.outlook.com> |
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