OTL 4.0, Examples for MS SQL / FreeTDS ODBC

The examples below work with MS SQL Server via FreeTDS ODBC in Linux/Unix, or even in Windows. In general, most of these examples should work with any MS SQL Server  7.0 and higher, when ODBC  is enabled in OTL by setting #define OTL_ODBC. For more examples, see the Generic ODBC examples.

  1. Example 502 (MS SQL Server stored procedure call)
  2. Example 503 (TIMESTAMP_STRUCT and MS SQL Server)
  3. Example 504 (MS SQL Server and TEXT column)
  4. Example 505 (MS SQL Server and IMAGE column)
  5. Example 506 (MS SQL Server: otl_stream::describe_select() and result sets)
  6. Example 507 (Datatype override in SELECT, MS SQL Server)
  7. Example 508 (Simple Insert/Select and otl_stream::clean() function for OTL/ODBC and MS SQL Server)
  8. Example 509 (STL std::strings, ANSI C++ typecasts, MS SQL Server)
  9. Example 510 (STL-compliant OTL/ODBC stream iterators, MS SQL Server)
  10. Example 511 (#define OTL_UNCAUGHT_EXCEPTION_ON, ODBC / MS SQL Server)
  11. Example 512 (#define OTL_EXTENDED_EXCEPTION, ODBC / MS SQL Server)
  12. Example 513 (OTL/ODBC and bulk operations with MS SQL Server's TEXT)
  13. Example 514 (Group data type override in SELECT, MS SQL Server)
  14. Example 515 (Describe otl_stream's bind variables for MS SQL Server)
  15. Example 516 (set_transaction_isolation_level, ODBC, MS SQL)
  16. Example 517 (external logon, ODBC, MS SQL)
  17. Example 518 (otl_stream::clean(), cancelling SELECT's fetch sequence, MS SQL Server)
  18. Example 519 (otl_stream::clean(), cancelling Result Set's fetch sequence, MS SQL Server)
  19. Example 520 (otl_stream::clean(), cleaning the SELECT stream's error flags, MS SQL Server )
  20. Example 521 (otl_stream::clean(), cleaning the Result Set stream's error flags, MS SQL Server )
  21. Example 522 (otl_datetime container with Datetime values down to milliseconds in MS SQL Server)
  22. Example 523 (otl_exception, derived from a base class, MS SQL Server)
  23. Example 524 (OTL_ADD_NULL_TERMINATOR_STRING_SIZE,MS SQL Server)
  24. Example 525 (std::string and TEXTs, MS SQL Server)
  25. Example 526 (SQL statement label, MS SQL Server)
  26. Example 527 (OTL/ODBC, accessing the system data dictionary via ODBC functions, MS SQL Server)
  27. Example 528 (OTL/ODBC, accessing the system data dictionary via ODBC functions, MS SQL Server)
  28. Example 529 (OTL/ODBC, accessing the system data dictionary via ODBC functions, MS SQL Server)
  29. Example 530 (64-bit integers (bigint), MS SQL Server, OTL/ODBC)
  30. Example 531 (user defined string class and TEXTs, MS SQL Server)
  31. Example 532 (OTL tracing, ODBC, MS SQL Server)
  32. Example 533 (Explict bind variables in SELECT statement column definitions, ODBC, MS SQL Server)
  33. Example 534 (#define OTL_THROWS_ON_SQL_SUCCESS_WITH_INFO, ODBC, MS SQL Server)
  34. Example 535 (OTL stream read iterator, simple SELECT, MS SQL / ODBC)
  35. Example 536 (OTL stream read iterator, implicit result set, MS SQL / ODBC)
  36. Example 537 (Strict numeric type checking on SELECTs)
  37. Example 538 (Stream buffer size as int, simple Insert/Select)
  38. Example 539 (OTL stream read iterator, "get by name" functions, MS SQL / ODBC)
  39. Example 540 (Simple Insert/Select, otl_connect::operator<<, <<=, >>)
  40. Example 541 (Simple Insert/Select with VARBINARY datatype)
  41. Example 542 (Simple Insert/Select with BINARY datatype)
  42. Example 543 (Simple Insert/Select with VARBINARY datatype and otl_stream_read_iterator)
  43. Example 544 (Simple Insert/Select with BINARY datatype and otl_stream_read_iterator)
  44. Example 545 (MS SQL Server 2005 and VARCHAR(MAX))
  45. Example 546 (MS SQL Server 2005, INSERT with OUTPUT clause)
  46. Example 667 (XML as varchar_long/otl_long_string on SELECT, and varchar_long/otl_long_string on INSERT)
  47. Example 668 (XML as varchar_long/std::string  on SELECT and varchar_long/std::string on INSERT)

Prev NextContentsGo Home


Copyright © 1996-2017, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.com .

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.