24#ifndef _freetds_config_h_
25#error should include config.h before
41#include <netinet/in.h>
48#include <sys/socket.h>
58#include <freetds/version.h>
59#include <freetds/sysdep_private.h>
60#include <freetds/sysdep_types.h>
61#include <freetds/thread.h>
62#include <freetds/bool.h>
63#include <freetds/macros.h>
64#include <freetds/utils/string.h>
65#include <freetds/replacements.h>
67#include <freetds/pushvis.h>
84 const char *freetds_version;
85 const char *sysconfdir;
86 const char *last_update;
124typedef char TDS_CHAR;
125typedef uint8_t TDS_UCHAR;
126typedef uint8_t TDS_TINYINT;
127typedef int16_t TDS_SMALLINT;
128typedef uint16_t TDS_USMALLINT;
129typedef int32_t TDS_INT;
130typedef uint32_t TDS_UINT;
131typedef int64_t TDS_INT8;
132typedef uint64_t TDS_UINT8;
133typedef tds_sysdep_real32_type TDS_REAL;
134typedef tds_sysdep_real64_type TDS_FLOAT;
136#include <freetds/proto.h>
138#define TDS_INVALID_TYPE ((TDS_SERVER_TYPE) 0)
149 TDS_USMALLINT time_prec:3;
150 TDS_USMALLINT _tds_reserved:10;
151 TDS_USMALLINT has_time:1;
152 TDS_USMALLINT has_date:1;
153 TDS_USMALLINT has_offset:1;
180#define TDS_NO_MORE_RESULTS ((TDSRET)1)
181#define TDS_SUCCESS ((TDSRET)0)
182#define TDS_FAIL ((TDSRET)-1)
183#define TDS_CANCELLED ((TDSRET)-2)
184#define TDS_FAILED(rc) ((rc)<0)
185#define TDS_SUCCEED(rc) ((rc)>=0)
186#define TDS_PROPAGATE(rc) \
187 do { TDSRET _tds_ret = (rc); if (TDS_FAILED(_tds_ret)) return _tds_ret; } while(0)
189#define TDS_INT_CONTINUE 1
190#define TDS_INT_CANCEL 2
191#define TDS_INT_TIMEOUT 3
194#define TDS_NO_COUNT -1
196#define TDS_ROW_RESULT 4040
197#define TDS_PARAM_RESULT 4042
198#define TDS_STATUS_RESULT 4043
199#define TDS_MSG_RESULT 4044
200#define TDS_COMPUTE_RESULT 4045
201#define TDS_CMD_DONE 4046
202#define TDS_CMD_SUCCEED 4047
203#define TDS_CMD_FAIL 4048
204#define TDS_ROWFMT_RESULT 4049
205#define TDS_COMPUTEFMT_RESULT 4050
206#define TDS_DESCRIBE_RESULT 4051
207#define TDS_DONE_RESULT 4052
208#define TDS_DONEPROC_RESULT 4053
209#define TDS_DONEINPROC_RESULT 4054
210#define TDS_OTHERS_RESULT 4055
212enum tds_token_results
214 TDS_TOKEN_RES_OTHERS,
215 TDS_TOKEN_RES_ROWFMT,
216 TDS_TOKEN_RES_COMPUTEFMT,
217 TDS_TOKEN_RES_PARAMFMT,
220 TDS_TOKEN_RES_COMPUTE,
226#define TDS_TOKEN_FLAG(flag) TDS_RETURN_##flag = (1 << (TDS_TOKEN_RES_##flag*2)), TDS_STOPAT_##flag = (2 << (TDS_TOKEN_RES_##flag*2))
231 TDS_TOKEN_FLAG(OTHERS),
232 TDS_TOKEN_FLAG(ROWFMT),
233 TDS_TOKEN_FLAG(COMPUTEFMT),
234 TDS_TOKEN_FLAG(PARAMFMT),
235 TDS_TOKEN_FLAG(DONE),
237 TDS_TOKEN_FLAG(COMPUTE),
238 TDS_TOKEN_FLAG(PROC),
241 TDS_TOKEN_RESULTS = TDS_RETURN_ROWFMT|TDS_RETURN_COMPUTEFMT|TDS_RETURN_DONE|TDS_STOPAT_ROW|TDS_STOPAT_COMPUTE|TDS_RETURN_PROC,
242 TDS_TOKEN_TRAILING = TDS_STOPAT_ROWFMT|TDS_STOPAT_COMPUTEFMT|TDS_STOPAT_ROW|TDS_STOPAT_COMPUTE|TDS_STOPAT_MSG|TDS_STOPAT_OTHERS
257 , TDS_DONE_EVENT = 0x40
261 , TDS_DONE_NO_TRAN = 0
262 , TDS_DONE_TRAN_SUCCEED = 1
263 , TDS_DONE_TRAN_PROGRESS= 2
264 , TDS_DONE_STMT_ABORT = 3
265 , TDS_DONE_TRAN_ABORT = 4
275typedef enum { TDSEOK = TDS_SUCCESS,
279 TDSEICONVAVAIL = 2401,
282 TDSEICONV2BIG = 2404,
283 TDSEPORTINSTANCE = 2500,
308 TDSEBPROBADTYP = 20250,
314 TDS_CUR_ISTAT_UNUSED = 0x00,
315 TDS_CUR_ISTAT_DECLARED = 0x01,
316 TDS_CUR_ISTAT_OPEN = 0x02,
317 TDS_CUR_ISTAT_CLOSED = 0x04,
318 TDS_CUR_ISTAT_RDONLY = 0x08,
319 TDS_CUR_ISTAT_UPDATABLE = 0x10,
320 TDS_CUR_ISTAT_ROWCNT = 0x20,
321 TDS_CUR_ISTAT_DEALLOC = 0x40
325#define TDS_NULLTERM -9
336typedef enum tds_encryption_level {
337 TDS_ENCRYPTION_DEFAULT,
339 TDS_ENCRYPTION_REQUEST,
340 TDS_ENCRYPTION_REQUIRE
341} TDS_ENCRYPTION_LEVEL;
348#define TDS_BYTE_SWAP16(value) \
349 (((((uint16_t)value)<<8) & 0xFF00u) | \
350 ((((uint16_t)value)>>8) & 0x00FFu))
352#define TDS_BYTE_SWAP32(value) \
353 (((((uint32_t)value)<<24) & 0xFF000000u)| \
354 ((((uint32_t)value)<< 8) & 0x00FF0000u)| \
355 ((((uint32_t)value)>> 8) & 0x0000FF00u)| \
356 ((((uint32_t)value)>>24) & 0x000000FFu))
358#define is_end_token(x) ((x) >= TDS_DONE_TOKEN && (x) <= TDS_DONEINPROC_TOKEN)
361 TDS_TYPEFLAG_INVALID = 0,
362 TDS_TYPEFLAG_NULLABLE = 1,
363 TDS_TYPEFLAG_FIXED = 2,
364 TDS_TYPEFLAG_VARIABLE = 4,
365 TDS_TYPEFLAG_COLLATE = 8,
366 TDS_TYPEFLAG_ASCII = 16,
367 TDS_TYPEFLAG_UNICODE = 32,
368 TDS_TYPEFLAG_BINARY = 64,
369 TDS_TYPEFLAG_DATETIME = 128,
370 TDS_TYPEFLAG_NUMERIC = 256,
371 TDS_TYPEFLAG_VARIANT = 512,
374extern const uint16_t tds_type_flags_ms[256];
376extern const uint16_t tds_type_flags_syb[256];
377extern const char *
const tds_type_names[256];
380#define is_fixed_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_FIXED) != 0)
381#define is_nullable_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_NULLABLE) != 0)
382#define is_variable_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_VARIABLE) != 0)
383#define is_variant_inner_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_VARIANT) != 0)
386#define is_blob_type(x) ((x)==SYBTEXT || (x)==SYBIMAGE || (x)==SYBNTEXT)
387#define is_blob_col(x) ((x)->column_varint_size > 2)
390#define is_numeric_type(x) ((x)==SYBNUMERIC || (x)==SYBDECIMAL)
392#define is_datetime_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_DATETIME) != 0)
393#define is_unicode_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_UNICODE) != 0)
394#define is_collate_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_COLLATE) != 0)
395#define is_ascii_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_ASCII) != 0)
396#define is_binary_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_BINARY) != 0)
397#define is_char_type(x) ((tds_type_flags_ms[x] & (TDS_TYPEFLAG_ASCII|TDS_TYPEFLAG_UNICODE)) != 0)
398#define is_similar_type(x, y) (is_char_type(x) && is_char_type(y))
400bool is_tds_type_valid(
int type)
402 return (
unsigned) type < 256u && tds_type_flags_ms[type] != 0;
406#define TDS_MAX_CAPABILITY 32
407#define MAXPRECISION 77
408#define TDS_MAX_CONN 4096
409#define TDS_MAX_DYNID_LEN 30
412#define TDS_DEF_SERVER "SYBASE"
413#define TDS_DEF_BLKSZ 512
414#define TDS_DEF_CHARSET "iso_1"
415#define TDS_DEF_LANG "us_english"
417#define TDS_DEFAULT_VERSION 0x500
418#define TDS_DEF_PORT 4000
420#define TDS_DEFAULT_VERSION 0x701
421#define TDS_DEF_PORT 1433
423#define TDS_DEFAULT_VERSION 0x702
424#define TDS_DEF_PORT 1433
426#define TDS_DEFAULT_VERSION 0x703
427#define TDS_DEF_PORT 1433
429#define TDS_DEFAULT_VERSION 0x704
430#define TDS_DEF_PORT 1433
432#define TDS_DEFAULT_VERSION 0x000
433#define TDS_DEF_PORT 1433
437#define TDS_STR_VERSION "tds version"
438#define TDS_STR_BLKSZ "initial block size"
439#define TDS_STR_SWAPDT "swap broken dates"
440#define TDS_STR_DUMPFILE "dump file"
441#define TDS_STR_DEBUGLVL "debug level"
442#define TDS_STR_DEBUGFLAGS "debug flags"
443#define TDS_STR_TIMEOUT "timeout"
444#define TDS_STR_QUERY_TIMEOUT "query timeout"
445#define TDS_STR_CONNTIMEOUT "connect timeout"
446#define TDS_STR_HOSTNAME "hostname"
447#define TDS_STR_HOST "host"
448#define TDS_STR_PORT "port"
449#define TDS_STR_TEXTSZ "text size"
451#define TDS_STR_EMUL_LE "emulate little endian"
452#define TDS_STR_CHARSET "charset"
453#define TDS_STR_CLCHARSET "client charset"
454#define TDS_STR_USE_UTF_16 "use utf-16"
455#define TDS_STR_LANGUAGE "language"
456#define TDS_STR_APPENDMODE "dump file append"
457#define TDS_STR_DATETIMEFMT "date format"
458#define TDS_STR_DATEFMT "date-only format"
459#define TDS_STR_TIMEFMT "time-only format"
460#define TDS_STR_INSTANCE "instance"
461#define TDS_STR_ASA_DATABASE "asa database"
462#define TDS_STR_DATABASE "database"
463#define TDS_STR_ENCRYPTION "encryption"
464#define TDS_STR_USENTLMV2 "use ntlmv2"
465#define TDS_STR_USELANMAN "use lanman"
467#define TDS_STR_ENCRYPTION_OFF "off"
468#define TDS_STR_ENCRYPTION_REQUEST "request"
469#define TDS_STR_ENCRYPTION_REQUIRE "require"
471#define TDS_GSSAPI_DELEGATION "enable gssapi delegation"
473#define TDS_STR_MUTUAL_AUTHENTICATION "mutual authentication"
475#define TDS_STR_REALM "realm"
477#define TDS_STR_SPN "spn"
479#define TDS_STR_CAFILE "ca file"
481#define TDS_STR_CRLFILE "crl file"
483#define TDS_STR_CHECKSSLHOSTNAME "check certificate hostname"
485#define TDS_STR_DBFILENAME "database filename"
487#define TDS_STR_READONLY_INTENT "read-only intent"
489#define TLS_STR_OPENSSL_CIPHERS "openssl ciphers"
491#define TDS_STR_ENABLE_TLS_V1 "enable tls v1"
502#define TDS_ALIGN_SIZE sizeof(tds_align_struct)
508 unsigned char values[TDS_MAX_CAPABILITY/2-2];
516#define TDS_MAX_LOGIN_STR_SZ 128
525 TDS_INT connect_timeout;
526 DSTR client_host_name;
527 DSTR server_host_name;
533 DSTR openssl_ciphers;
540 TDS_TINYINT encryption_level;
542 TDS_INT query_timeout;
552 DSTR routing_address;
553 uint16_t routing_port;
555 unsigned char option_flag2;
558 unsigned int suppress_language:1;
559 unsigned int gssapi_use_delegation:1;
560 unsigned int mutual_authentication:1;
561 unsigned int use_ntlmv2:1;
562 unsigned int use_ntlmv2_specified:1;
563 unsigned int use_lanman:1;
565 unsigned int use_utf16:1;
566 unsigned int use_new_password:1;
567 unsigned int valid_configuration:1;
568 unsigned int check_ssl_hostname:1;
569 unsigned int readonly_intent:1;
570 unsigned int enable_tls_v1:1;
571 unsigned int enable_tls_v1_specified:1;
572 unsigned int server_is_valid:1;
577 const char *qn_options;
578 const char *qn_msgtext;
586 char *server_charset;
599 TDS_CHAR textptr[16];
600 TDS_CHAR timestamp[8];
613 TDS_SERVER_TYPE type;
614 TDS_UCHAR collation[5];
625 unsigned char min_bytes_per_char;
626 unsigned char max_bytes_per_char;
641typedef TDS_INT tds_func_row_len(
TDSCOLUMN *col);
644typedef int tds_func_check(
const TDSCOLUMN *col);
648 tds_func_get_info *get_info;
649 tds_func_get_data *get_data;
650 tds_func_row_len *row_len;
667#if ENABLE_EXTRA_CHECKS
682 tds_func_check *check;
695 TDS_INT column_usertype;
696 TDS_INT column_flags;
720 DSTR table_column_name;
722 unsigned char *column_data;
723 void (*column_data_free)(
struct tds_column *column);
724 unsigned char column_nullable:1;
725 unsigned char column_writeable:1;
726 unsigned char column_identity:1;
727 unsigned char column_key:1;
728 unsigned char column_hidden:1;
729 unsigned char column_output:1;
730 unsigned char column_timestamp:1;
731 unsigned char column_computed:1;
732 TDS_UCHAR column_collation[5];
735 TDS_SMALLINT column_operand;
736 TDS_TINYINT column_operator;
744 TDS_SMALLINT column_bindtype;
745 TDS_SMALLINT column_bindfmt;
746 TDS_UINT column_bindlen;
747 TDS_SMALLINT *column_nullbind;
748 TDS_CHAR *column_varaddr;
749 TDS_INT *column_lenbind;
750 TDS_INT column_textpos;
751 TDS_INT column_text_sqlgetdatapos;
752 TDS_CHAR column_text_sqlputdatainfo;
753 unsigned char column_iconv_left;
754 char column_iconv_buf[9];
766 TDS_INT bcp_term_len;
767 TDS_CHAR *bcp_terminator;
776 TDS_USMALLINT num_cols;
777 TDS_USMALLINT computeid;
780 unsigned char *current_row;
784 TDS_SMALLINT *bycolumns;
785 TDS_USMALLINT by_cols;
802typedef enum tds_operations
807 TDS_OP_CURSOR = TDS_SP_CURSOR,
808 TDS_OP_CURSOROPEN = TDS_SP_CURSOROPEN,
809 TDS_OP_CURSORPREPARE = TDS_SP_CURSORPREPARE,
810 TDS_OP_CURSOREXECUTE = TDS_SP_CURSOREXECUTE,
811 TDS_OP_CURSORPREPEXEC = TDS_SP_CURSORPREPEXEC,
812 TDS_OP_CURSORUNPREPARE = TDS_SP_CURSORUNPREPARE,
813 TDS_OP_CURSORFETCH = TDS_SP_CURSORFETCH,
814 TDS_OP_CURSOROPTION = TDS_SP_CURSOROPTION,
815 TDS_OP_CURSORCLOSE = TDS_SP_CURSORCLOSE,
816 TDS_OP_EXECUTESQL = TDS_SP_EXECUTESQL,
817 TDS_OP_PREPARE = TDS_SP_PREPARE,
818 TDS_OP_EXECUTE = TDS_SP_EXECUTE,
819 TDS_OP_PREPEXEC = TDS_SP_PREPEXEC,
820 TDS_OP_PREPEXECRPC = TDS_SP_PREPEXECRPC,
821 TDS_OP_UNPREPARE = TDS_SP_UNPREPARE,
824 TDS_OP_DYN_DEALLOC = 100,
827#define TDS_DBG_LOGIN __FILE__, ((__LINE__ << 4) | 11)
828#define TDS_DBG_HEADER __FILE__, ((__LINE__ << 4) | 10)
829#define TDS_DBG_FUNC __FILE__, ((__LINE__ << 4) | 7)
830#define TDS_DBG_INFO2 __FILE__, ((__LINE__ << 4) | 6)
831#define TDS_DBG_INFO1 __FILE__, ((__LINE__ << 4) | 5)
832#define TDS_DBG_NETWORK __FILE__, ((__LINE__ << 4) | 4)
833#define TDS_DBG_WARN __FILE__, ((__LINE__ << 4) | 3)
834#define TDS_DBG_ERROR __FILE__, ((__LINE__ << 4) | 2)
835#define TDS_DBG_SEVERE __FILE__, ((__LINE__ << 4) | 1)
837#define TDS_DBGFLAG_FUNC 0x80
838#define TDS_DBGFLAG_INFO2 0x40
839#define TDS_DBGFLAG_INFO1 0x20
840#define TDS_DBGFLAG_NETWORK 0x10
841#define TDS_DBGFLAG_WARN 0x08
842#define TDS_DBGFLAG_ERROR 0x04
843#define TDS_DBGFLAG_SEVERE 0x02
844#define TDS_DBGFLAG_ALL 0xfff
845#define TDS_DBGFLAG_LOGIN 0x0800
846#define TDS_DBGFLAG_HEADER 0x0400
847#define TDS_DBGFLAG_PID 0x1000
848#define TDS_DBGFLAG_TIME 0x2000
849#define TDS_DBGFLAG_SOURCE 0x4000
850#define TDS_DBGFLAG_THREAD 0x8000
858enum TDS_DBG_LOG_STATE
860 TDS_DBG_LOGIN = (1 << 0)
862 , TDS_DBG_API = (1 << 1)
863 , TDS_DBG_ASYNC = (1 << 2)
864 , TDS_DBG_DIAG = (1 << 3)
865 , TDS_DBG_error = (1 << 4)
868 , TDS_DBG_PACKET = (1 << 5)
869 , TDS_DBG_LIBTDS = (1 << 6)
870 , TDS_DBG_CONFIG = (1 << 7)
871 , TDS_DBG_DEFAULT = 0xFE
889 TDS_TINYINT priv_msg_type;
890 TDS_TINYINT severity;
898 TDS_INT colnamelength;
903 TDS_CURSOR_STATE_UNACTIONED = 0
904 , TDS_CURSOR_STATE_REQUESTED = 1
905 , TDS_CURSOR_STATE_SENT = 2
906 , TDS_CURSOR_STATE_ACTIONED = 3
911 TDS_CURSOR_STATE declare;
912 TDS_CURSOR_STATE cursor_row;
913 TDS_CURSOR_STATE open;
914 TDS_CURSOR_STATE fetch;
915 TDS_CURSOR_STATE close;
916 TDS_CURSOR_STATE dealloc;
919typedef enum tds_cursor_operation
921 TDS_CURSOR_POSITION = 0,
922 TDS_CURSOR_UPDATE = 1,
923 TDS_CURSOR_DELETE = 2,
924 TDS_CURSOR_INSERT = 4
925} TDS_CURSOR_OPERATION;
927typedef enum tds_cursor_fetch
929 TDS_CURSOR_FETCH_NEXT = 1,
930 TDS_CURSOR_FETCH_PREV,
931 TDS_CURSOR_FETCH_FIRST,
932 TDS_CURSOR_FETCH_LAST,
933 TDS_CURSOR_FETCH_ABSOLUTE,
934 TDS_CURSOR_FETCH_RELATIVE
958 TDS_USMALLINT srv_status;
1018 TDS_MULTIPLE_EXECUTE,
1024 TDS_MULTIPLE_TYPE type;
1039 int (*int_handler) (
void *);
1040 bool money_use_2_digits;
1046 , client2server_chardata
1047 , initial_char_conv_count
1077 unsigned char buf[1];
1081#define tds_packet_zero_data_start(pkt) do { (pkt)->data_start = 0; } while(0)
1082#define tds_packet_get_data_start(pkt) ((pkt)->data_start)
1084#define tds_packet_zero_data_start(pkt) do { } while(0)
1085#define tds_packet_get_data_start(pkt) 0
1090 TDS_SYS_SOCKET s_signal, s_signaled;
1096 TDS_USMALLINT tds_version;
1118 int char_conv_count;
1121 TDS_UCHAR collation[5];
1122 TDS_UCHAR tds72_transaction[8];
1125 unsigned int use_iconv:1;
1126 unsigned int tds71rev1:1;
1128 unsigned int encrypt_single_packet:1;
1130 unsigned int mars:1;
1136 unsigned send_pos, recv_pos;
1138#define BUSY_SOCKET ((TDSSOCKET*)(TDS_UINTPTR)1)
1139#define TDSSOCKET_VALID(tds) (((TDS_UINTPTR)(tds)) > 1)
1141 unsigned num_sessions;
1145 unsigned num_cached_packets;
1165#if defined(HAVE_GNUTLS)
1166 void *tls_credentials;
1167#elif defined(HAVE_OPENSSL)
1257 TDS_UINT num_comp_info;
1270 TDS_INT query_timeout;
1277 void (*env_chg_func) (
TDSSOCKET * tds,
int type,
char *oldval,
char *newval);
1278 TDS_OPERATION current_op;
1284#define tds_get_ctx(tds) ((tds)->conn->tds_ctx)
1285#define tds_set_ctx(tds, val) do { ((tds)->conn->tds_ctx) = (val); } while(0)
1286#define tds_get_parent(tds) ((tds)->parent)
1287#define tds_set_parent(tds, val) do { ((tds)->parent) = (val); } while(0)
1288#define tds_get_s(tds) ((tds)->conn->s)
1289#define tds_set_s(tds, val) do { ((tds)->conn->s) = (val); } while(0)
1308typedef void (*TDSCONFPARSE) (
const char *option,
const char *value,
void *param);
1309bool tds_read_conf_section(FILE * in,
const char *section, TDSCONFPARSE tds_conf_parse,
void *parse_param);
1311void tds_parse_conf_section(
const char *option,
const char *value,
void *param);
1316TDSRET tds_lookup_host_set(
const char *servername,
struct addrinfo **addr);
1317const char *tds_addrinfo2str(
struct addrinfo *addr,
char *name,
int namemax);
1321extern const char STD_DATETIME_FMT[];
1322int tds_parse_boolean(
const char *value,
int default_value);
1323int tds_config_boolean(
const char *option,
const char *value,
TDSLOGIN * login);
1328BCPCOLDATA * tds_alloc_bcp_column_data(
unsigned int column_size);
1332TDS_SERVER_TYPE tds_get_cardinal_type(TDS_SERVER_TYPE datatype,
int usertype);
1336TDSRET tds_iconv_open(
TDSCONNECTION * conn,
const char *charset,
int use_utf16);
1338void tds_srv_charset_changed(
TDSCONNECTION * conn,
const char *charset);
1339void tds7_srv_charset_changed(
TDSCONNECTION * conn, TDS_UCHAR collate[5]);
1347void tds_free_all_results(
TDSSOCKET * tds);
1353void tds_release_cursor(
TDSCURSOR **pcursor);
1354void tds_free_bcp_column_data(
BCPCOLDATA * coldata);
1363void tds_release_cur_dyn(
TDSSOCKET * tds)
1370char *tds_alloc_client_sqlstate(
int msgno);
1371char *tds_alloc_lookup_sqlstate(
TDSSOCKET * tds,
int msgno);
1372TDSLOGIN *tds_alloc_login(
int use_environment);
1374void tds_free_login(
TDSLOGIN * login);
1378void tds_free_locale(
TDSLOCALE * locale);
1379TDSCURSOR * tds_alloc_cursor(
TDSSOCKET * tds,
const char *name, TDS_INT namelen,
const char *query, TDS_INT querylen);
1380void tds_free_row(
TDSRESULTINFO * res_info,
unsigned char *row);
1386#define TDS_RESIZE(p, n_elem) \
1387 tds_realloc((void **) &(p), sizeof(*(p)) * (size_t) (n_elem))
1388#define tds_new(type, n) ((type *) malloc(sizeof(type) * (n)))
1389#define tds_new0(type, n) ((type *) calloc(n, sizeof(type)))
1391TDSPACKET *tds_alloc_packet(
void *buf,
unsigned len);
1393void tds_free_packets(
TDSPACKET *packet);
1397void tds_deinit_tvp(
TDS_TVP *table);
1412void tds_set_version(
TDSLOGIN *
tds_login, TDS_TINYINT major_ver, TDS_TINYINT minor_ver);
1445void tds_convert_string_free(
const char *original,
const char *converted);
1446#if !ENABLE_EXTRA_CHECKS
1447#define tds_convert_string_free(original, converted) \
1448 do { if (original != converted) free((char*) converted); } while(0)
1455TDSRET tds_cursor_fetch(
TDSSOCKET * tds,
TDSCURSOR * cursor, TDS_CURSOR_FETCH fetch_type, TDS_INT i_row);
1456TDSRET tds_cursor_get_cursor_info(
TDSSOCKET * tds,
TDSCURSOR * cursor, TDS_UINT * row_number, TDS_UINT * row_count);
1473int tds5_send_optioncmd(
TDSSOCKET * tds, TDS_OPTION_CMD tds_command, TDS_OPTION tds_option,
TDS_OPTION_ARG * tds_argument,
1474 TDS_INT * tds_argsize);
1481#ifdef WORDS_BIGENDIAN
1482void tds_swap_datatype(
int coltype,
void *b);
1489extern const char tds_hex_digits[];
1494int tds_put_n(
TDSSOCKET * tds,
const void *buf,
size_t n);
1496int tds_put_int(
TDSSOCKET * tds, TDS_INT i);
1497int tds_put_int8(
TDSSOCKET * tds, TDS_INT8 i);
1498int tds_put_smallint(
TDSSOCKET * tds, TDS_SMALLINT si);
1500#define tds_put_tinyint(tds, ti) tds_put_byte(tds,ti)
1501int tds_put_byte(
TDSSOCKET * tds,
unsigned char c);
1503int tds_put_buf(
TDSSOCKET * tds,
const unsigned char *buf,
int dsize,
int ssize);
1511#define tds_get_smallint(tds) ((TDS_SMALLINT) tds_get_usmallint(tds))
1513#define tds_get_int(tds) ((TDS_INT) tds_get_uint(tds))
1515#define tds_get_int8(tds) ((TDS_INT8) tds_get_uint8(tds))
1526void tds_swap_bytes(
void *buf,
int bytes);
1527unsigned int tds_gettime_ms(
void);
1534 tds_thread_id thread_id;
1538int tdsdump_isopen(
void);
1539#include <freetds/popvis.h>
1541#include <freetds/pushvis.h>
1543void tdsdump_dump_buf(
const char* file,
unsigned int level_line,
const char *msg,
const void *buf,
size_t length);
1546void tdsdump_log(
const char* file,
unsigned int level_line,
const char *fmt, ...)
1547#if defined(__GNUC__) && __GNUC__ >= 2
1548#if defined(__MINGW32__)
1549 __attribute__ ((__format__ (ms_printf, 3, 4)))
1551 __attribute__ ((__format__ (__printf__, 3, 4)))
1555#define TDSDUMP_LOG_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_log
1556#define tdsdump_log TDSDUMP_LOG_FAST
1557#define TDSDUMP_BUF_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_dump_buf
1558#define tdsdump_dump_buf TDSDUMP_BUF_FAST
1561extern int tds_debug_flags;
1562extern int tds_g_append_mode;
1566TDSERRNO tds_open_socket(
TDSSOCKET * tds,
struct addrinfo *ipaddr,
unsigned int port,
int timeout,
int *p_oserr);
1570char *tds_prwsaerror(
int erc);
1571void tds_prwsaerror_free(
char *s);
1572int tds_connection_read(
TDSSOCKET * tds,
unsigned char *buf,
int buflen);
1573int tds_connection_write(
TDSSOCKET *tds,
const unsigned char *buf,
int buflen,
int final);
1574#define TDSSELREAD POLLIN
1575#define TDSSELWRITE POLLOUT
1580void tds_socket_flush(TDS_SYS_SOCKET sock);
1585static inline TDS_SYS_SOCKET tds_wakeup_get_fd(
const TDSPOLLWAKEUP *wakeup)
1587 return wakeup->s_signaled;
1593TDSRET tds_write_packet(
TDSSOCKET * tds,
unsigned char final);
1623 tds->
out_buf = pkt->buf + tds_packet_get_data_start(pkt);
1633#define TDS_START_LEN_GENERIC(tds_socket, len) do { \
1634 TDSFREEZE current_freeze[1]; \
1635 tds_freeze((tds_socket), current_freeze, (len)); do { do
1636#define TDS_END_LEN while(0); } while(tds_freeze_close(current_freeze), 0); } while(0);
1638#define TDS_START_LEN_TINYINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 1)
1639#define TDS_START_LEN_USMALLINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 2)
1640#define TDS_START_LEN_UINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 4)
1643TDSRET tds_vstrbuild(
char *buffer,
int buflen,
int *resultlen,
const char *text,
int textlen,
const char *formats,
int formatlen,
1648char *tds_money_to_string(
const TDS_MONEY * money,
char *s,
bool use_2_digits);
1650TDS_INT tds_numeric_change_prec_scale(
TDS_NUMERIC * numeric,
unsigned char new_prec,
unsigned char new_scale);
1654void tds_getmac(TDS_SYS_SOCKET s,
unsigned char mac[6]);
1668void tds_random_buffer(
unsigned char *out,
int len);
1674void tds5_negotiate_set_msg_type(
TDSAUTHENTICATION * tds_auth,
unsigned msg_type)
1677 tds_auth->msg_type = msg_type;
1688 TDS_BCP_QUERYOUT = 3
1695 TDS_SMALLINT offset;
1704 TDS_CHAR *insert_stmt;
1706 TDS_INT identity_insert_on;
1711 TDS_INT sybase_count;
1716typedef void (*tds_bcp_null_error) (
TDSBCPINFO *bulk,
int index,
int offset);
1723 const char *terminator,
size_t term_len,
char **outbuf,
size_t * outbytes);
1725TDSRET
tds_writetext_start(
TDSSOCKET *tds,
const char *objname,
const char *textptr,
const char *timestamp,
int with_log, TDS_UINT size);
1733 return (cap->values[
sizeof(cap->values)-1-(cap_num>>3)] >> (cap_num&7)) & 1;
1735#define tds_capability_has_req(conn, cap) \
1736 tds_capability_enabled(&conn->capabilities.types[0], cap)
1737#define tds_capability_has_res(conn, cap) \
1738 tds_capability_enabled(&conn->capabilities.types[1], cap)
1740#define IS_TDS42(x) (x->tds_version==0x402)
1741#define IS_TDS46(x) (x->tds_version==0x406)
1742#define IS_TDS50(x) (x->tds_version==0x500)
1743#define IS_TDS70(x) (x->tds_version==0x700)
1744#define IS_TDS71(x) (x->tds_version==0x701)
1745#define IS_TDS72(x) (x->tds_version==0x702)
1746#define IS_TDS73(x) (x->tds_version==0x703)
1748#define IS_TDS50_PLUS(x) ((x)->tds_version>=0x500)
1749#define IS_TDS7_PLUS(x) ((x)->tds_version>=0x700)
1750#define IS_TDS71_PLUS(x) ((x)->tds_version>=0x701)
1751#define IS_TDS72_PLUS(x) ((x)->tds_version>=0x702)
1752#define IS_TDS73_PLUS(x) ((x)->tds_version>=0x703)
1753#define IS_TDS74_PLUS(x) ((x)->tds_version>=0x704)
1755#define TDS_MAJOR(x) ((x)->tds_version >> 8)
1756#define TDS_MINOR(x) ((x)->tds_version & 0xff)
1758#define IS_TDSDEAD(x) (((x) == NULL) || (x)->state == TDS_DEAD)
1761#define TDS_IS_SYBASE(x) (!((x)->conn->product_version & 0x80000000u))
1763#define TDS_IS_MSSQL(x) (((x)->conn->product_version & 0x80000000u)!=0)
1768#define TDS_MS_VER(maj,min,x) (0x80000000u|((maj)<<24)|((min)<<16)|(x))
1772#define TDS_SYB_VER(maj,min,x) (((maj)<<24)|((min)<<16)|(x)<<8)
1781#include <freetds/popvis.h>
1783#define TDS_PUT_INT(tds,v) tds_put_int((tds), ((TDS_INT)(v)))
1784#define TDS_PUT_SMALLINT(tds,v) tds_put_smallint((tds), ((TDS_SMALLINT)(v)))
1785#define TDS_PUT_BYTE(tds,v) tds_put_byte((tds), ((unsigned char)(v)))
int tds_iconv_alloc(TDSCONNECTION *conn)
Allocate iconv stuff.
Definition iconv.c:311
TDS_SERVER_TYPE tds_get_conversion_type(TDS_SERVER_TYPE srctype, int colsize)
Return type suitable for conversions (convert all nullable types to fixed type)
Definition tds_types.h:125
char * tds_strndup(const void *s, TDS_INTPTR len)
Copy a string of length len to a new allocated buffer This function does not read more than len bytes...
Definition util.c:406
TDS_STATE tds_set_state(TDSSOCKET *tds, TDS_STATE state)
Set state of TDS connection, with logging and checking.
Definition util.c:58
struct tds_compiletime_settings TDS_COMPILETIME_SETTINGS
A structure to hold all the compile-time settings.
struct tds_result_info TDSRESULTINFO
Hold information for any results.
int tdsdump_open(const char *filename)
Create and truncate a human readable dump file for the TDS traffic.
Definition log.c:131
struct tds_variant TDSVARIANT
Store variant informations.
void tdsdump_close(void)
Close the TDS dump log file.
Definition log.c:212
void tds_set_column_type(TDSCONNECTION *conn, TDSCOLUMN *curcol, TDS_SERVER_TYPE type)
Set type of column initializing all dependency.
Definition data.c:224
bool tds_set_server(TDSLOGIN *tds_login, const char *server) TDS_WUR
Set the servername in a TDSLOGIN structure.
Definition login.c:129
struct tdsdaterec TDSDATEREC
Used by tds_datecrack.
TDSLOCALE * tds_get_locale(void)
Get locale information.
Definition locale.c:50
struct tds_env TDSENV
Current environment as reported by the server.
int tds_write_dump
Tell if TDS debug logging is turned on or off.
Definition log.c:58
struct tds_blob TDSBLOB
Information about blobs (e.g.
int tds_get_size_by_type(TDS_SERVER_TYPE servertype)
Return the number of bytes needed by specified type.
Definition tds_types.h:9
const int tds_numeric_bytes_per_prec[]
The following little table is indexed by precision and will tell us the number of bytes required to s...
Definition numeric.c:41
TDSRET tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start bulk copy to server.
Definition bulk.c:1081
TDS_INT tds_numeric_to_string(const TDS_NUMERIC *numeric, char *s)
Definition numeric.c:95
int tds_get_varint_size(TDSCONNECTION *conn, int datatype)
tds_get_varint_size() returns the size of a variable length integer returned in a result string
Definition tds_types.h:57
TDSRET tds_writetext_start(TDSSOCKET *tds, const char *objname, const char *textptr, const char *timestamp, int with_log, TDS_UINT size)
Start writing writetext request.
Definition bulk.c:1312
TDSRET tds_bcp_fread(TDSSOCKET *tds, TDSICONV *conv, FILE *stream, const char *terminator, size_t term_len, char **outbuf, size_t *outbytes)
Read a data file, passing the data through iconv().
Definition bulk.c:1242
TDSRET tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start sending BCP data to server.
Definition bulk.c:876
struct tds_dynamic TDSDYNAMIC
Holds information for a dynamic (also called prepared) query.
void tds_set_param_type(TDSCONNECTION *conn, TDSCOLUMN *curcol, TDS_SERVER_TYPE type)
Set type of column initializing all dependency.
Definition data.c:246
tds_states
values for tds->state
Definition tds.h:793
@ TDS_PENDING
cilent is waiting for data
Definition tds.h:797
@ TDS_SENDING
client would send data
Definition tds.h:796
@ TDS_READING
client is reading data
Definition tds.h:798
@ TDS_WRITING
client is writing data
Definition tds.h:795
@ TDS_IDLE
no data expected
Definition tds.h:794
@ TDS_DEAD
no connection
Definition tds.h:799
tds_end
Flags returned in TDS_DONE token.
Definition tds.h:249
@ TDS_DONE_CANCELLED
acknowledging an attention command (usually a cancel)
Definition tds.h:256
@ TDS_DONE_MORE_RESULTS
more results follow
Definition tds.h:251
@ TDS_DONE_SRVERROR
SQL server server error.
Definition tds.h:258
@ TDS_DONE_FINAL
final result set, command completed successfully.
Definition tds.h:250
@ TDS_DONE_ERROR
error occurred
Definition tds.h:252
@ TDS_DONE_INXACT
transaction in progress
Definition tds.h:253
@ TDS_DONE_PROC
results are from a stored procedure
Definition tds.h:254
@ TDS_DONE_COUNT
count field in packet is valid
Definition tds.h:255
void tdsdump_col(const TDSCOLUMN *col)
Write a column value to the debug log.
Definition log.c:455
TDSRET tds_writetext_continue(TDSSOCKET *tds, const TDS_UCHAR *text, TDS_UINT size)
Send some data in the writetext request started by tds_writetext_start.
Definition bulk.c:1350
int tdserror(const TDSCONTEXT *tds_ctx, TDSSOCKET *tds, int msgno, int errnum)
Call the client library's error handler (for library-generated errors only)
Definition util.c:321
enum tds_states TDS_STATE
values for tds->state
TDSRET tds_writetext_end(TDSSOCKET *tds)
Finish sending writetext data.
Definition bulk.c:1367
TDSRET tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Initialize BCP information.
Definition bulk.c:86
tds_bcp_directions
bcp direction
Definition tds.h:1685
TDSRET tds_bcp_send_record(TDSSOCKET *tds, TDSBCPINFO *bcpinfo, tds_bcp_get_col_data get_col_data, tds_bcp_null_error null_error, int offset)
Send one row of data to server.
Definition bulk.c:469
TDSRET tds_bcp_done(TDSSOCKET *tds, int *rows_copied)
Tell we finished sending BCP data to server.
Definition bulk.c:846
struct tds_encoding TDS_ENCODING
Information relevant to libiconv.
void tdsdump_off(TDSDUMP_OFF_ITEM *off_item)
Temporarily turn off logging for current thread.
Definition log.c:81
void tdsdump_on(TDSDUMP_OFF_ITEM *off_item)
Turn logging back on for current thread.
Definition log.c:101
struct tds_cursor TDSCURSOR
Holds informations about a cursor.
TDSAUTHENTICATION * tds_ntlm_get_auth(TDSSOCKET *tds)
Build a NTLMSPP packet to send to server.
Definition challenge.c:721
TDS_USMALLINT * tds_config_verstr(const char *tdsver, TDSLOGIN *login)
Set TDS version from given string.
Definition config.c:929
const TDS_COMPILETIME_SETTINGS * tds_get_compiletime_settings(void)
Return a structure capturing the compile-time settings provided to the configure script.
Definition config.c:1351
struct addrinfo * tds_lookup_host(const char *servername)
Get the IP address for a hostname.
Definition config.c:993
bool tds_read_conf_section(FILE *in, const char *section, TDSCONFPARSE tds_conf_parse, void *parse_param)
Read a section of configuration file (INI style file)
Definition config.c:503
bool tds_read_conf_file(TDSLOGIN *login, const char *server)
Read configuration info for given server return 0 on error.
Definition config.c:346
TDSRET tds_set_interfaces_file_loc(const char *interfloc)
Set the full name of interface file.
Definition config.c:967
char * tds_get_home_file(const char *file)
Return filename from HOME directory.
Definition config.c:325
TDSLOGIN * tds_read_config_info(TDSSOCKET *tds, TDSLOGIN *login, TDSLOCALE *locale)
tds_read_config_info() will fill the tds connection structure based on configuration information gath...
Definition config.c:138
void tds_fix_login(TDSLOGIN *login)
Fix configuration after reading it.
Definition config.c:285
TDSRET tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC *dr)
Convert from db date format to a structured date format.
Definition convert.c:3185
TDSICONV * tds_iconv_from_collate(TDSCONNECTION *conn, TDS_UCHAR collate[5])
Get iconv information from a LCID (to support different column encoding under MSSQL2K)
Definition iconv.c:1246
TDSRET tds_alloc_row(TDSRESULTINFO *res_info)
Allocate space for row store return NULL on out of memory.
Definition mem.c:533
void tds_detach_results(TDSRESULTINFO *info)
Detach result info from it current socket.
Definition mem.c:497
TDSPARAMINFO * tds_alloc_param_result(TDSPARAMINFO *old_param)
Adds a output parameter to TDSPARAMINFO.
Definition mem.c:284
void * tds_alloc_param_data(TDSCOLUMN *curparam)
Allocate data for a parameter.
Definition mem.c:373
TDSLOGIN * tds_init_login(TDSLOGIN *login, TDSLOCALE *locale)
Initialize login structure with locale information and other stuff for connection.
Definition mem.c:809
void tds_free_param_result(TDSPARAMINFO *param_info)
Delete latest parameter.
Definition mem.c:320
TDSDYNAMIC * tds_alloc_dynamic(TDSCONNECTION *conn, const char *id)
Allocate a dynamic statement.
Definition mem.c:160
void * tds_realloc(void **pp, size_t new_size)
Reallocate a pointer and update it if success.
Definition mem.c:1890
void tds_free_input_params(TDSDYNAMIC *dyn)
Frees all allocated input parameters of a dynamic statement.
Definition mem.c:206
void tds_release_dynamic(TDSDYNAMIC **dyn)
Frees dynamic statement.
Definition mem.c:253
int tds_needs_unprepare(TDSCONNECTION *conn, TDSDYNAMIC *dyn)
Check if dynamic request must be unprepared.
Definition query.c:1802
const char * tds_skip_quoted(const char *s)
Skip quoting string (like 'sfsf', "dflkdj" or [dfkjd])
Definition query.c:515
TDSRET tds71_submit_prepexec(TDSSOCKET *tds, const char *query, const char *id, TDSDYNAMIC **dyn_out, TDSPARAMINFO *params)
Creates a temporary stored procedure in the server and execute it.
Definition query.c:1451
void tds_start_query(TDSSOCKET *tds, unsigned char packet_type)
Start query packet of a given type.
Definition query.c:332
TDSRET tds_send_cancel(TDSSOCKET *tds)
tds_send_cancel() sends an empty packet (8 byte header only) tds_process_cancel should be called dire...
Definition query.c:2076
TDSRET tds_submit_execute(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Sends a previously prepared dynamic statement to the server.
Definition query.c:1680
size_t tds_fix_column_size(TDSSOCKET *tds, TDSCOLUMN *curcol)
Get column size for wire.
Definition query.c:1541
TDSRET tds_get_column_declaration(TDSSOCKET *tds, TDSCOLUMN *curcol, char *out)
Return declaration for column (like "varchar(20)").
Definition query.c:738
TDSRET tds_deferred_cursor_dealloc(TDSCONNECTION *conn, TDSCURSOR *cursor)
Deallocate cursor on idle.
Definition query.c:3104
TDSRET tds_submit_query(TDSSOCKET *tds, const char *query)
Sends a language string to the database server for processing.
Definition query.c:210
TDSRET tds_submit_rpc(TDSSOCKET *tds, const char *rpc_name, TDSPARAMINFO *params, TDSHEADERS *head)
Calls a RPC from server.
Definition query.c:1979
size_t tds_quote_id_rpc(TDSSOCKET *tds, char *buffer, const char *id, int idlen)
Quote an id for a RPC call.
Definition query.c:2263
size_t tds_quote_string(TDSSOCKET *tds, char *buffer, const char *str, int len)
Quote a string.
Definition query.c:2288
TDSRET tds_submit_prepare(TDSSOCKET *tds, const char *query, const char *id, TDSDYNAMIC **dyn_out, TDSPARAMINFO *params)
Creates a temporary stored procedure in the server.
Definition query.c:1174
TDSRET tds_submit_begin_tran(TDSSOCKET *tds)
Send a rollback request.
Definition query.c:3712
TDSRET tds_submit_commit(TDSSOCKET *tds, bool cont)
Send a commit request.
Definition query.c:3771
TDSRET tds_submit_rollback(TDSSOCKET *tds, bool cont)
Send a rollback request.
Definition query.c:3740
size_t tds_quote_id(TDSSOCKET *tds, char *buffer, const char *id, int idlen)
Quote an id.
Definition query.c:2218
const char * tds_next_placeholder(const char *start)
Get position of next placeholder.
Definition query.c:535
TDSRET tds_submit_query_params(TDSSOCKET *tds, const char *query, TDSPARAMINFO *params, TDSHEADERS *head)
Sends a language string to the database server for processing.
Definition query.c:350
TDSRET tds_deferred_unprepare(TDSCONNECTION *conn, TDSDYNAMIC *dyn)
Unprepare dynamic on idle.
Definition query.c:1824
int tds_count_placeholders(const char *query)
Count the number of placeholders ('?') in a query.
Definition query.c:571
TDSRET tds_cursor_dealloc(TDSSOCKET *tds, TDSCURSOR *cursor)
Send a deallocation request to server.
Definition query.c:3053
const char * tds_skip_comment(const char *s)
Skip a comment in a query.
Definition query.c:490
const char * tds_convert_string(TDSSOCKET *tds, TDSICONV *char_conv, const char *s, int len, size_t *out_len)
Convert a string in an allocated buffer.
Definition query.c:126
TDSRET tds_submit_queryf(TDSSOCKET *tds, const char *queryf,...)
Format and submit a query.
Definition query.c:467
TDSRET tds_submit_execdirect(TDSSOCKET *tds, const char *query, TDSPARAMINFO *params, TDSHEADERS *head)
Submit a prepared query with parameters.
Definition query.c:1306
void tds_set_cur_dyn(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Set current dynamic.
Definition query.c:192
TDSRET tds_submit_optioncmd(TDSSOCKET *tds, TDS_OPTION_CMD command, TDS_OPTION option, TDS_OPTION_ARG *param, TDS_INT param_size)
Send option commands to server.
Definition query.c:3436
TDSRET tds_submit_unprepare(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Send a unprepare request for a prepared query.
Definition query.c:1847
DSTR * tds_dstr_get(TDSSOCKET *tds, DSTR *s, size_t len)
Reads a string from wire and put in a DSTR.
Definition read.c:293
unsigned char tds_get_byte(TDSSOCKET *tds)
Return a single byte from the input buffer.
Definition read.c:72
int tds_put_string(TDSSOCKET *tds, const char *buf, int len)
Output a string to wire automatic translate string to unicode if needed.
Definition write.c:97
unsigned char tds_peek(TDSSOCKET *tds)
Reads a byte from the TDS stream without removing it.
Definition read.c:100
TDSRET tds_freeze_close_len(TDSFREEZE *freeze, int32_t size)
Stop keeping data for this specific freeze.
Definition packet.c:1031
int tds_goodwrite(TDSSOCKET *tds, const unsigned char *buffer, size_t buflen)
Definition net.c:985
int tds_socket_set_nonblocking(TDS_SYS_SOCKET sock)
Set socket to non-blocking.
Definition net.c:168
void tds_close_socket(TDSSOCKET *tds)
Close current socket.
Definition net.c:548
int tds_read_packet(TDSSOCKET *tds)
Read in one 'packet' from the server.
Definition packet.c:527
size_t tds_freeze_written(TDSFREEZE *freeze)
Compute how many bytes has been written from freeze.
Definition packet.c:935
TDSRET tds_flush_packet(TDSSOCKET *tds)
Flush packet to server.
Definition write.c:224
TDSRET tds_freeze_close(TDSFREEZE *freeze)
Stop keeping data for this specific freeze.
Definition packet.c:996
int tds_goodread(TDSSOCKET *tds, unsigned char *buf, int buflen)
Loops until we have received some characters return -1 on failure.
Definition net.c:914
TDSRET tds_freeze_abort(TDSFREEZE *freeze)
Discard all data written after the freeze.
Definition packet.c:961
TDS_UINT8 tds_get_uint8(TDSSOCKET *tds)
Get an uint64 from the server.
Definition read.c:140
TDSRET tds_get_char_data(TDSSOCKET *tds, char *dest, size_t wire_size, TDSCOLUMN *curcol)
Fetch character data the wire.
Definition read.c:195
size_t tds_get_string(TDSSOCKET *tds, size_t string_len, char *dest, size_t dest_size)
Fetch a string from the wire.
Definition read.c:166
int tds7_get_instance_ports(FILE *output, struct addrinfo *addr)
Get port of all instances.
Definition net.c:1091
TDS_UINT tds_get_uint(TDSSOCKET *tds)
Get an int32 from the server.
Definition read.c:127
int tds7_get_instance_port(struct addrinfo *addr, const char *instance)
Get port of given instance.
Definition net.c:1227
TDS_USMALLINT tds_get_usmallint(TDSSOCKET *tds)
Get an int16 from the server.
Definition read.c:113
void tds_unget_byte(TDSSOCKET *tds)
Unget will always work as long as you don't call it twice in a row.
Definition read.c:89
int tds_select(TDSSOCKET *tds, unsigned tds_sel, int timeout_seconds)
Select on a socket until it's available or the timeout expires.
Definition net.c:610
bool tds_get_n(TDSSOCKET *tds, void *dest, size_t n)
Get N bytes from the buffer and return them in the already allocated space given to us.
Definition read.c:230
const char * tds_prtype(int token)
Returns string representation of the given type.
Definition token.c:3032
TDSDYNAMIC * tds_lookup_dynamic(TDSCONNECTION *conn, const char *id)
Finds a dynamic given string id.
Definition token.c:2587
TDSRET tds_process_login_tokens(TDSSOCKET *tds)
tds_process_login_tokens() is called after sending the login packet to the server.
Definition token.c:411
TDSRET tds_process_tokens(TDSSOCKET *tds, TDS_INT *result_type, int *done_flags, unsigned flag)
process all streams.
Definition token.c:531
TDSRET tds_process_simple_query(TDSSOCKET *tds)
Process results for simple query as "SET TEXTSIZE" or "USE dbname" If the statement returns results,...
Definition token.c:881
TDSRET tds_process_cancel(TDSSOCKET *tds)
Definition token.c:2554
A structure to hold all the compile-time settings.
Definition tds.h:83
this structure is not directed connected to a TDS protocol but keeps any DATE/TIME information.
Definition tds.h:145
TDS_INT date
date, 0 = 1900-01-01
Definition tds.h:147
TDS_SMALLINT offset
time offset
Definition tds.h:148
TDS_UINT8 time
time, 7 digit precision
Definition tds.h:146
Used by tds_datecrack.
Definition tds.h:158
TDS_INT dayofyear
day of year (1-366)
Definition tds.h:163
TDS_INT weekday
day of week (0-6, 0 = sunday)
Definition tds.h:164
TDS_INT year
year
Definition tds.h:159
TDS_INT timezone
-840 - 840 minutes from UTC
Definition tds.h:169
TDS_INT minute
0-59
Definition tds.h:166
TDS_INT day
day of month (1-31)
Definition tds.h:162
TDS_INT decimicrosecond
0-9999999
Definition tds.h:168
TDS_INT second
0-59
Definition tds.h:167
TDS_INT quarter
quarter (0-3)
Definition tds.h:160
TDS_INT hour
0-23
Definition tds.h:165
TDS_INT month
month number (0-11)
Definition tds.h:161
DSTR crlfile
certificate revocation file
Definition tds.h:532
DSTR server_realm_name
server realm name (in freetds.conf)
Definition tds.h:528
DSTR user_name
account for login
Definition tds.h:535
DSTR password
password of account login
Definition tds.h:536
DSTR db_filename
database filename to attach (MSSQL)
Definition tds.h:530
DSTR server_name
server name (in freetds.conf)
Definition tds.h:519
struct addrinfo * ip_addrs
ip(s) of server
Definition tds.h:547
DSTR server_charset
charset of server e.g.
Definition tds.h:524
TDS_USMALLINT tds_version
TDS version.
Definition tds.h:521
DSTR new_password
new password to set (TDS 7.2+)
Definition tds.h:537
unsigned int bulk_copy
if bulk copy should be enabled
Definition tds.h:557
DSTR cafile
certificate authorities file
Definition tds.h:531
DSTR server_spn
server SPN (in freetds.conf)
Definition tds.h:529
int port
port of database service
Definition tds.h:520
Information about blobs (e.g.
Definition tds.h:597
Store variant informations.
Definition tds.h:608
Information relevant to libiconv.
Definition tds.h:622
const char * name
name of the encoding (ie UTF-8)
Definition tds.h:624
unsigned char canonic
internal numeric index into array of all encodings
Definition tds.h:628
tds_func_put_data * put_data
Send column data to server.
Definition tds.h:666
tds_func_put_info * put_info
Send metadata column information to server.
Definition tds.h:656
Metadata about columns in regular and compute rows.
Definition tds.h:693
TDS_INT bcp_prefix_len
The length, in bytes, of any length prefix this column may have.
Definition tds.h:765
TDS_TINYINT column_varint_size
size of length when reading from wire (0, 1, 2 or 4)
Definition tds.h:705
TDS_INT column_size
maximun size of data.
Definition tds.h:698
TDS_TINYINT column_prec
precision for decimal/numeric
Definition tds.h:707
TDS_SERVER_TYPE column_type
This type can be different from wire type because conversion (e.g.
Definition tds.h:700
TDSICONV * char_conv
refers to previously allocated iconv information
Definition tds.h:716
TDS_TINYINT column_scale
scale for decimal/numeric
Definition tds.h:708
TDS_INT column_cur_size
size written in variable (ie: char, text, binary).
Definition tds.h:740
Hold information for any results.
Definition tds.h:773
Holds informations about a cursor.
Definition tds.h:941
TDS_TINYINT options
read only|updatable TODO use it
Definition tds.h:946
bool defer_close
true if cursor was marker to be closed when connection is idle
Definition tds.h:950
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition tds.h:943
TDS_INT cursor_id
cursor id returned by the server after cursor declare
Definition tds.h:945
TDS_INT cursor_rows
< number of updatable columns
Definition tds.h:955
struct tds_cursor * next
next in linked list, keep first
Definition tds.h:942
TDS_INT type
row fetched from this cursor
Definition tds.h:960
TDS_CURSOR_STATUS status
cursor parameter
Definition tds.h:957
char * query
SQL query.
Definition tds.h:951
char * cursor_name
name of the cursor
Definition tds.h:944
Current environment as reported by the server.
Definition tds.h:967
char * charset
character set encoding
Definition tds.h:972
int block_size
packet size (512-65535)
Definition tds.h:969
char * database
database name
Definition tds.h:974
Holds information for a dynamic (also called prepared) query.
Definition tds.h:981
char * query
saved query, we need to know original query if prepare is impossible
Definition tds.h:1013
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition tds.h:983
bool defer_close
true if dynamic was marker to be closed when connection is idle
Definition tds.h:1001
TDSPARAMINFO * res_info
query results
Definition tds.h:1003
TDS_TINYINT emulated
this dynamic query cannot be prepared so libTDS have to construct a simple query.
Definition tds.h:997
TDSPARAMINFO * params
query parameters.
Definition tds.h:1011
struct tds_dynamic * next
next in linked list, keep first
Definition tds.h:982
TDS_INT num_id
numeric id for mssql7+
Definition tds.h:985
unsigned data_len
data length, this does not account SMP header, only TDS part
Definition tds.h:1075
TDSENV env
environment is shared between all sessions
Definition tds.h:1105
uint8_t unicharsize
Ratio between bytes allocated for a UNICHAR type and type length (Sybase).
Definition tds.h:1162
TDSCURSOR * cursors
linked list of cursors allocated for this connection contains only cursors allocated on the server
Definition tds.h:1111
TDS_SYS_SOCKET s
tcp socket, INVALID_SOCKET if not connected
Definition tds.h:1100
TDS_UINT product_version
version of product (Sybase/MS and full version)
Definition tds.h:1097
TDSDYNAMIC * dyns
list of dynamic allocated for this connection contains only dynamic allocated on the server
Definition tds.h:1116
unsigned int pending_close
true is connection has pending closing (cursors or dynamic)
Definition tds.h:1127
uint8_t ncharsize
Ratio between bytes allocated for a NCHAR type and type length (Sybase).
Definition tds.h:1155
Information for a server connection.
Definition tds.h:1180
TDSLOGIN * login
config for login stuff.
Definition tds.h:1275
unsigned in_len
input buffer length
Definition tds.h:1211
TDSPACKET * frozen_packets
list of packets frozen, points to first one.
Definition tds.h:1220
TDSPACKET * send_packet
packet we are preparing to send
Definition tds.h:1248
unsigned char * in_buf
Input buffer.
Definition tds.h:1194
TDS_INT ret_status
return status from store procedure
Definition tds.h:1267
unsigned out_pos
current position in out_buf
Definition tds.h:1210
TDSRESULTINFO * current_results
Current query information.
Definition tds.h:1255
unsigned char in_flag
input buffer type
Definition tds.h:1212
TDS_INT8 rows_affected
rows updated/deleted/inserted/selected, TDS_NO_COUNT if not valid
Definition tds.h:1271
unsigned char out_flag
output buffer type
Definition tds.h:1213
unsigned in_pos
current position in in_buf
Definition tds.h:1209
TDSCURSOR * cur_cursor
cursor in use
Definition tds.h:1260
bool in_row
true if we are getting rows
Definition tds.h:1263
bool bulk_query
true is query sent was a bulk query so we need to switch state to QUERYING
Definition tds.h:1261
bool has_status
true is ret_status is valid
Definition tds.h:1262
unsigned char * out_buf
Output buffer.
Definition tds.h:1202
volatile unsigned char in_cancel
indicate we are waiting a cancel reply; discard tokens till acknowledge; 1 mean we have to send cance...
Definition tds.h:1265
unsigned int out_buf_max
Maximum size of packet pointed by out_buf.
Definition tds.h:1208
TDSDYNAMIC * cur_dyn
dynamic structure in use
Definition tds.h:1273
TDSSOCKET * tds
which socket we refer to
Definition tds.h:1604
unsigned pkt_pos
position in pkt
Definition tds.h:1608
unsigned size_len
length size (0, 1, 2 or 4)
Definition tds.h:1610
TDSPACKET * pkt
first packet frozen
Definition tds.h:1606
Structure to hold a string.
Definition string.h:36