FreeTDS API
tds.h
Go to the documentation of this file.
1 /* FreeTDS - Library of routines accessing Sybase and Microsoft databases
2  * Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005 Brian Bruns
3  * Copyright (C) 2010, 2011 Frediano Ziglio
4  *
5  * This library is free software; you can redistribute it and/or
6  * modify it under the terms of the GNU Library General Public
7  * License as published by the Free Software Foundation; either
8  * version 2 of the License, or (at your option) any later version.
9  *
10  * This library is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13  * Library General Public License for more details.
14  *
15  * You should have received a copy of the GNU Library General Public
16  * License along with this library; if not, write to the
17  * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
18  * Boston, MA 02111-1307, USA.
19  */
20 
21 #ifndef _tds_h_
22 #define _tds_h_
23 
24 #ifndef _freetds_config_h_
25 #error should include config.h before
26 #endif
27 
28 #include <stdarg.h>
29 #include <stdio.h>
30 #include <time.h>
31 
32 #ifdef HAVE_STDDEF_H
33 #include <stddef.h>
34 #endif
35 
36 #if HAVE_NETDB_H
37 #include <netdb.h>
38 #endif /* HAVE_NETDB_H */
39 
40 #if HAVE_NETINET_IN_H
41 #include <netinet/in.h>
42 #endif /* HAVE_NET_INET_IN_H */
43 #if HAVE_ARPA_INET_H
44 #include <arpa/inet.h>
45 #endif /* HAVE_ARPA_INET_H */
46 
47 #if HAVE_SYS_SOCKET_H
48 #include <sys/socket.h>
49 #endif /* HAVE_SYS_SOCKET_H */
50 
51 /* forward declaration */
52 typedef struct tdsiconvinfo TDSICONV;
53 typedef struct tds_connection TDSCONNECTION;
54 typedef struct tds_socket TDSSOCKET;
55 typedef struct tds_column TDSCOLUMN;
56 typedef struct tds_bcpinfo TDSBCPINFO;
57 
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>
66 
67 #include <freetds/pushvis.h>
68 
69 #ifdef __cplusplus
70 extern "C"
71 {
72 #if 0
73 }
74 #endif
75 #endif
76 
83 {
84  const char *freetds_version; /* release version of FreeTDS */
85  const char *sysconfdir; /* location of freetds.conf */
86  const char *last_update; /* latest software_version date among the modules */
87  const char *tdsver; /* TDS protocol version (4.2/4.6/5.0/7.0/7.1) 5.0 */
88  bool msdblib; /* for MS style dblib */
89  bool sybase_compat; /* enable increased Open Client binary compatibility */
90  bool threadsafe; /* compile for thread safety default=no */
91  bool libiconv; /* search for libiconv in DIR/include and DIR/lib */
92  bool iodbc; /* build odbc driver against iODBC in DIR */
93  bool unixodbc; /* build odbc driver against unixODBC in DIR */
94  bool openssl; /* build against OpenSSL */
95  bool gnutls; /* build against GnuTLS */
96  bool mars; /* MARS enabled */
97  bool sspi; /* SSPI enabled */
98  bool kerberos; /* Kerberos enabled */
100 
116 /*
117  * All references to data that touch the wire should use the following typedefs.
118  *
119  * If you have problems on 64-bit machines and the code is
120  * using a native datatype, please change it to use
121  * these. (In the TDS layer only, the API layers have their
122  * own typedefs which equate to these).
123  */
124 typedef char TDS_CHAR; /* 8-bit char */
125 typedef uint8_t TDS_UCHAR; /* 8-bit uchar */
126 typedef uint8_t TDS_TINYINT; /* 8-bit unsigned */
127 typedef int16_t TDS_SMALLINT; /* 16-bit int */
128 typedef uint16_t TDS_USMALLINT; /* 16-bit unsigned */
129 typedef int32_t TDS_INT; /* 32-bit int */
130 typedef uint32_t TDS_UINT; /* 32-bit unsigned */
131 typedef int64_t TDS_INT8; /* 64-bit integer */
132 typedef uint64_t TDS_UINT8; /* 64-bit unsigned */
133 typedef tds_sysdep_real32_type TDS_REAL; /* 32-bit real */
134 typedef tds_sysdep_real64_type TDS_FLOAT; /* 64-bit real */
135 
136 #include <freetds/proto.h>
137 
138 #define TDS_INVALID_TYPE ((TDS_SERVER_TYPE) 0)
139 
144 typedef struct
145 {
146  TDS_UINT8 time;
147  TDS_INT date;
148  TDS_SMALLINT offset;
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;
155 
157 typedef struct tdsdaterec
158 {
159  TDS_INT year;
160  TDS_INT quarter;
161  TDS_INT month;
162  TDS_INT day;
163  TDS_INT dayofyear;
164  TDS_INT weekday;
165  TDS_INT hour;
166  TDS_INT minute;
167  TDS_INT second;
168  TDS_INT decimicrosecond;
169  TDS_INT timezone;
171 
177 extern const int tds_numeric_bytes_per_prec[];
178 
179 typedef int TDSRET;
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)
188 
189 #define TDS_INT_CONTINUE 1
190 #define TDS_INT_CANCEL 2
191 #define TDS_INT_TIMEOUT 3
192 
193 
194 #define TDS_NO_COUNT -1
195 
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
211 
212 enum tds_token_results
213 {
214  TDS_TOKEN_RES_OTHERS,
215  TDS_TOKEN_RES_ROWFMT,
216  TDS_TOKEN_RES_COMPUTEFMT,
217  TDS_TOKEN_RES_PARAMFMT,
218  TDS_TOKEN_RES_DONE,
219  TDS_TOKEN_RES_ROW,
220  TDS_TOKEN_RES_COMPUTE,
221  TDS_TOKEN_RES_PROC,
222  TDS_TOKEN_RES_MSG,
223  TDS_TOKEN_RES_ENV,
224 };
225 
226 #define TDS_TOKEN_FLAG(flag) TDS_RETURN_##flag = (1 << (TDS_TOKEN_RES_##flag*2)), TDS_STOPAT_##flag = (2 << (TDS_TOKEN_RES_##flag*2))
227 
228 enum tds_token_flags
229 {
230  TDS_HANDLE_ALL = 0,
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),
236  TDS_TOKEN_FLAG(ROW),
237  TDS_TOKEN_FLAG(COMPUTE),
238  TDS_TOKEN_FLAG(PROC),
239  TDS_TOKEN_FLAG(MSG),
240  TDS_TOKEN_FLAG(ENV),
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
243 };
244 
249 {
250  TDS_DONE_FINAL = 0x00
252  , TDS_DONE_ERROR = 0x02
253  , TDS_DONE_INXACT = 0x04
254  , TDS_DONE_PROC = 0x08
255  , TDS_DONE_COUNT = 0x10
257  , TDS_DONE_EVENT = 0x40 /* part of an event notification. */
258  , TDS_DONE_SRVERROR = 0x100
260  /* after the above flags, a TDS_DONE packet has a field describing the state of the transaction */
261  , TDS_DONE_NO_TRAN = 0 /* No transaction in effect */
262  , TDS_DONE_TRAN_SUCCEED = 1 /* Transaction completed successfully */
263  , TDS_DONE_TRAN_PROGRESS= 2 /* Transaction in progress */
264  , TDS_DONE_STMT_ABORT = 3 /* A statement aborted */
265  , TDS_DONE_TRAN_ABORT = 4 /* Transaction aborted */
266 };
267 
268 
269 /*
270  * TDSERRNO is emitted by libtds to the client library's error handler
271  * (which may in turn call the client's error handler).
272  * These match the db-lib msgno, because the same values have the same meaning
273  * in db-lib and ODBC. ct-lib maps them to ct-lib numbers (todo).
274  */
275 typedef enum { TDSEOK = TDS_SUCCESS,
276  TDSEVERDOWN = 100,
277  TDSEINPROGRESS,
278  TDSEICONVIU = 2400,
279  TDSEICONVAVAIL = 2401,
280  TDSEICONVO = 2402,
281  TDSEICONVI = 2403,
282  TDSEICONV2BIG = 2404,
283  TDSEPORTINSTANCE = 2500,
284  TDSESYNC = 20001,
285  TDSEFCON = 20002,
286  TDSETIME = 20003,
287  TDSEREAD = 20004,
288  TDSEWRIT = 20006,
289  TDSESOCK = 20008,
290  TDSECONN = 20009,
291  TDSEMEM = 20010,
292  TDSEINTF = 20012, /* Server name not found in interface file */
293  TDSEUHST = 20013, /* Unknown host machine name. */
294  TDSEPWD = 20014,
295  TDSESEOF = 20017,
296  TDSERPND = 20019,
297  TDSEBTOK = 20020,
298  TDSEOOB = 20022,
299  TDSECLOS = 20056,
300  TDSEUSCT = 20058,
301  TDSEUTDS = 20146,
302  TDSEEUNR = 20185,
303  TDSECAP = 20203,
304  TDSENEG = 20210,
305  TDSEUMSG = 20212,
306  TDSECAPTYP = 20213,
307  TDSECONF = 20214,
308  TDSEBPROBADTYP = 20250,
309  TDSECLOSEIN = 20292
310 } TDSERRNO;
311 
312 
313 enum {
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
322 };
323 
324 /* string types */
325 #define TDS_NULLTERM -9
326 
327 
328 typedef union tds_option_arg
329 {
330  TDS_TINYINT ti;
331  TDS_INT i;
332  TDS_CHAR *c;
334 
335 
336 typedef enum tds_encryption_level {
337  TDS_ENCRYPTION_DEFAULT,
338  TDS_ENCRYPTION_OFF,
339  TDS_ENCRYPTION_REQUEST,
340  TDS_ENCRYPTION_REQUIRE
341 } TDS_ENCRYPTION_LEVEL;
342 
343 /*
344  * TODO use system macros for optimization
345  * See mcrypt for reference and linux kernel source for optimization
346  * check if unaligned access and use fast write/read when implemented
347  */
348 #define TDS_BYTE_SWAP16(value) \
349  (((((uint16_t)value)<<8) & 0xFF00u) | \
350  ((((uint16_t)value)>>8) & 0x00FFu))
351 
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))
357 
358 #define is_end_token(x) ((x) >= TDS_DONE_TOKEN && (x) <= TDS_DONEINPROC_TOKEN)
359 
360 enum {
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,
372 };
373 
374 extern const uint16_t tds_type_flags_ms[256];
375 #if 0
376 extern const uint16_t tds_type_flags_syb[256];
377 extern const char *const tds_type_names[256];
378 #endif
379 
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)
384 
385 
386 #define is_blob_type(x) ((x)==SYBTEXT || (x)==SYBIMAGE || (x)==SYBNTEXT)
387 #define is_blob_col(x) ((x)->column_varint_size > 2)
388 /* large type means it has a two byte size field */
389 /* define is_large_type(x) (x>128) */
390 #define is_numeric_type(x) ((x)==SYBNUMERIC || (x)==SYBDECIMAL)
391 
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))
399 static inline
400 bool is_tds_type_valid(int type)
401 {
402  return (unsigned) type < 256u && tds_type_flags_ms[type] != 0;
403 }
404 
405 
406 #define TDS_MAX_CAPABILITY 32
407 #define MAXPRECISION 77
408 #define TDS_MAX_CONN 4096
409 #define TDS_MAX_DYNID_LEN 30
410 
411 /* defaults to use if no others are found */
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"
416 #if TDS50
417 #define TDS_DEFAULT_VERSION 0x500
418 #define TDS_DEF_PORT 4000
419 #elif TDS71
420 #define TDS_DEFAULT_VERSION 0x701
421 #define TDS_DEF_PORT 1433
422 #elif TDS72
423 #define TDS_DEFAULT_VERSION 0x702
424 #define TDS_DEF_PORT 1433
425 #elif TDS73
426 #define TDS_DEFAULT_VERSION 0x703
427 #define TDS_DEF_PORT 1433
428 #elif TDS74
429 #define TDS_DEFAULT_VERSION 0x704
430 #define TDS_DEF_PORT 1433
431 #else
432 #define TDS_DEFAULT_VERSION 0x000
433 #define TDS_DEF_PORT 1433
434 #endif
435 
436 /* normalized strings from freetds.conf file */
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"
450 /* for big endian hosts, obsolete, ignored */
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_DATEFMT "date format"
458 #define TDS_STR_INSTANCE "instance"
459 #define TDS_STR_ASA_DATABASE "asa database"
460 #define TDS_STR_DATABASE "database"
461 #define TDS_STR_ENCRYPTION "encryption"
462 #define TDS_STR_USENTLMV2 "use ntlmv2"
463 #define TDS_STR_USELANMAN "use lanman"
464 /* conf values */
465 #define TDS_STR_ENCRYPTION_OFF "off"
466 #define TDS_STR_ENCRYPTION_REQUEST "request"
467 #define TDS_STR_ENCRYPTION_REQUIRE "require"
468 /* Defines to enable optional GSSAPI delegation */
469 #define TDS_GSSAPI_DELEGATION "enable gssapi delegation"
470 /* Mutual authentication */
471 #define TDS_STR_MUTUAL_AUTHENTICATION "mutual authentication"
472 /* Kerberos realm name */
473 #define TDS_STR_REALM "realm"
474 /* Kerberos SPN */
475 #define TDS_STR_SPN "spn"
476 /* CA file */
477 #define TDS_STR_CAFILE "ca file"
478 /* CRL file */
479 #define TDS_STR_CRLFILE "crl file"
480 /* check SSL hostname */
481 #define TDS_STR_CHECKSSLHOSTNAME "check certificate hostname"
482 /* database filename to attach on login (MSSQL) */
483 #define TDS_STR_DBFILENAME "database filename"
484 /* Application Intent MSSQL 2012 support */
485 #define TDS_STR_READONLY_INTENT "read-only intent"
486 /* configurable cipher suite to send to openssl's SSL_set_cipher_list() function */
487 #define TLS_STR_OPENSSL_CIPHERS "openssl ciphers"
488 /* enable old TLS v1, required for instance if you are using a really old Windows XP */
489 #define TDS_STR_ENABLE_TLS_V1 "enable tls v1"
490 
491 
492 /* TODO do a better check for alignment than this */
493 typedef union
494 {
495  void *p;
496  int i;
497  int64_t ui;
499 
500 #define TDS_ALIGN_SIZE sizeof(tds_align_struct)
501 
502 typedef struct tds_capability_type
503 {
504  unsigned char type;
505  unsigned char len; /* always sizeof(values) */
506  unsigned char values[TDS_MAX_CAPABILITY/2-2];
508 
509 typedef struct tds_capabilities
510 {
511  TDS_CAPABILITY_TYPE types[2];
513 
514 #define TDS_MAX_LOGIN_STR_SZ 128
515 typedef struct tds_login
516 {
518  int port;
519  TDS_USMALLINT tds_version;
520  int block_size;
521  DSTR language; /* e.g. us-english */
523  TDS_INT connect_timeout;
524  DSTR client_host_name;
525  DSTR server_host_name;
531  DSTR openssl_ciphers;
532  DSTR app_name;
537  DSTR library; /* Ct-Library, DB-Library, TDS-Library or ODBC */
538  TDS_TINYINT encryption_level;
539 
540  TDS_INT query_timeout;
541  TDS_CAPABILITIES capabilities;
542  DSTR client_charset;
543  DSTR database;
544 
545  struct addrinfo *ip_addrs;
546  DSTR instance_name;
547  DSTR dump_file;
548  int debug_flags;
549  int text_size;
550  DSTR routing_address;
551  uint16_t routing_port;
552 
553  unsigned char option_flag2;
554 
555  unsigned int bulk_copy:1;
556  unsigned int suppress_language:1;
557  unsigned int gssapi_use_delegation:1;
558  unsigned int mutual_authentication:1;
559  unsigned int use_ntlmv2:1;
560  unsigned int use_ntlmv2_specified:1;
561  unsigned int use_lanman:1;
562  unsigned int mars:1;
563  unsigned int use_utf16:1;
564  unsigned int use_new_password:1;
565  unsigned int valid_configuration:1;
566  unsigned int check_ssl_hostname:1;
567  unsigned int readonly_intent:1;
568  unsigned int enable_tls_v1:1;
569  unsigned int server_is_valid:1;
570 } TDSLOGIN;
571 
572 typedef struct tds_headers
573 {
574  const char *qn_options;
575  const char *qn_msgtext;
576  TDS_INT qn_timeout;
577  /* TDS 7.4+: trace activity ID char[20] */
578 } TDSHEADERS;
579 
580 typedef struct tds_locale
581 {
582  char *language;
583  char *server_charset;
584  char *date_fmt;
585 } TDSLOCALE;
586 
591 typedef struct tds_blob
592 {
593  TDS_CHAR *textvalue;
594  TDS_CHAR textptr[16];
595  TDS_CHAR timestamp[8];
596  unsigned char valid_ptr;
598 
602 typedef struct tds_variant
603 {
604  /* this MUST have same position and place of textvalue in tds_blob */
605  TDS_CHAR *data;
606  TDS_INT size;
607  TDS_INT data_len;
608  TDS_SERVER_TYPE type;
609  TDS_UCHAR collation[5];
611 
616 typedef struct tds_encoding
617 {
619  const char *name;
620  unsigned char min_bytes_per_char;
621  unsigned char max_bytes_per_char;
623  unsigned char canonic;
625 
626 typedef struct tds_bcpcoldata
627 {
628  TDS_UCHAR *data;
629  TDS_INT datalen;
630  bool is_null;
631 } BCPCOLDATA;
632 
633 
634 typedef TDSRET tds_func_get_info(TDSSOCKET *tds, TDSCOLUMN *col);
635 typedef TDSRET tds_func_get_data(TDSSOCKET *tds, TDSCOLUMN *col);
636 typedef TDS_INT tds_func_row_len(TDSCOLUMN *col);
637 typedef TDSRET tds_func_put_info(TDSSOCKET *tds, TDSCOLUMN *col);
638 typedef TDSRET tds_func_put_data(TDSSOCKET *tds, TDSCOLUMN *col, int bcp7);
639 typedef int tds_func_check(const TDSCOLUMN *col);
640 
641 typedef struct tds_column_funcs
642 {
643  tds_func_get_info *get_info;
644  tds_func_get_data *get_data;
645  tds_func_row_len *row_len;
651  tds_func_put_info *put_info;
661  tds_func_put_data *put_data;
662 #if ENABLE_EXTRA_CHECKS
663 
677  tds_func_check *check;
678 #endif
679 #if 0
680  TDSRET (*convert)(TDSSOCKET *tds, TDSCOLUMN *col);
681 #endif
683 
688 {
689  const TDSCOLUMNFUNCS *funcs;
690  TDS_INT column_usertype;
691  TDS_INT column_flags;
692 
693  TDS_INT column_size;
695  TDS_SERVER_TYPE column_type;
700  TDS_TINYINT column_varint_size;
702  TDS_TINYINT column_prec;
703  TDS_TINYINT column_scale;
705  struct
706  {
707  TDS_SERVER_TYPE column_type;
708  TDS_INT column_size;
709  } on_server;
710 
713  DSTR table_name;
714  DSTR column_name;
715  DSTR table_column_name;
716 
717  unsigned char *column_data;
718  void (*column_data_free)(struct tds_column *column);
719  unsigned char column_nullable:1;
720  unsigned char column_writeable:1;
721  unsigned char column_identity:1;
722  unsigned char column_key:1;
723  unsigned char column_hidden:1;
724  unsigned char column_output:1;
725  unsigned char column_timestamp:1;
726  unsigned char column_computed:1;
727  TDS_UCHAR column_collation[5];
728 
729  /* additional fields flags for compute results */
730  TDS_SMALLINT column_operand;
731  TDS_TINYINT column_operator;
732 
733  /* FIXME this is data related, not column */
736 
737  /* related to binding or info stored by client libraries */
738  /* FIXME find a best place to store these data, some are unused */
739  TDS_SMALLINT column_bindtype;
740  TDS_SMALLINT column_bindfmt;
741  TDS_UINT column_bindlen;
742  TDS_SMALLINT *column_nullbind;
743  TDS_CHAR *column_varaddr;
744  TDS_INT *column_lenbind;
745  TDS_INT column_textpos;
746  TDS_INT column_text_sqlgetdatapos;
747  TDS_CHAR column_text_sqlputdatainfo;
748  unsigned char column_iconv_left;
749  char column_iconv_buf[9];
750 
751  BCPCOLDATA *bcp_column_data;
760  TDS_INT bcp_prefix_len;
761  TDS_INT bcp_term_len;
762  TDS_CHAR *bcp_terminator;
763 };
764 
765 
767 typedef struct tds_result_info
768 {
769  /* TODO those fields can became a struct */
770  TDSCOLUMN **columns;
771  TDS_USMALLINT num_cols;
772  TDS_USMALLINT computeid;
773  TDS_INT ref_count;
774  TDSSOCKET *attached_to;
775  unsigned char *current_row;
776  void (*row_free)(struct tds_result_info* result, unsigned char *row);
777  TDS_INT row_size;
778 
779  TDS_SMALLINT *bycolumns;
780  TDS_USMALLINT by_cols;
781  bool rows_exist;
782  /* TODO remove ?? used only in dblib */
783  bool more_results;
785 
787 typedef enum tds_states
788 {
794  TDS_DEAD
796 
797 typedef enum tds_operations
798 {
799  TDS_OP_NONE = 0,
800 
801  /* mssql operations */
802  TDS_OP_CURSOR = TDS_SP_CURSOR,
803  TDS_OP_CURSOROPEN = TDS_SP_CURSOROPEN,
804  TDS_OP_CURSORPREPARE = TDS_SP_CURSORPREPARE,
805  TDS_OP_CURSOREXECUTE = TDS_SP_CURSOREXECUTE,
806  TDS_OP_CURSORPREPEXEC = TDS_SP_CURSORPREPEXEC,
807  TDS_OP_CURSORUNPREPARE = TDS_SP_CURSORUNPREPARE,
808  TDS_OP_CURSORFETCH = TDS_SP_CURSORFETCH,
809  TDS_OP_CURSOROPTION = TDS_SP_CURSOROPTION,
810  TDS_OP_CURSORCLOSE = TDS_SP_CURSORCLOSE,
811  TDS_OP_EXECUTESQL = TDS_SP_EXECUTESQL,
812  TDS_OP_PREPARE = TDS_SP_PREPARE,
813  TDS_OP_EXECUTE = TDS_SP_EXECUTE,
814  TDS_OP_PREPEXEC = TDS_SP_PREPEXEC,
815  TDS_OP_PREPEXECRPC = TDS_SP_PREPEXECRPC,
816  TDS_OP_UNPREPARE = TDS_SP_UNPREPARE,
817 
818  /* sybase operations */
819  TDS_OP_DYN_DEALLOC = 100,
820 } TDS_OPERATION;
821 
822 #define TDS_DBG_LOGIN __FILE__, ((__LINE__ << 4) | 11)
823 #define TDS_DBG_HEADER __FILE__, ((__LINE__ << 4) | 10)
824 #define TDS_DBG_FUNC __FILE__, ((__LINE__ << 4) | 7)
825 #define TDS_DBG_INFO2 __FILE__, ((__LINE__ << 4) | 6)
826 #define TDS_DBG_INFO1 __FILE__, ((__LINE__ << 4) | 5)
827 #define TDS_DBG_NETWORK __FILE__, ((__LINE__ << 4) | 4)
828 #define TDS_DBG_WARN __FILE__, ((__LINE__ << 4) | 3)
829 #define TDS_DBG_ERROR __FILE__, ((__LINE__ << 4) | 2)
830 #define TDS_DBG_SEVERE __FILE__, ((__LINE__ << 4) | 1)
831 
832 #define TDS_DBGFLAG_FUNC 0x80
833 #define TDS_DBGFLAG_INFO2 0x40
834 #define TDS_DBGFLAG_INFO1 0x20
835 #define TDS_DBGFLAG_NETWORK 0x10
836 #define TDS_DBGFLAG_WARN 0x08
837 #define TDS_DBGFLAG_ERROR 0x04
838 #define TDS_DBGFLAG_SEVERE 0x02
839 #define TDS_DBGFLAG_ALL 0xfff
840 #define TDS_DBGFLAG_LOGIN 0x0800
841 #define TDS_DBGFLAG_HEADER 0x0400
842 #define TDS_DBGFLAG_PID 0x1000
843 #define TDS_DBGFLAG_TIME 0x2000
844 #define TDS_DBGFLAG_SOURCE 0x4000
845 #define TDS_DBGFLAG_THREAD 0x8000
846 
847 #if 0
848 
853 enum TDS_DBG_LOG_STATE
854 {
855  TDS_DBG_LOGIN = (1 << 0)
857  , TDS_DBG_API = (1 << 1)
858  , TDS_DBG_ASYNC = (1 << 2)
859  , TDS_DBG_DIAG = (1 << 3)
860  , TDS_DBG_error = (1 << 4)
861  /* TODO: ^^^^^ make upper case when old #defines (above) are removed */
862  /* Log FreeTDS runtime/logic error occurs. */
863  , TDS_DBG_PACKET = (1 << 5)
864  , TDS_DBG_LIBTDS = (1 << 6)
865  , TDS_DBG_CONFIG = (1 << 7)
866  , TDS_DBG_DEFAULT = 0xFE
867 };
868 #endif
869 
870 typedef struct tds_result_info TDSCOMPUTEINFO;
871 
873 
874 typedef struct tds_message
875 {
876  TDS_CHAR *server;
877  TDS_CHAR *message;
878  TDS_CHAR *proc_name;
879  TDS_CHAR *sql_state;
880  TDS_INT msgno;
881  TDS_INT line_number;
882  /* -1 .. 255 */
883  TDS_SMALLINT state;
884  TDS_TINYINT priv_msg_type;
885  TDS_TINYINT severity;
886  /* for library-generated errors */
887  int oserr;
888 } TDSMESSAGE;
889 
890 typedef struct tds_upd_col
891 {
892  struct tds_upd_col *next;
893  TDS_INT colnamelength;
894  char * columnname;
895 } TDSUPDCOL;
896 
897 typedef enum {
898  TDS_CURSOR_STATE_UNACTIONED = 0 /* initial value */
899  , TDS_CURSOR_STATE_REQUESTED = 1 /* called by ct_cursor */
900  , TDS_CURSOR_STATE_SENT = 2 /* sent to server */
901  , TDS_CURSOR_STATE_ACTIONED = 3 /* acknowledged by server */
902 } TDS_CURSOR_STATE;
903 
904 typedef struct tds_cursor_status
905 {
906  TDS_CURSOR_STATE declare;
907  TDS_CURSOR_STATE cursor_row;
908  TDS_CURSOR_STATE open;
909  TDS_CURSOR_STATE fetch;
910  TDS_CURSOR_STATE close;
911  TDS_CURSOR_STATE dealloc;
913 
914 typedef enum tds_cursor_operation
915 {
916  TDS_CURSOR_POSITION = 0,
917  TDS_CURSOR_UPDATE = 1,
918  TDS_CURSOR_DELETE = 2,
919  TDS_CURSOR_INSERT = 4
920 } TDS_CURSOR_OPERATION;
921 
922 typedef enum tds_cursor_fetch
923 {
924  TDS_CURSOR_FETCH_NEXT = 1,
925  TDS_CURSOR_FETCH_PREV,
926  TDS_CURSOR_FETCH_FIRST,
927  TDS_CURSOR_FETCH_LAST,
928  TDS_CURSOR_FETCH_ABSOLUTE,
929  TDS_CURSOR_FETCH_RELATIVE
930 } TDS_CURSOR_FETCH;
931 
935 typedef struct tds_cursor
936 {
937  struct tds_cursor *next;
938  TDS_INT ref_count;
939  char *cursor_name;
940  TDS_INT cursor_id;
941  TDS_TINYINT options;
946  char *query;
947  /* TODO for updatable columns */
948  /* TDS_TINYINT number_upd_cols; */
949  /* TDSUPDCOL *cur_col_list; */
950  TDS_INT cursor_rows;
951  /* TDSPARAMINFO *params; */
953  TDS_USMALLINT srv_status;
954  TDSRESULTINFO *res_info;
955  TDS_INT type, concurrency;
957 
961 typedef struct tds_env
962 {
965  char *language;
967  char *charset;
969  char *database;
971 
975 typedef struct tds_dynamic
976 {
977  struct tds_dynamic *next;
978  TDS_INT ref_count;
980  TDS_INT num_id;
986  char id[30];
992  TDS_TINYINT emulated;
997  /* int dyn_state; */ /* TODO use it */
1008  char *query;
1010 
1011 typedef enum {
1012  TDS_MULTIPLE_QUERY,
1013  TDS_MULTIPLE_EXECUTE,
1014  TDS_MULTIPLE_RPC
1015 } TDS_MULTIPLE_TYPE;
1016 
1017 typedef struct tds_multiple
1018 {
1019  TDS_MULTIPLE_TYPE type;
1020  unsigned int flags;
1021 } TDSMULTIPLE;
1022 
1023 /* forward declaration */
1024 typedef struct tds_context TDSCONTEXT;
1025 typedef int (*err_handler_t) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1026 
1028 {
1029  TDSLOCALE *locale;
1030  void *parent;
1031  /* handlers */
1032  int (*msg_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1033  int (*err_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1034  int (*int_handler) (void *);
1035  bool money_use_2_digits;
1036 };
1037 
1038 enum TDS_ICONV_ENTRY
1039 {
1040  client2ucs2
1041  , client2server_chardata
1042  , initial_char_conv_count /* keep last */
1043 };
1044 
1045 typedef struct tds_authentication
1046 {
1047  uint8_t *packet;
1048  int packet_len;
1049  /* TDS_MSG_TOKEN type, for TDS5 */
1050  uint16_t msg_type;
1051  TDSRET (*free)(TDSCONNECTION* conn, struct tds_authentication * auth);
1052  TDSRET (*handle_next)(TDSSOCKET * tds, struct tds_authentication * auth, size_t len);
1054 
1055 typedef struct tds_packet
1056 {
1057  struct tds_packet *next;
1058  uint16_t sid;
1059 
1060 #if ENABLE_ODBC_MARS
1061 
1064  uint8_t data_start;
1065 #endif
1066 
1070  unsigned data_len;
1071  unsigned capacity;
1072  unsigned char buf[1];
1073 } TDSPACKET;
1074 
1075 #if ENABLE_ODBC_MARS
1076 #define tds_packet_zero_data_start(pkt) do { (pkt)->data_start = 0; } while(0)
1077 #define tds_packet_get_data_start(pkt) ((pkt)->data_start)
1078 #else
1079 #define tds_packet_zero_data_start(pkt) do { } while(0)
1080 #define tds_packet_get_data_start(pkt) 0
1081 #endif
1082 
1083 typedef struct tds_poll_wakeup
1084 {
1085  TDS_SYS_SOCKET s_signal, s_signaled;
1086 } TDSPOLLWAKEUP;
1087 
1088 /* field related to connection */
1090 {
1091  TDS_USMALLINT tds_version;
1092  TDS_UINT product_version;
1093  char *product_name;
1094 
1095  TDS_SYS_SOCKET s;
1096  TDSPOLLWAKEUP wakeup;
1097  const TDSCONTEXT *tds_ctx;
1098 
1101 
1112 
1113  int char_conv_count;
1114  TDSICONV **char_convs;
1115 
1116  TDS_UCHAR collation[5];
1117  TDS_UCHAR tds72_transaction[8];
1118 
1119  TDS_CAPABILITIES capabilities;
1120  unsigned int use_iconv:1;
1121  unsigned int tds71rev1:1;
1122  unsigned int pending_close:1;
1123  unsigned int encrypt_single_packet:1;
1124 #if ENABLE_ODBC_MARS
1125  unsigned int mars:1;
1126 
1127  TDSSOCKET *in_net_tds;
1128  TDSPACKET *packets;
1129  TDSPACKET *recv_packet;
1130  TDSPACKET *send_packets;
1131  unsigned send_pos, recv_pos;
1132 
1133 #define BUSY_SOCKET ((TDSSOCKET*)(TDS_UINTPTR)1)
1134 #define TDSSOCKET_VALID(tds) (((TDS_UINTPTR)(tds)) > 1)
1135  struct tds_socket **sessions;
1136  unsigned num_sessions;
1137 #endif
1138  tds_mutex list_mtx;
1139 
1140  unsigned num_cached_packets;
1141  TDSPACKET *packet_cache;
1142 
1143  int spid;
1144  int client_spid;
1145 
1146  void *tls_session;
1147 #if defined(HAVE_GNUTLS)
1148  void *tls_credentials;
1149 #elif defined(HAVE_OPENSSL)
1150  void *tls_ctx;
1151 #else
1152  void *tls_dummy;
1153 #endif
1154  TDSAUTHENTICATION *authentication;
1155  char *server;
1156 };
1157 
1162 {
1163 #if ENABLE_ODBC_MARS
1164  TDSCONNECTION *conn;
1165 #else
1166  TDSCONNECTION conn[1];
1167 #endif
1168 
1169  void *parent;
1170 
1176  unsigned char *in_buf;
1177 
1184  unsigned char *out_buf;
1185 
1190  unsigned int out_buf_max;
1191  unsigned in_pos;
1192  unsigned out_pos;
1193  unsigned in_len;
1194  unsigned char in_flag;
1195  unsigned char out_flag;
1197  unsigned frozen;
1203 
1204 #if ENABLE_ODBC_MARS
1205 
1209  uint16_t sid;
1210 
1215  tds_condition packet_cond;
1216 
1221  TDSPACKET *sending_packet;
1222  TDS_UINT recv_seq;
1223  TDS_UINT send_seq;
1224  TDS_UINT recv_wnd;
1225  TDS_UINT send_wnd;
1226 #endif
1227  /* packet we received */
1228  TDSPACKET *recv_packet;
1231 
1238  TDSRESULTINFO *res_info;
1239  TDS_UINT num_comp_info;
1240  TDSCOMPUTEINFO **comp_info;
1241  TDSPARAMINFO *param_info;
1243  bool bulk_query;
1244  bool has_status;
1245  bool in_row;
1246  volatile
1247  unsigned char in_cancel;
1249  TDS_INT ret_status;
1250  TDS_STATE state;
1251 
1252  TDS_INT query_timeout;
1253  TDS_INT8 rows_affected;
1259  void (*env_chg_func) (TDSSOCKET * tds, int type, char *oldval, char *newval);
1260  TDS_OPERATION current_op;
1261 
1262  int option_value;
1263  tds_mutex wire_mtx;
1264 };
1265 
1266 #define tds_get_ctx(tds) ((tds)->conn->tds_ctx)
1267 #define tds_set_ctx(tds, val) do { ((tds)->conn->tds_ctx) = (val); } while(0)
1268 #define tds_get_parent(tds) ((tds)->parent)
1269 #define tds_set_parent(tds, val) do { ((tds)->parent) = (val); } while(0)
1270 #define tds_get_s(tds) ((tds)->conn->s)
1271 #define tds_set_s(tds, val) do { ((tds)->conn->s) = (val); } while(0)
1272 
1273 
1274 /* config.c */
1276 typedef void (*TDSCONFPARSE) (const char *option, const char *value, void *param);
1277 bool tds_read_conf_section(FILE * in, const char *section, TDSCONFPARSE tds_conf_parse, void *parse_param);
1278 bool tds_read_conf_file(TDSLOGIN * login, const char *server);
1279 void tds_parse_conf_section(const char *option, const char *value, void *param);
1280 TDSLOGIN *tds_read_config_info(TDSSOCKET * tds, TDSLOGIN * login, TDSLOCALE * locale);
1281 void tds_fix_login(TDSLOGIN* login);
1282 TDS_USMALLINT * tds_config_verstr(const char *tdsver, TDSLOGIN* login);
1283 struct addrinfo *tds_lookup_host(const char *servername);
1284 TDSRET tds_lookup_host_set(const char *servername, struct addrinfo **addr);
1285 const char *tds_addrinfo2str(struct addrinfo *addr, char *name, int namemax);
1286 char *tds_get_home_file(const char *file);
1287 
1288 TDSRET tds_set_interfaces_file_loc(const char *interfloc);
1289 extern const char STD_DATETIME_FMT[];
1290 int tds_parse_boolean(const char *value, int default_value);
1291 int tds_config_boolean(const char *option, const char *value, TDSLOGIN * login);
1292 
1293 TDSLOCALE *tds_get_locale(void);
1294 TDSRET tds_alloc_row(TDSRESULTINFO * res_info);
1295 TDSRET tds_alloc_compute_row(TDSCOMPUTEINFO * res_info);
1296 BCPCOLDATA * tds_alloc_bcp_column_data(unsigned int column_size);
1297 TDSDYNAMIC *tds_lookup_dynamic(TDSCONNECTION * conn, const char *id);
1298 /*@observer@*/ const char *tds_prtype(int token);
1299 int tds_get_varint_size(TDSCONNECTION * conn, int datatype);
1300 TDS_SERVER_TYPE tds_get_cardinal_type(TDS_SERVER_TYPE datatype, int usertype);
1301 
1302 
1303 /* iconv.c */
1304 TDSRET tds_iconv_open(TDSCONNECTION * conn, const char *charset, int use_utf16);
1305 void tds_iconv_close(TDSCONNECTION * conn);
1306 void tds_srv_charset_changed(TDSCONNECTION * conn, const char *charset);
1307 void tds7_srv_charset_changed(TDSCONNECTION * conn, TDS_UCHAR collate[5]);
1308 int tds_iconv_alloc(TDSCONNECTION * conn);
1309 void tds_iconv_free(TDSCONNECTION * conn);
1310 TDSICONV *tds_iconv_from_collate(TDSCONNECTION * conn, TDS_UCHAR collate[5]);
1311 
1312 
1313 /* mem.c */
1314 void tds_free_socket(TDSSOCKET * tds);
1315 void tds_free_all_results(TDSSOCKET * tds);
1316 void tds_free_results(TDSRESULTINFO * res_info);
1317 void tds_free_param_results(TDSPARAMINFO * param_info);
1318 void tds_free_param_result(TDSPARAMINFO * param_info);
1319 void tds_free_msg(TDSMESSAGE * message);
1320 void tds_cursor_deallocated(TDSCONNECTION *conn, TDSCURSOR *cursor);
1321 void tds_release_cursor(TDSCURSOR **pcursor);
1322 void tds_free_bcp_column_data(BCPCOLDATA * coldata);
1323 TDSRESULTINFO *tds_alloc_results(TDS_USMALLINT num_cols);
1324 TDSCOMPUTEINFO **tds_alloc_compute_results(TDSSOCKET * tds, TDS_USMALLINT num_cols, TDS_USMALLINT by_cols);
1325 TDSCONTEXT *tds_alloc_context(void * parent);
1326 void tds_free_context(TDSCONTEXT * locale);
1328 void tds_free_input_params(TDSDYNAMIC * dyn);
1329 void tds_release_dynamic(TDSDYNAMIC ** dyn);
1330 static inline
1331 void tds_release_cur_dyn(TDSSOCKET * tds)
1332 {
1334 }
1335 void tds_dynamic_deallocated(TDSCONNECTION *conn, TDSDYNAMIC *dyn);
1336 void tds_set_cur_dyn(TDSSOCKET *tds, TDSDYNAMIC *dyn);
1337 TDSSOCKET *tds_realloc_socket(TDSSOCKET * tds, size_t bufsize);
1338 char *tds_alloc_client_sqlstate(int msgno);
1339 char *tds_alloc_lookup_sqlstate(TDSSOCKET * tds, int msgno);
1340 TDSLOGIN *tds_alloc_login(int use_environment);
1341 TDSDYNAMIC *tds_alloc_dynamic(TDSCONNECTION * conn, const char *id);
1342 void tds_free_login(TDSLOGIN * login);
1343 TDSLOGIN *tds_init_login(TDSLOGIN * login, TDSLOCALE * locale);
1344 TDSLOCALE *tds_alloc_locale(void);
1345 void *tds_alloc_param_data(TDSCOLUMN * curparam);
1346 void tds_free_locale(TDSLOCALE * locale);
1347 TDSCURSOR * tds_alloc_cursor(TDSSOCKET * tds, const char *name, TDS_INT namelen, const char *query, TDS_INT querylen);
1348 void tds_free_row(TDSRESULTINFO * res_info, unsigned char *row);
1349 TDSSOCKET *tds_alloc_socket(TDSCONTEXT * context, unsigned int bufsize);
1350 TDSSOCKET *tds_alloc_additional_socket(TDSCONNECTION *conn);
1351 void tds_set_current_results(TDSSOCKET *tds, TDSRESULTINFO *info);
1352 void tds_detach_results(TDSRESULTINFO *info);
1353 void * tds_realloc(void **pp, size_t new_size);
1354 #define TDS_RESIZE(p, n_elem) \
1355  tds_realloc((void **) &(p), sizeof(*(p)) * (size_t) (n_elem))
1356 #define tds_new(type, n) ((type *) malloc(sizeof(type) * (n)))
1357 #define tds_new0(type, n) ((type *) calloc(n, sizeof(type)))
1358 
1359 TDSPACKET *tds_alloc_packet(void *buf, unsigned len);
1360 TDSPACKET *tds_realloc_packet(TDSPACKET *packet, unsigned len);
1361 void tds_free_packets(TDSPACKET *packet);
1362 TDSBCPINFO *tds_alloc_bcpinfo(void);
1363 void tds_free_bcpinfo(TDSBCPINFO *bcpinfo);
1364 void tds_deinit_bcpinfo(TDSBCPINFO *bcpinfo);
1365 
1366 
1367 /* login.c */
1368 void tds_set_packet(TDSLOGIN * tds_login, int packet_size);
1369 void tds_set_port(TDSLOGIN * tds_login, int port);
1370 bool tds_set_passwd(TDSLOGIN * tds_login, const char *password) TDS_WUR;
1371 void tds_set_bulk(TDSLOGIN * tds_login, bool enabled);
1372 bool tds_set_user(TDSLOGIN * tds_login, const char *username) TDS_WUR;
1373 bool tds_set_app(TDSLOGIN * tds_login, const char *application) TDS_WUR;
1374 bool tds_set_host(TDSLOGIN * tds_login, const char *hostname) TDS_WUR;
1375 bool tds_set_library(TDSLOGIN * tds_login, const char *library) TDS_WUR;
1376 bool tds_set_server(TDSLOGIN * tds_login, const char *server) TDS_WUR;
1377 bool tds_set_client_charset(TDSLOGIN * tds_login, const char *charset) TDS_WUR;
1378 bool tds_set_language(TDSLOGIN * tds_login, const char *language) TDS_WUR;
1379 void tds_set_version(TDSLOGIN * tds_login, TDS_TINYINT major_ver, TDS_TINYINT minor_ver);
1380 int tds_connect_and_login(TDSSOCKET * tds, TDSLOGIN * login);
1381 
1382 
1383 /* query.c */
1384 void tds_start_query(TDSSOCKET *tds, unsigned char packet_type);
1385 
1386 TDSRET tds_submit_query(TDSSOCKET * tds, const char *query);
1387 TDSRET tds_submit_query_params(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params, TDSHEADERS * head);
1388 TDSRET tds_submit_queryf(TDSSOCKET * tds, const char *queryf, ...);
1389 TDSRET tds_submit_prepare(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1390 TDSRET tds_submit_execdirect(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params, TDSHEADERS * head);
1391 TDSRET tds71_submit_prepexec(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1392 TDSRET tds_submit_execute(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1393 TDSRET tds_send_cancel(TDSSOCKET * tds);
1394 const char *tds_next_placeholder(const char *start);
1395 int tds_count_placeholders(const char *query);
1396 int tds_needs_unprepare(TDSCONNECTION * conn, TDSDYNAMIC * dyn);
1397 TDSRET tds_deferred_unprepare(TDSCONNECTION * conn, TDSDYNAMIC * dyn);
1398 TDSRET tds_submit_unprepare(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1399 TDSRET tds_submit_rpc(TDSSOCKET * tds, const char *rpc_name, TDSPARAMINFO * params, TDSHEADERS * head);
1400 TDSRET tds_submit_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD command, TDS_OPTION option, TDS_OPTION_ARG *param, TDS_INT param_size);
1401 TDSRET tds_submit_begin_tran(TDSSOCKET *tds);
1402 TDSRET tds_submit_rollback(TDSSOCKET *tds, int cont);
1403 TDSRET tds_submit_commit(TDSSOCKET *tds, int cont);
1404 TDSRET tds_disconnect(TDSSOCKET * tds);
1405 size_t tds_quote_id(TDSSOCKET * tds, char *buffer, const char *id, int idlen);
1406 size_t tds_quote_id_rpc(TDSSOCKET * tds, char *buffer, const char *id, int idlen);
1407 size_t tds_quote_string(TDSSOCKET * tds, char *buffer, const char *str, int len);
1408 const char *tds_skip_comment(const char *s);
1409 const char *tds_skip_quoted(const char *s);
1410 size_t tds_fix_column_size(TDSSOCKET * tds, TDSCOLUMN * curcol);
1411 const char *tds_convert_string(TDSSOCKET * tds, TDSICONV * char_conv, const char *s, int len, size_t *out_len);
1412 void tds_convert_string_free(const char *original, const char *converted);
1413 #if !ENABLE_EXTRA_CHECKS
1414 #define tds_convert_string_free(original, converted) \
1415  do { if (original != converted) free((char*) converted); } while(0)
1416 #endif
1417 TDSRET tds_get_column_declaration(TDSSOCKET * tds, TDSCOLUMN * curcol, char *out);
1418 
1419 TDSRET tds_cursor_declare(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1420 TDSRET tds_cursor_setrows(TDSSOCKET * tds, TDSCURSOR * cursor, int *send);
1421 TDSRET tds_cursor_open(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1422 TDSRET tds_cursor_fetch(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_FETCH fetch_type, TDS_INT i_row);
1423 TDSRET tds_cursor_get_cursor_info(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_UINT * row_number, TDS_UINT * row_count);
1424 TDSRET tds_cursor_close(TDSSOCKET * tds, TDSCURSOR * cursor);
1425 TDSRET tds_cursor_dealloc(TDSSOCKET * tds, TDSCURSOR * cursor);
1426 TDSRET tds_deferred_cursor_dealloc(TDSCONNECTION *conn, TDSCURSOR * cursor);
1427 TDSRET tds_cursor_update(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_OPERATION op, TDS_INT i_row, TDSPARAMINFO * params);
1428 TDSRET tds_cursor_setname(TDSSOCKET * tds, TDSCURSOR * cursor);
1429 
1430 TDSRET tds_multiple_init(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDS_MULTIPLE_TYPE type, TDSHEADERS * head);
1431 TDSRET tds_multiple_done(TDSSOCKET *tds, TDSMULTIPLE *multiple);
1432 TDSRET tds_multiple_query(TDSSOCKET *tds, TDSMULTIPLE *multiple, const char *query, TDSPARAMINFO * params);
1433 TDSRET tds_multiple_execute(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDSDYNAMIC * dyn);
1434 
1435 
1436 /* token.c */
1437 TDSRET tds_process_cancel(TDSSOCKET * tds);
1438 TDSRET tds_process_login_tokens(TDSSOCKET * tds);
1439 TDSRET tds_process_simple_query(TDSSOCKET * tds);
1440 int tds5_send_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD tds_command, TDS_OPTION tds_option, TDS_OPTION_ARG * tds_argument,
1441  TDS_INT * tds_argsize);
1442 TDSRET tds_process_tokens(TDSSOCKET * tds, /*@out@*/ TDS_INT * result_type, /*@out@*/ int *done_flags, unsigned flag);
1443 
1444 
1445 /* data.c */
1446 void tds_set_param_type(TDSCONNECTION * conn, TDSCOLUMN * curcol, TDS_SERVER_TYPE type);
1447 void tds_set_column_type(TDSCONNECTION * conn, TDSCOLUMN * curcol, TDS_SERVER_TYPE type);
1448 #ifdef WORDS_BIGENDIAN
1449 void tds_swap_datatype(int coltype, void *b);
1450 #endif
1451 
1452 
1453 /* tds_convert.c */
1454 TDSRET tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC * dr);
1455 TDS_SERVER_TYPE tds_get_conversion_type(TDS_SERVER_TYPE srctype, int colsize);
1456 extern const char tds_hex_digits[];
1457 
1458 
1459 /* write.c */
1460 int tds_init_write_buf(TDSSOCKET * tds);
1461 int tds_put_n(TDSSOCKET * tds, const void *buf, size_t n);
1462 int tds_put_string(TDSSOCKET * tds, const char *buf, int len);
1463 int tds_put_int(TDSSOCKET * tds, TDS_INT i);
1464 int tds_put_int8(TDSSOCKET * tds, TDS_INT8 i);
1465 int tds_put_smallint(TDSSOCKET * tds, TDS_SMALLINT si);
1467 #define tds_put_tinyint(tds, ti) tds_put_byte(tds,ti)
1468 int tds_put_byte(TDSSOCKET * tds, unsigned char c);
1469 TDSRET tds_flush_packet(TDSSOCKET * tds);
1470 int tds_put_buf(TDSSOCKET * tds, const unsigned char *buf, int dsize, int ssize);
1471 
1472 
1473 /* read.c */
1474 unsigned char tds_get_byte(TDSSOCKET * tds);
1475 void tds_unget_byte(TDSSOCKET * tds);
1476 unsigned char tds_peek(TDSSOCKET * tds);
1477 TDS_USMALLINT tds_get_usmallint(TDSSOCKET * tds);
1478 #define tds_get_smallint(tds) ((TDS_SMALLINT) tds_get_usmallint(tds))
1479 TDS_UINT tds_get_uint(TDSSOCKET * tds);
1480 #define tds_get_int(tds) ((TDS_INT) tds_get_uint(tds))
1481 TDS_UINT8 tds_get_uint8(TDSSOCKET * tds);
1482 #define tds_get_int8(tds) ((TDS_INT8) tds_get_uint8(tds))
1483 size_t tds_get_string(TDSSOCKET * tds, size_t string_len, char *dest, size_t dest_size);
1484 TDSRET tds_get_char_data(TDSSOCKET * tds, char *dest, size_t wire_size, TDSCOLUMN * curcol);
1485 bool tds_get_n(TDSSOCKET * tds, /*@out@*/ /*@null@*/ void *dest, size_t n);
1486 int tds_get_size_by_type(TDS_SERVER_TYPE servertype);
1487 DSTR* tds_dstr_get(TDSSOCKET * tds, DSTR * s, size_t len);
1488 
1489 
1490 /* util.c */
1491 int tdserror (const TDSCONTEXT * tds_ctx, TDSSOCKET * tds, int msgno, int errnum);
1493 void tds_swap_bytes(void *buf, int bytes);
1494 unsigned int tds_gettime_ms(void);
1495 char *tds_strndup(const void *s, TDS_INTPTR len);
1496 
1497 
1498 /* log.c */
1499 typedef struct tdsdump_off_item {
1500  struct tdsdump_off_item *next;
1501  tds_thread_id thread_id;
1503 void tdsdump_off(TDSDUMP_OFF_ITEM *off_item);
1504 void tdsdump_on(TDSDUMP_OFF_ITEM *off_item);
1505 int tdsdump_isopen(void);
1506 #include <freetds/popvis.h>
1507 int tdsdump_open(const char *filename);
1508 #include <freetds/pushvis.h>
1509 void tdsdump_close(void);
1510 void tdsdump_dump_buf(const char* file, unsigned int level_line, const char *msg, const void *buf, size_t length);
1511 void tdsdump_col(const TDSCOLUMN *col);
1512 #undef tdsdump_log
1513 void tdsdump_log(const char* file, unsigned int level_line, const char *fmt, ...)
1514 #if defined(__GNUC__) && __GNUC__ >= 2
1515 #if defined(__MINGW32__)
1516  __attribute__ ((__format__ (ms_printf, 3, 4)))
1517 #else
1518  __attribute__ ((__format__ (__printf__, 3, 4)))
1519 #endif
1520 #endif
1521 ;
1522 #define TDSDUMP_LOG_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_log
1523 #define tdsdump_log TDSDUMP_LOG_FAST
1524 #define TDSDUMP_BUF_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_dump_buf
1525 #define tdsdump_dump_buf TDSDUMP_BUF_FAST
1526 
1527 extern int tds_write_dump;
1528 extern int tds_debug_flags;
1529 extern int tds_g_append_mode;
1530 
1531 
1532 /* net.c */
1533 TDSERRNO tds_open_socket(TDSSOCKET * tds, struct addrinfo *ipaddr, unsigned int port, int timeout, int *p_oserr);
1534 void tds_close_socket(TDSSOCKET * tds);
1535 int tds7_get_instance_ports(FILE *output, struct addrinfo *addr);
1536 int tds7_get_instance_port(struct addrinfo *addr, const char *instance);
1537 char *tds_prwsaerror(int erc);
1538 void tds_prwsaerror_free(char *s);
1539 int tds_connection_read(TDSSOCKET * tds, unsigned char *buf, int buflen);
1540 int tds_connection_write(TDSSOCKET *tds, const unsigned char *buf, int buflen, int final);
1541 #define TDSSELREAD POLLIN
1542 #define TDSSELWRITE POLLOUT
1543 int tds_select(TDSSOCKET * tds, unsigned tds_sel, int timeout_seconds);
1544 void tds_connection_close(TDSCONNECTION *conn);
1545 int tds_goodread(TDSSOCKET * tds, unsigned char *buf, int buflen);
1546 int tds_goodwrite(TDSSOCKET * tds, const unsigned char *buffer, size_t buflen);
1547 void tds_socket_flush(TDS_SYS_SOCKET sock);
1548 int tds_socket_set_nonblocking(TDS_SYS_SOCKET sock);
1549 int tds_wakeup_init(TDSPOLLWAKEUP *wakeup);
1550 void tds_wakeup_close(TDSPOLLWAKEUP *wakeup);
1551 void tds_wakeup_send(TDSPOLLWAKEUP *wakeup, char cancel);
1552 static inline TDS_SYS_SOCKET tds_wakeup_get_fd(const TDSPOLLWAKEUP *wakeup)
1553 {
1554  return wakeup->s_signaled;
1555 }
1556 
1557 
1558 /* packet.c */
1559 int tds_read_packet(TDSSOCKET * tds);
1560 TDSRET tds_write_packet(TDSSOCKET * tds, unsigned char final);
1561 #if ENABLE_ODBC_MARS
1562 int tds_append_cancel(TDSSOCKET *tds);
1563 TDSRET tds_append_syn(TDSSOCKET *tds);
1564 TDSRET tds_append_fin(TDSSOCKET *tds);
1565 #else
1566 int tds_put_cancel(TDSSOCKET * tds);
1567 #endif
1568 
1569 typedef struct tds_freeze {
1575  unsigned pkt_pos;
1577  unsigned size_len;
1578 } TDSFREEZE;
1579 
1580 void tds_freeze(TDSSOCKET *tds, TDSFREEZE *freeze, unsigned size_len);
1581 size_t tds_freeze_written(TDSFREEZE *freeze);
1582 TDSRET tds_freeze_abort(TDSFREEZE *freeze);
1583 TDSRET tds_freeze_close(TDSFREEZE *freeze);
1584 TDSRET tds_freeze_close_len(TDSFREEZE *freeze, int32_t size);
1585 
1586 static void inline
1587 tds_set_current_send_packet(TDSSOCKET *tds, TDSPACKET *pkt)
1588 {
1589  tds->send_packet = pkt;
1590  tds->out_buf = pkt->buf + tds_packet_get_data_start(pkt);
1591 }
1592 
1593 /* Macros to allow some indentation of the packets.
1594  *
1595  * The 3 nested fake loops require some explanation:
1596  * - first is to allows to declare variables;
1597  * - second is to force using brackets;
1598  * - third is to avoids that a break inside will skip the close.
1599  */
1600 #define TDS_START_LEN_GENERIC(tds_socket, len) do { \
1601  TDSFREEZE current_freeze[1]; \
1602  tds_freeze((tds_socket), current_freeze, (len)); do { do
1603 #define TDS_END_LEN while(0); } while(tds_freeze_close(current_freeze), 0); } while(0);
1604 
1605 #define TDS_START_LEN_TINYINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 1)
1606 #define TDS_START_LEN_USMALLINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 2)
1607 #define TDS_START_LEN_UINT(tds_socket) TDS_START_LEN_GENERIC(tds_socket, 4)
1608 
1609 /* vstrbuild.c */
1610 TDSRET tds_vstrbuild(char *buffer, int buflen, int *resultlen, const char *text, int textlen, const char *formats, int formatlen,
1611  va_list ap);
1612 
1613 
1614 /* numeric.c */
1615 char *tds_money_to_string(const TDS_MONEY * money, char *s, bool use_2_digits);
1616 TDS_INT tds_numeric_to_string(const TDS_NUMERIC * numeric, char *s);
1617 TDS_INT tds_numeric_change_prec_scale(TDS_NUMERIC * numeric, unsigned char new_prec, unsigned char new_scale);
1618 
1619 
1620 /* getmac.c */
1621 void tds_getmac(TDS_SYS_SOCKET s, unsigned char mac[6]);
1622 
1623 
1624 /* challenge.c */
1625 #ifndef HAVE_SSPI
1627 TDSAUTHENTICATION * tds_gss_get_auth(TDSSOCKET * tds);
1628 #else
1629 TDSAUTHENTICATION * tds_sspi_get_auth(TDSSOCKET * tds);
1630 #endif
1631 TDSRET tds5_gss_send(TDSSOCKET *tds);
1632 
1633 
1634 /* random.c */
1635 void tds_random_buffer(unsigned char *out, int len);
1636 
1637 
1638 /* sec_negotiate.c */
1639 TDSAUTHENTICATION * tds5_negotiate_get_auth(TDSSOCKET * tds);
1640 static inline
1641 void tds5_negotiate_set_msg_type(TDSAUTHENTICATION * tds_auth, unsigned msg_type)
1642 {
1643  if (tds_auth)
1644  tds_auth->msg_type = msg_type;
1645 }
1646 
1647 
1648 /* bulk.c */
1649 
1652 {
1653  TDS_BCP_IN = 1,
1654  TDS_BCP_OUT = 2,
1655  TDS_BCP_QUERYOUT = 3
1656 };
1657 
1659 {
1660  const char *hint;
1661  void *parent;
1662  DSTR tablename;
1663  TDS_CHAR *insert_stmt;
1664  TDS_INT direction;
1665  TDS_INT identity_insert_on;
1666  TDS_INT xfer_init;
1667  TDS_INT bind_count;
1668  TDSRESULTINFO *bindinfo;
1669 };
1670 
1671 TDSRET tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1672 typedef TDSRET (*tds_bcp_get_col_data) (TDSBCPINFO *bulk, TDSCOLUMN *bcpcol, int offset);
1673 typedef void (*tds_bcp_null_error) (TDSBCPINFO *bulk, int index, int offset);
1674 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);
1675 TDSRET tds_bcp_done(TDSSOCKET *tds, int *rows_copied);
1676 TDSRET tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1677 TDSRET tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1678 
1679 TDSRET tds_bcp_fread(TDSSOCKET * tds, TDSICONV * conv, FILE * stream,
1680  const char *terminator, size_t term_len, char **outbuf, size_t * outbytes);
1681 
1682 TDSRET tds_writetext_start(TDSSOCKET *tds, const char *objname, const char *textptr, const char *timestamp, int with_log, TDS_UINT size);
1683 TDSRET tds_writetext_continue(TDSSOCKET *tds, const TDS_UCHAR *text, TDS_UINT size);
1684 TDSRET tds_writetext_end(TDSSOCKET *tds);
1685 
1686 
1687 static inline
1688 bool tds_capability_enabled(const TDS_CAPABILITY_TYPE *cap, unsigned cap_num)
1689 {
1690  return (cap->values[sizeof(cap->values)-1-(cap_num>>3)] >> (cap_num&7)) & 1;
1691 }
1692 #define tds_capability_has_req(conn, cap) \
1693  tds_capability_enabled(&conn->capabilities.types[0], cap)
1694 #define tds_capability_has_res(conn, cap) \
1695  tds_capability_enabled(&conn->capabilities.types[1], cap)
1696 
1697 #define IS_TDS42(x) (x->tds_version==0x402)
1698 #define IS_TDS46(x) (x->tds_version==0x406)
1699 #define IS_TDS50(x) (x->tds_version==0x500)
1700 #define IS_TDS70(x) (x->tds_version==0x700)
1701 #define IS_TDS71(x) (x->tds_version==0x701)
1702 #define IS_TDS72(x) (x->tds_version==0x702)
1703 #define IS_TDS73(x) (x->tds_version==0x703)
1704 
1705 #define IS_TDS50_PLUS(x) ((x)->tds_version>=0x500)
1706 #define IS_TDS7_PLUS(x) ((x)->tds_version>=0x700)
1707 #define IS_TDS71_PLUS(x) ((x)->tds_version>=0x701)
1708 #define IS_TDS72_PLUS(x) ((x)->tds_version>=0x702)
1709 #define IS_TDS73_PLUS(x) ((x)->tds_version>=0x703)
1710 #define IS_TDS74_PLUS(x) ((x)->tds_version>=0x704)
1711 
1712 #define TDS_MAJOR(x) ((x)->tds_version >> 8)
1713 #define TDS_MINOR(x) ((x)->tds_version & 0xff)
1714 
1715 #define IS_TDSDEAD(x) (((x) == NULL) || (x)->state == TDS_DEAD)
1716 
1718 #define TDS_IS_SYBASE(x) (!((x)->conn->product_version & 0x80000000u))
1719 
1720 #define TDS_IS_MSSQL(x) (((x)->conn->product_version & 0x80000000u)!=0)
1721 
1725 #define TDS_MS_VER(maj,min,x) (0x80000000u|((maj)<<24)|((min)<<16)|(x))
1726 
1727 /* TODO test if not similar to ms one*/
1729 #define TDS_SYB_VER(maj,min,x) (((maj)<<24)|((min)<<16)|(x)<<8)
1730 
1731 #ifdef __cplusplus
1732 #if 0
1733 {
1734 #endif
1735 }
1736 #endif
1737 
1738 #include <freetds/popvis.h>
1739 
1740 #define TDS_PUT_INT(tds,v) tds_put_int((tds), ((TDS_INT)(v)))
1741 #define TDS_PUT_SMALLINT(tds,v) tds_put_smallint((tds), ((TDS_SMALLINT)(v)))
1742 #define TDS_PUT_BYTE(tds,v) tds_put_byte((tds), ((unsigned char)(v)))
1743 
1744 #endif /* _tds_h_ */
tds_submit_query
TDSRET tds_submit_query(TDSSOCKET *tds, const char *query)
Sends a language string to the database server for processing.
Definition: query.c:210
tds_dstr_get
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
tds_socket::send_packet
TDSPACKET * send_packet
packet we are preparing to send
Definition: tds.h:1230
tds_read_config_info
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
tds_bcp_send_record
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:468
tds_set_server
bool tds_set_server(TDSLOGIN *tds_login, const char *server) TDS_WUR
Set the servername in a TDSLOGIN structure.
Definition: login.c:129
tds_column::column_prec
TDS_TINYINT column_prec
precision for decimal/numeric
Definition: tds.h:702
tds_socket::in_buf
unsigned char * in_buf
Input buffer.
Definition: tds.h:1176
TDS_DONE_CANCELLED
@ TDS_DONE_CANCELLED
acknowledging an attention command (usually a cancel)
Definition: tds.h:256
tds_ntlm_get_auth
TDSAUTHENTICATION * tds_ntlm_get_auth(TDSSOCKET *tds)
Build a NTLMSPP packet to send to server.
Definition: challenge.c:721
tds_submit_execute
TDSRET tds_submit_execute(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Sends a previously prepared dynamic statement to the server.
Definition: query.c:1630
tds_datecrack
TDSRET tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC *dr)
Convert from db date format to a structured date format.
Definition: convert.c:3159
tds_get_locale
TDSLOCALE * tds_get_locale(void)
Get locale information.
Definition: locale.c:50
tds_column
Metadata about columns in regular and compute rows.
Definition: tds.h:688
tdsiconvinfo
Definition: iconv.h:92
tdsdaterec::day
TDS_INT day
day of month (1-31)
Definition: tds.h:162
tdsdaterec::minute
TDS_INT minute
0-59
Definition: tds.h:166
tds_login::server_name
DSTR server_name
server name (in freetds.conf)
Definition: tds.h:517
tds_login::db_filename
DSTR db_filename
database filename to attach (MSSQL)
Definition: tds.h:528
TDS_IDLE
@ TDS_IDLE
no data expected
Definition: tds.h:789
tds_dynamic::ref_count
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition: tds.h:978
tds_set_column_type
void tds_set_column_type(TDSCONNECTION *conn, TDSCOLUMN *curcol, TDS_SERVER_TYPE type)
Set type of column initializing all dependency.
Definition: data.c:224
tds_write_dump
int tds_write_dump
Tell if TDS debug logging is turned on or off.
Definition: log.c:58
tds_upd_col
Definition: tds.h:891
tdsdaterec::year
TDS_INT year
year
Definition: tds.h:159
tds_connection::cursors
TDSCURSOR * cursors
linked list of cursors allocated for this connection contains only cursors allocated on the server
Definition: tds.h:1106
tds_socket::has_status
bool has_status
true is ret_status is valid
Definition: tds.h:1244
tds_socket::out_buf
unsigned char * out_buf
Output buffer.
Definition: tds.h:1184
tds_connection::s
TDS_SYS_SOCKET s
tcp socket, INVALID_SOCKET if not connected
Definition: tds.h:1095
tds_free_input_params
void tds_free_input_params(TDSDYNAMIC *dyn)
Frees all allocated input parameters of a dynamic statement.
Definition: mem.c:206
tds_submit_unprepare
TDSRET tds_submit_unprepare(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Send a unprepare request for a prepared query.
Definition: query.c:1797
tds_writetext_start
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:1145
tds_login::server_charset
DSTR server_charset
charset of server e.g.
Definition: tds.h:522
tds_get_n
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
tds_condition
Definition: thread.h:279
tds_blob
Information about blobs (e.g.
Definition: tds.h:592
tdsdaterec::decimicrosecond
TDS_INT decimicrosecond
0-9999999
Definition: tds.h:168
tds_dynamic::emulated
TDS_TINYINT emulated
this dynamic query cannot be prepared so libTDS have to construct a simple query.
Definition: tds.h:992
tds_dstr
Structure to hold a string.
Definition: string.h:36
tds_result_info
Hold information for any results.
Definition: tds.h:768
tds_bcp_start
TDSRET tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start sending BCP data to server.
Definition: bulk.c:864
tdsdump_off_item
Definition: tds.h:1499
tds_read_conf_section
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
tds_capabilities
Definition: tds.h:510
tds_set_interfaces_file_loc
TDSRET tds_set_interfaces_file_loc(const char *interfloc)
Set the full name of interface file.
Definition: config.c:961
TDS_DONE_SRVERROR
@ TDS_DONE_SRVERROR
SQL server server error.
Definition: tds.h:258
tds_column_funcs
Definition: tds.h:642
tds_config_verstr
TDS_USMALLINT * tds_config_verstr(const char *tdsver, TDSLOGIN *login)
Set TDS version from given string.
Definition: config.c:923
tds_alloc_row
TDSRET tds_alloc_row(TDSRESULTINFO *res_info)
Allocate space for row store return NULL on out of memory.
Definition: mem.c:524
tds_read_conf_file
bool tds_read_conf_file(TDSLOGIN *login, const char *server)
Read configuration info for given server return 0 on error.
Definition: config.c:346
tds_poll_wakeup
Definition: tds.h:1084
tds_option_arg
Definition: tds.h:329
tds_connection::dyns
TDSDYNAMIC * dyns
list of dynamic allocated for this connection contains only dynamic allocated on the server
Definition: tds.h:1111
TDS_SENDING
@ TDS_SENDING
client would send data
Definition: tds.h:791
tds_encoding::name
const char * name
name of the encoding (ie UTF-8)
Definition: tds.h:619
tdsdump_log
void tdsdump_log(const char *file, unsigned int level_line, const char *fmt,...)
Write a message to the debug log.
Definition: log.c:396
tds_socket::bulk_query
bool bulk_query
true is query sent was a bulk query so we need to switch state to QUERYING
Definition: tds.h:1243
tds_submit_rpc
TDSRET tds_submit_rpc(TDSSOCKET *tds, const char *rpc_name, TDSPARAMINFO *params, TDSHEADERS *head)
Calls a RPC from server.
Definition: query.c:1929
tds_dynamic::query
char * query
saved query, we need to know original query if prepare is impossible
Definition: tds.h:1008
tds_process_tokens
TDSRET tds_process_tokens(TDSSOCKET *tds, TDS_INT *result_type, int *done_flags, unsigned flag)
process all streams.
Definition: token.c:531
tds_login::cafile
DSTR cafile
certificate authorities file
Definition: tds.h:529
tds_login::bulk_copy
unsigned int bulk_copy
if bulk copy should be enabled
Definition: tds.h:555
tds_socket::frozen_packets
TDSPACKET * frozen_packets
list of packets frozen, points to first one.
Definition: tds.h:1202
tdsdump_off
void tdsdump_off(TDSDUMP_OFF_ITEM *off_item)
Temporarily turn off logging for current thread.
Definition: log.c:81
tds_encoding
Information relevant to libiconv.
Definition: tds.h:617
tds_lookup_host
struct addrinfo * tds_lookup_host(const char *servername)
Get the IP address for a hostname.
Definition: config.c:987
tds_submit_begin_tran
TDSRET tds_submit_begin_tran(TDSSOCKET *tds)
Send a rollback request.
Definition: query.c:3662
tds_socket::rows_affected
TDS_INT8 rows_affected
rows updated/deleted/inserted/selected, TDS_NO_COUNT if not valid
Definition: tds.h:1253
tdsmoney
Definition: proto.h:39
tds_authentication
Definition: tds.h:1046
TDS_DATETIMEALL
this structure is not directed connected to a TDS protocol but keeps any DATE/TIME information.
Definition: tds.h:145
TDSBLOB
struct tds_blob TDSBLOB
Information about blobs (e.g.
tds_locale
Definition: tds.h:581
tds_socket::cur_cursor
TDSCURSOR * cur_cursor
cursor in use
Definition: tds.h:1242
tds_dynamic
Holds information for a dynamic (also called prepared) query.
Definition: tds.h:976
tds_cursor::type
TDS_INT type
row fetched from this cursor
Definition: tds.h:955
tds_freeze::tds
TDSSOCKET * tds
which socket we refer to
Definition: tds.h:1571
tds_login::port
int port
port of database service
Definition: tds.h:518
tds7_get_instance_port
int tds7_get_instance_port(struct addrinfo *addr, const char *instance)
Get port of given instance.
Definition: net.c:1229
tds_socket::current_results
TDSRESULTINFO * current_results
Current query information.
Definition: tds.h:1237
tdsdump_dump_buf
void tdsdump_dump_buf(const char *file, unsigned int level_line, const char *msg, const void *buf, size_t length)
Dump the contents of data into the log file in a human readable format.
Definition: log.c:293
tds_submit_execdirect
TDSRET tds_submit_execdirect(TDSSOCKET *tds, const char *query, TDSPARAMINFO *params, TDSHEADERS *head)
Submit a prepared query with parameters.
Definition: query.c:1256
tds_next_placeholder
const char * tds_next_placeholder(const char *start)
Get position of next placeholder.
Definition: query.c:535
tds_submit_prepare
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:1124
tds_get_char_data
TDSRET tds_get_char_data(TDSSOCKET *tds, char *dest, size_t wire_size, TDSCOLUMN *curcol)
Fetch character data the wire.
Definition: read.c:195
tds_login::password
DSTR password
password of account login
Definition: tds.h:534
TDSENV
struct tds_env TDSENV
Current environment as reported by the server.
tds_flush_packet
TDSRET tds_flush_packet(TDSSOCKET *tds)
Flush packet to server.
Definition: write.c:224
tds_put_string
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
tdsdaterec::quarter
TDS_INT quarter
quarter (0-3)
Definition: tds.h:160
tds_login::ip_addrs
struct addrinfo * ip_addrs
ip(s) of server
Definition: tds.h:545
TDSDATEREC
struct tdsdaterec TDSDATEREC
Used by tds_datecrack.
tds_freeze_close
TDSRET tds_freeze_close(TDSFREEZE *freeze)
Stop keeping data for this specific freeze.
Definition: packet.c:996
tds_strndup
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_iconv_from_collate
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:1240
tds_fix_column_size
size_t tds_fix_column_size(TDSSOCKET *tds, TDSCOLUMN *curcol)
Get column size for wire.
Definition: query.c:1491
tds_dynamic::defer_close
bool defer_close
true if dynamic was marker to be closed when connection is idle
Definition: tds.h:996
tds_cursor::cursor_rows
TDS_INT cursor_rows
< number of updatable columns
Definition: tds.h:950
tds_cursor
Holds informations about a cursor.
Definition: tds.h:936
tds_socket::login
TDSLOGIN * login
config for login stuff.
Definition: tds.h:1257
tds_get_uint
TDS_UINT tds_get_uint(TDSSOCKET *tds)
Get an int32 from the server.
Definition: read.c:127
tdsdaterec::hour
TDS_INT hour
0-23
Definition: tds.h:165
tds_packet::data_len
unsigned data_len
data length, this does not account SMP header, only TDS part
Definition: tds.h:1070
tds_bcp_done
TDSRET tds_bcp_done(TDSSOCKET *tds, int *rows_copied)
Tell we finished sending BCP data to server.
Definition: bulk.c:834
tds_bcp_directions
tds_bcp_directions
bcp direction
Definition: tds.h:1652
tdsdaterec::dayofyear
TDS_INT dayofyear
day of year (1-366)
Definition: tds.h:163
TDS_STATE
enum tds_states TDS_STATE
values for tds->state
TDS_DONE_INXACT
@ TDS_DONE_INXACT
transaction in progress
Definition: tds.h:253
TDS_WRITING
@ TDS_WRITING
client is writing data
Definition: tds.h:790
tds_get_size_by_type
int tds_get_size_by_type(TDS_SERVER_TYPE servertype)
Return the number of bytes needed by specified type.
Definition: tds_types.h:9
tds_login::server_realm_name
DSTR server_realm_name
server realm name (in freetds.conf)
Definition: tds.h:526
tds_get_column_declaration
TDSRET tds_get_column_declaration(TDSSOCKET *tds, TDSCOLUMN *curcol, char *out)
Return declaration for column (like "varchar(20)").
Definition: query.c:718
tds_freeze_written
size_t tds_freeze_written(TDSFREEZE *freeze)
Compute how many bytes has been written from freeze.
Definition: packet.c:935
tds_cursor::options
TDS_TINYINT options
read only|updatable TODO use it
Definition: tds.h:941
tds_login::tds_version
TDS_USMALLINT tds_version
TDS version.
Definition: tds.h:519
tds_freeze
void tds_freeze(TDSSOCKET *tds, TDSFREEZE *freeze, unsigned size_len)
Stop writing to server and cache every packet not sending them to server.
Definition: packet.c:907
tds_submit_queryf
TDSRET tds_submit_queryf(TDSSOCKET *tds, const char *queryf,...)
Format and submit a query.
Definition: query.c:467
tds_get_usmallint
TDS_USMALLINT tds_get_usmallint(TDSSOCKET *tds)
Get an int16 from the server.
Definition: read.c:113
tds_socket
Information for a server connection.
Definition: tds.h:1162
tds_capability_type
Definition: tds.h:503
tds_get_compiletime_settings
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:1338
tds_count_placeholders
int tds_count_placeholders(const char *query)
Count the number of placeholders ('?') in a query.
Definition: query.c:571
tds_set_param_type
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_DONE_PROC
@ TDS_DONE_PROC
results are from a stored procedure
Definition: tds.h:254
tds_column::column_scale
TDS_TINYINT column_scale
scale for decimal/numeric
Definition: tds.h:703
tds_socket::in_row
bool in_row
true if we are getting rows
Definition: tds.h:1245
tds_submit_commit
TDSRET tds_submit_commit(TDSSOCKET *tds, int cont)
Send a commit request.
Definition: query.c:3721
tds_env::charset
char * charset
character set encoding
Definition: tds.h:967
tds7_get_instance_ports
int tds7_get_instance_ports(FILE *output, struct addrinfo *addr)
Get port of all instances.
Definition: net.c:1093
tds_needs_unprepare
int tds_needs_unprepare(TDSCONNECTION *conn, TDSDYNAMIC *dyn)
Check if dynamic request must be unprepared.
Definition: query.c:1752
tds_freeze::pkt
TDSPACKET * pkt
first packet frozen
Definition: tds.h:1573
tds_deferred_unprepare
TDSRET tds_deferred_unprepare(TDSCONNECTION *conn, TDSDYNAMIC *dyn)
Unprepare dynamic on idle.
Definition: query.c:1774
tds_column_funcs::put_data
tds_func_put_data * put_data
Send column data to server.
Definition: tds.h:661
tds_freeze::size_len
unsigned size_len
length size (0, 1, 2 or 4)
Definition: tds.h:1577
tds_alloc_param_data
void * tds_alloc_param_data(TDSCOLUMN *curparam)
Allocate data for a parameter.
Definition: mem.c:364
tds_cursor::next
struct tds_cursor * next
next in linked list, keep first
Definition: tds.h:937
tds_writetext_end
TDSRET tds_writetext_end(TDSSOCKET *tds)
Finish sending writetext data.
Definition: bulk.c:1200
TDSCURSOR
struct tds_cursor TDSCURSOR
Holds informations about a cursor.
tds_bcp_fread
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:1075
tds_iconv_alloc
int tds_iconv_alloc(TDSCONNECTION *conn)
Allocate iconv stuff.
Definition: iconv.c:302
tds_get_home_file
char * tds_get_home_file(const char *file)
Return filename from HOME directory.
Definition: config.c:325
TDS_ENCODING
struct tds_encoding TDS_ENCODING
Information relevant to libiconv.
tdsdaterec::weekday
TDS_INT weekday
day of week (0-6, 0 = sunday)
Definition: tds.h:164
tds_process_cancel
TDSRET tds_process_cancel(TDSSOCKET *tds)
Definition: token.c:2554
tds_convert_string
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
tds_send_cancel
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:2026
tds_process_simple_query
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
tds_context
Definition: tds.h:1028
tds_compiletime_settings
A structure to hold all the compile-time settings.
Definition: tds.h:83
tds_socket::ret_status
TDS_INT ret_status
return status from store procedure
Definition: tds.h:1249
tds_socket::cur_dyn
TDSDYNAMIC * cur_dyn
dynamic structure in use
Definition: tds.h:1255
tdsnumeric
Definition: proto.h:26
tds_login::user_name
DSTR user_name
account for login
Definition: tds.h:533
tds_skip_quoted
const char * tds_skip_quoted(const char *s)
Skip quoting string (like 'sfsf', "dflkdj" or [dfkjd])
Definition: query.c:515
tds_freeze
Definition: tds.h:1569
tds_login
Definition: tds.h:516
tds_close_socket
void tds_close_socket(TDSSOCKET *tds)
Close current socket.
Definition: net.c:548
tds_deferred_cursor_dealloc
TDSRET tds_deferred_cursor_dealloc(TDSCONNECTION *conn, TDSCURSOR *cursor)
Deallocate cursor on idle.
Definition: query.c:3054
tds_column::column_cur_size
TDS_INT column_cur_size
size written in variable (ie: char, text, binary).
Definition: tds.h:735
tds_column::char_conv
TDSICONV * char_conv
refers to previously allocated iconv information
Definition: tds.h:711
tds_set_cur_dyn
void tds_set_cur_dyn(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Set current dynamic.
Definition: query.c:192
tds_connection
Definition: tds.h:1090
tds_align_struct
Definition: tds.h:494
tds_bcp_init
TDSRET tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Initialize BCP information.
Definition: bulk.c:84
tds_login::crlfile
DSTR crlfile
certificate revocation file
Definition: tds.h:530
tds_lookup_dynamic
TDSDYNAMIC * tds_lookup_dynamic(TDSCONNECTION *conn, const char *id)
Finds a dynamic given string id.
Definition: token.c:2587
tds_start_query
void tds_start_query(TDSSOCKET *tds, unsigned char packet_type)
Start query packet of a given type.
Definition: query.c:332
TDS_DONE_ERROR
@ TDS_DONE_ERROR
error occurred
Definition: tds.h:252
tds_get_varint_size
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
tds_numeric_bytes_per_prec
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
tds_writetext_continue
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:1183
tds_column::column_size
TDS_INT column_size
maximun size of data.
Definition: tds.h:693
tds_column_funcs::put_info
tds_func_put_info * put_info
Send metadata column information to server.
Definition: tds.h:651
tds_dynamic::params
TDSPARAMINFO * params
query parameters.
Definition: tds.h:1006
TDS_COMPILETIME_SETTINGS
struct tds_compiletime_settings TDS_COMPILETIME_SETTINGS
A structure to hold all the compile-time settings.
tds_freeze_close_len
TDSRET tds_freeze_close_len(TDSFREEZE *freeze, int32_t size)
Stop keeping data for this specific freeze.
Definition: packet.c:1031
tdsdaterec::timezone
TDS_INT timezone
-840 - 840 minutes from UTC
Definition: tds.h:169
tds_cursor::defer_close
bool defer_close
true if cursor was marker to be closed when connection is idle
Definition: tds.h:945
tds_message
Definition: tds.h:875
tds_bcp_start_copy_in
TDSRET tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start bulk copy to server.
Definition: bulk.c:914
tds_dynamic::res_info
TDSPARAMINFO * res_info
query results
Definition: tds.h:998
tds_packet
Definition: tds.h:1056
tds_get_conversion_type
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
tdsdaterec
Used by tds_datecrack.
Definition: tds.h:158
tds_socket::out_flag
unsigned char out_flag
output buffer type
Definition: tds.h:1195
tds_login::server_spn
DSTR server_spn
server SPN (in freetds.conf)
Definition: tds.h:527
tds_submit_query_params
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
tds_states
tds_states
values for tds->state
Definition: tds.h:788
tds_unget_byte
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
tds_multiple
Definition: tds.h:1018
tds_goodread
int tds_goodread(TDSSOCKET *tds, unsigned char *buf, int buflen)
Loops until we have received some characters return -1 on failure.
Definition: net.c:916
tds_socket::in_cancel
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:1247
tds_release_dynamic
void tds_release_dynamic(TDSDYNAMIC **dyn)
Frees dynamic statement.
Definition: mem.c:253
tds_quote_id_rpc
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:2213
TDSVARIANT
struct tds_variant TDSVARIANT
Store variant informations.
tds_socket_set_nonblocking
int tds_socket_set_nonblocking(TDS_SYS_SOCKET sock)
Set socket to non-blocking.
Definition: net.c:168
tds_cursor::query
char * query
SQL query.
Definition: tds.h:946
TDS_DATETIMEALL::time
TDS_UINT8 time
time, 7 digit precision
Definition: tds.h:146
tds_detach_results
void tds_detach_results(TDSRESULTINFO *info)
Detach result info from it current socket.
Definition: mem.c:488
TDS_DONE_COUNT
@ TDS_DONE_COUNT
count field in packet is valid
Definition: tds.h:255
tds_free_param_result
void tds_free_param_result(TDSPARAMINFO *param_info)
Delete latest parameter.
Definition: mem.c:320
tds_login::new_password
DSTR new_password
new password to set (TDS 7.2+)
Definition: tds.h:535
tds_quote_string
size_t tds_quote_string(TDSSOCKET *tds, char *buffer, const char *str, int len)
Quote a string.
Definition: query.c:2238
tds_quote_id
size_t tds_quote_id(TDSSOCKET *tds, char *buffer, const char *id, int idlen)
Quote an id.
Definition: query.c:2168
tds_cursor::cursor_name
char * cursor_name
name of the cursor
Definition: tds.h:939
TDS_DONE_FINAL
@ TDS_DONE_FINAL
final result set, command completed successfully.
Definition: tds.h:250
tds_bcpcoldata
Definition: tds.h:627
tds_env
Current environment as reported by the server.
Definition: tds.h:962
tds_alloc_param_result
TDSPARAMINFO * tds_alloc_param_result(TDSPARAMINFO *old_param)
Adds a output parameter to TDSPARAMINFO.
Definition: mem.c:284
tds_connection::env
TDSENV env
environment is shared between all sessions
Definition: tds.h:1100
tds_env::block_size
int block_size
packet size (512-65535)
Definition: tds.h:964
tds_dynamic::next
struct tds_dynamic * next
next in linked list, keep first
Definition: tds.h:977
tds_socket::in_flag
unsigned char in_flag
input buffer type
Definition: tds.h:1194
tdsdump_close
void tdsdump_close(void)
Close the TDS dump log file.
Definition: log.c:212
tds_set_state
TDS_STATE tds_set_state(TDSSOCKET *tds, TDS_STATE state)
Set state of TDS connection, with logging and checking.
Definition: util.c:58
TDSRESULTINFO
struct tds_result_info TDSRESULTINFO
Hold information for any results.
tds71_submit_prepexec
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:1401
tds_freeze_abort
TDSRET tds_freeze_abort(TDSFREEZE *freeze)
Discard all data written after the freeze.
Definition: packet.c:961
tds_socket::in_len
unsigned in_len
input buffer length
Definition: tds.h:1193
tds_socket::out_pos
unsigned out_pos
current position in out_buf
Definition: tds.h:1192
tds_prtype
const char * tds_prtype(int token)
Returns string representation of the given type.
Definition: token.c:3032
tds_connection::pending_close
unsigned int pending_close
true is connection has pending closing (cursors or dynamic)
Definition: tds.h:1122
TDS_DEAD
@ TDS_DEAD
no connection
Definition: tds.h:794
tds_get_string
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
tds_cursor::status
TDS_CURSOR_STATUS status
cursor parameter
Definition: tds.h:952
tds_cursor::cursor_id
TDS_INT cursor_id
cursor id returned by the server after cursor declare
Definition: tds.h:940
tds_variant
Store variant informations.
Definition: tds.h:603
tdsdump_open
int tdsdump_open(const char *filename)
Create and truncate a human readable dump file for the TDS traffic.
Definition: log.c:131
tds_process_login_tokens
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
tds_dynamic::num_id
TDS_INT num_id
numeric id for mssql7+
Definition: tds.h:980
tds_skip_comment
const char * tds_skip_comment(const char *s)
Skip a comment in a query.
Definition: query.c:490
tds_get_uint8
TDS_UINT8 tds_get_uint8(TDSSOCKET *tds)
Get an uint64 from the server.
Definition: read.c:140
tds_read_packet
int tds_read_packet(TDSSOCKET *tds)
Read in one 'packet' from the server.
Definition: packet.c:527
tds_socket::in_pos
unsigned in_pos
current position in in_buf
Definition: tds.h:1191
tds_connection::product_version
TDS_UINT product_version
version of product (Sybase/MS and full version)
Definition: tds.h:1092
TDSDYNAMIC
struct tds_dynamic TDSDYNAMIC
Holds information for a dynamic (also called prepared) query.
tds_realloc
void * tds_realloc(void **pp, size_t new_size)
Reallocate a pointer and update it if success.
Definition: mem.c:1876
tds_bcpinfo
Definition: tds.h:1659
tds_headers
Definition: tds.h:573
tds_cursor_dealloc
TDSRET tds_cursor_dealloc(TDSSOCKET *tds, TDSCURSOR *cursor)
Send a deallocation request to server.
Definition: query.c:3003
tds_submit_rollback
TDSRET tds_submit_rollback(TDSSOCKET *tds, int cont)
Send a rollback request.
Definition: query.c:3690
tds_end
tds_end
Flags returned in TDS_DONE token.
Definition: tds.h:249
tdserror
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
tds_column::column_varint_size
TDS_TINYINT column_varint_size
size of length when reading from wire (0, 1, 2 or 4)
Definition: tds.h:700
tds_column::bcp_prefix_len
TDS_INT bcp_prefix_len
The length, in bytes, of any length prefix this column may have.
Definition: tds.h:760
tdsdaterec::second
TDS_INT second
0-59
Definition: tds.h:167
tdsdump_col
void tdsdump_col(const TDSCOLUMN *col)
Write a column value to the debug log.
Definition: log.c:455
tds_get_byte
unsigned char tds_get_byte(TDSSOCKET *tds)
Return a single byte from the input buffer.
Definition: read.c:72
tds_peek
unsigned char tds_peek(TDSSOCKET *tds)
Reads a byte from the TDS stream without removing it.
Definition: read.c:100
tds_socket::out_buf_max
unsigned int out_buf_max
Maximum size of packet pointed by out_buf.
Definition: tds.h:1190
TDS_DATETIMEALL::offset
TDS_SMALLINT offset
time offset
Definition: tds.h:148
tds_select
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:612
tds_goodwrite
int tds_goodwrite(TDSSOCKET *tds, const unsigned char *buffer, size_t buflen)
Definition: net.c:987
tds_numeric_to_string
TDS_INT tds_numeric_to_string(const TDS_NUMERIC *numeric, char *s)
Definition: numeric.c:95
TDS_PENDING
@ TDS_PENDING
cilent is waiting for data
Definition: tds.h:792
tds_fix_login
void tds_fix_login(TDSLOGIN *login)
Fix configuration after reading it.
Definition: config.c:285
tds_init_login
TDSLOGIN * tds_init_login(TDSLOGIN *login, TDSLOCALE *locale)
Initialize login structure with locale information and other stuff for connection.
Definition: mem.c:800
tds_alloc_dynamic
TDSDYNAMIC * tds_alloc_dynamic(TDSCONNECTION *conn, const char *id)
Allocate a dynamic statement.
Definition: mem.c:160
TDS_DONE_MORE_RESULTS
@ TDS_DONE_MORE_RESULTS
more results follow
Definition: tds.h:251
tds_cursor_status
Definition: tds.h:905
TDS_DATETIMEALL::date
TDS_INT date
date, 0 = 1900-01-01
Definition: tds.h:147
tds_freeze::pkt_pos
unsigned pkt_pos
position in pkt
Definition: tds.h:1575
tds_env::database
char * database
database name
Definition: tds.h:969
tds_column::column_type
TDS_SERVER_TYPE column_type
This type can be different from wire type because conversion (e.g.
Definition: tds.h:695
TDS_READING
@ TDS_READING
client is reading data
Definition: tds.h:793
tds_cursor::ref_count
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition: tds.h:938
tds_submit_optioncmd
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:3386
tdsdaterec::month
TDS_INT month
month number (0-11)
Definition: tds.h:161
tds_encoding::canonic
unsigned char canonic
internal numeric index into array of all encodings
Definition: tds.h:623
tdsdump_on
void tdsdump_on(TDSDUMP_OFF_ITEM *off_item)
Turn logging back on for current thread.
Definition: log.c:101