FreeTDS API
 
Loading...
Searching...
No Matches
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 */
52typedef struct tdsiconvinfo TDSICONV;
53typedef struct tds_connection TDSCONNECTION;
54typedef struct tds_socket TDSSOCKET;
55typedef struct tds_column TDSCOLUMN;
56typedef struct tds_bcpinfo TDSBCPINFO;
57
58#include <freetds/version.h>
59#include "tds_sysdep_public.h"
60#include <freetds/sysdep_private.h>
61#include <freetds/thread.h>
62#include <freetds/bool.h>
63#include <freetds/macros.h>
64#include <freetds/utils/string.h>
65#include "replacements.h"
66
67#include <freetds/pushvis.h>
68
69#ifdef __cplusplus
70extern "C"
71{
72#if 0
73}
74#endif
75#endif
76
81
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 int msdblib; /* for MS style dblib */
88 int sybase_compat; /* enable increased Open Client binary compatibility */
89 int threadsafe; /* compile for thread safety default=no */
90 int libiconv; /* search for libiconv in DIR/include and DIR/lib */
91 const char *tdsver; /* TDS protocol version (4.2/4.6/5.0/7.0/7.1) 5.0 */
92 int iodbc; /* build odbc driver against iODBC in DIR */
93 int unixodbc; /* build odbc driver against unixODBC in DIR */
94 int openssl; /* build against OpenSSL */
95 int gnutls; /* build against GnuTLS */
96 int mars; /* MARS enabled */
98
103
113
114/*
115 * All references to data that touch the wire should use the following typedefs.
116 *
117 * If you have problems on 64-bit machines and the code is
118 * using a native datatype, please change it to use
119 * these. (In the TDS layer only, the API layers have their
120 * own typedefs which equate to these).
121 */
122typedef char TDS_CHAR; /* 8-bit char */
123typedef uint8_t TDS_UCHAR; /* 8-bit uchar */
124typedef uint8_t TDS_TINYINT; /* 8-bit unsigned */
125typedef int16_t TDS_SMALLINT; /* 16-bit int */
126typedef uint16_t TDS_USMALLINT; /* 16-bit unsigned */
127typedef int32_t TDS_INT; /* 32-bit int */
128typedef uint32_t TDS_UINT; /* 32-bit unsigned */
129typedef int64_t TDS_INT8; /* 64-bit integer */
130typedef uint64_t TDS_UINT8; /* 64-bit unsigned */
131typedef intptr_t TDS_INTPTR;
132typedef uintptr_t TDS_UINTPTR;
133typedef tds_sysdep_real32_type TDS_REAL; /* 32-bit real */
134typedef 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
144typedef 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
157typedef 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;
169 TDS_INT timezone;
171
177extern const int tds_numeric_bytes_per_prec[];
178
179typedef 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
212enum 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
228enum 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{
257 , TDS_DONE_EVENT = 0x40 /* part of an event notification. */
259
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 */
275typedef 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
313enum {
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
328typedef union tds_option_arg
329{
330 TDS_TINYINT ti;
331 TDS_INT i;
332 TDS_CHAR *c;
333} TDS_OPTION_ARG;
334
335
336typedef 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
360enum {
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};
372
373extern const uint16_t tds_type_flags_ms[256];
374#if 0
375extern const uint16_t tds_type_flags_syb[256];
376extern const char *const tds_type_names[256];
377#endif
378
379#define is_fixed_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_FIXED) != 0)
380#define is_nullable_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_NULLABLE) != 0)
381#define is_variable_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_VARIABLE) != 0)
382
383
384#define is_blob_type(x) ((x)==SYBTEXT || (x)==SYBIMAGE || (x)==SYBNTEXT)
385#define is_blob_col(x) ((x)->column_varint_size > 2)
386/* large type means it has a two byte size field */
387/* define is_large_type(x) (x>128) */
388#define is_numeric_type(x) ((x)==SYBNUMERIC || (x)==SYBDECIMAL)
390#define is_datetime_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_DATETIME) != 0)
391#define is_unicode_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_UNICODE) != 0)
392#define is_collate_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_COLLATE) != 0)
393#define is_ascii_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_ASCII) != 0)
394#define is_binary_type(x) ((tds_type_flags_ms[x] & TDS_TYPEFLAG_BINARY) != 0)
395#define is_char_type(x) ((tds_type_flags_ms[x] & (TDS_TYPEFLAG_ASCII|TDS_TYPEFLAG_UNICODE)) != 0)
396#define is_similar_type(x, y) (is_char_type(x) && is_char_type(y))
397static inline
398bool is_tds_type_valid(int type)
399{
400 return (unsigned) type < 256u && tds_type_flags_ms[type] != 0;
401}
402
403
404#define TDS_MAX_CAPABILITY 32
405#define MAXPRECISION 77
406#define TDS_MAX_CONN 4096
407#define TDS_MAX_DYNID_LEN 30
408
409/* defaults to use if no others are found */
410#define TDS_DEF_SERVER "SYBASE"
411#define TDS_DEF_BLKSZ 512
412#define TDS_DEF_CHARSET "iso_1"
413#define TDS_DEF_LANG "us_english"
414#if TDS50
415#define TDS_DEFAULT_VERSION 0x500
416#define TDS_DEF_PORT 4000
417#elif TDS71
418#define TDS_DEFAULT_VERSION 0x701
419#define TDS_DEF_PORT 1433
420#elif TDS72
421#define TDS_DEFAULT_VERSION 0x702
422#define TDS_DEF_PORT 1433
423#elif TDS73
424#define TDS_DEFAULT_VERSION 0x703
425#define TDS_DEF_PORT 1433
426#elif TDS74
427#define TDS_DEFAULT_VERSION 0x704
428#define TDS_DEF_PORT 1433
429#else
430#define TDS_DEFAULT_VERSION 0x000
431#define TDS_DEF_PORT 1433
432#endif
433
434/* normalized strings from freetds.conf file */
435#define TDS_STR_VERSION "tds version"
436#define TDS_STR_BLKSZ "initial block size"
437#define TDS_STR_SWAPDT "swap broken dates"
438#define TDS_STR_DUMPFILE "dump file"
439#define TDS_STR_DEBUGLVL "debug level"
440#define TDS_STR_DEBUGFLAGS "debug flags"
441#define TDS_STR_TIMEOUT "timeout"
442#define TDS_STR_QUERY_TIMEOUT "query timeout"
443#define TDS_STR_CONNTIMEOUT "connect timeout"
444#define TDS_STR_HOSTNAME "hostname"
445#define TDS_STR_HOST "host"
446#define TDS_STR_PORT "port"
447#define TDS_STR_TEXTSZ "text size"
448/* for big endian hosts */
449#define TDS_STR_EMUL_LE "emulate little endian"
450#define TDS_STR_CHARSET "charset"
451#define TDS_STR_CLCHARSET "client charset"
452#define TDS_STR_USE_UTF_16 "use utf-16"
453#define TDS_STR_LANGUAGE "language"
454#define TDS_STR_APPENDMODE "dump file append"
455#define TDS_STR_DATEFMT "date format"
456#define TDS_STR_INSTANCE "instance"
457#define TDS_STR_ASA_DATABASE "asa database"
458#define TDS_STR_DATABASE "database"
459#define TDS_STR_ENCRYPTION "encryption"
460#define TDS_STR_USENTLMV2 "use ntlmv2"
461#define TDS_STR_USELANMAN "use lanman"
462/* conf values */
463#define TDS_STR_ENCRYPTION_OFF "off"
464#define TDS_STR_ENCRYPTION_REQUEST "request"
465#define TDS_STR_ENCRYPTION_REQUIRE "require"
466/* Defines to enable optional GSSAPI delegation */
467#define TDS_GSSAPI_DELEGATION "enable gssapi delegation"
468/* Kerberos realm name */
469#define TDS_STR_REALM "realm"
470/* Kerberos SPN */
471#define TDS_STR_SPN "spn"
472/* CA file */
473#define TDS_STR_CAFILE "ca file"
474/* CRL file */
475#define TDS_STR_CRLFILE "crl file"
476/* check SSL hostname */
477#define TDS_STR_CHECKSSLHOSTNAME "check certificate hostname"
478/* database filename to attach on login (MSSQL) */
479#define TDS_STR_DBFILENAME "database filename"
480/* Application Intent MSSQL 2012 support */
481#define TDS_STR_READONLY_INTENT "read-only intent"
482/* configurable cipher suite to send to openssl's SSL_set_cipher_list() function */
483#define TLS_STR_OPENSSL_CIPHERS "openssl ciphers"
484/* enable old TLS v1, required for instance if you are using a really old Windows XP */
485#define TDS_STR_ENABLE_TLS_V1 "enable tls v1"
486
487
488/* TODO do a better check for alignment than this */
489typedef union
490{
491 void *p;
492 int i;
493 int64_t ui;
495
496#define TDS_ALIGN_SIZE sizeof(tds_align_struct)
497
499{
500 unsigned char type;
501 unsigned char len; /* always sizeof(values) */
502 unsigned char values[TDS_MAX_CAPABILITY/2-2];
503} TDS_CAPABILITY_TYPE;
504
505typedef struct tds_capabilities
506{
507 TDS_CAPABILITY_TYPE types[2];
508} TDS_CAPABILITIES;
509
510#define TDS_MAX_LOGIN_STR_SZ 128
511typedef struct tds_login
512{
514 int port;
515 TDS_USMALLINT tds_version;
516 int block_size;
517 DSTR language; /* e.g. us-english */
519 TDS_INT connect_timeout;
520 DSTR client_host_name;
521 DSTR server_host_name;
527 DSTR openssl_ciphers;
528 DSTR app_name;
532
533 DSTR library; /* Ct-Library, DB-Library, TDS-Library or ODBC */
534 TDS_TINYINT encryption_level;
535
536 TDS_INT query_timeout;
537 TDS_CAPABILITIES capabilities;
538 DSTR client_charset;
539 DSTR database;
540
541 struct addrinfo *ip_addrs;
542 DSTR instance_name;
543 DSTR dump_file;
544 int debug_flags;
545 int text_size;
546 DSTR routing_address;
547 uint16_t routing_port;
548
549 unsigned char option_flag2;
550
551 unsigned int bulk_copy:1;
552 unsigned int suppress_language:1;
553 unsigned int emul_little_endian:1;
554 unsigned int gssapi_use_delegation:1;
555 unsigned int use_ntlmv2:1;
556 unsigned int use_ntlmv2_specified:1;
557 unsigned int use_lanman:1;
558 unsigned int mars:1;
559 unsigned int use_utf16:1;
560 unsigned int use_new_password:1;
561 unsigned int valid_configuration:1;
562 unsigned int check_ssl_hostname:1;
563 unsigned int readonly_intent:1;
564 unsigned int enable_tls_v1:1;
565 unsigned int server_is_valid:1;
566} TDSLOGIN;
567
568typedef struct tds_headers
569{
570 const char *qn_options;
571 const char *qn_msgtext;
572 TDS_INT qn_timeout;
573 /* TDS 7.4+: trace activity ID char[20] */
574} TDSHEADERS;
575
576typedef struct tds_locale
577{
578 char *language;
579 char *server_charset;
580 char *date_fmt;
581} TDSLOCALE;
582
587typedef struct tds_blob
588{
589 TDS_CHAR *textvalue;
590 TDS_CHAR textptr[16];
591 TDS_CHAR timestamp[8];
592 unsigned char valid_ptr;
594
598typedef struct tds_variant
599{
600 /* this MUST have same position and place of textvalue in tds_blob */
601 TDS_CHAR *data;
602 TDS_INT size;
603 TDS_INT data_len;
604 TDS_SERVER_TYPE type;
605 TDS_UCHAR collation[5];
607
612typedef struct tds_encoding
613{
615 const char *name;
616 unsigned char min_bytes_per_char;
617 unsigned char max_bytes_per_char;
619 unsigned char canonic;
621
622typedef struct tds_bcpcoldata
623{
624 TDS_UCHAR *data;
625 TDS_INT datalen;
626 TDS_INT is_null;
627} BCPCOLDATA;
628
629
630typedef TDSRET tds_func_get_info(TDSSOCKET *tds, TDSCOLUMN *col);
631typedef TDSRET tds_func_get_data(TDSSOCKET *tds, TDSCOLUMN *col);
632typedef TDS_INT tds_func_row_len(TDSCOLUMN *col);
633typedef unsigned tds_func_put_info_len(TDSSOCKET *tds, TDSCOLUMN *col);
634typedef TDSRET tds_func_put_info(TDSSOCKET *tds, TDSCOLUMN *col);
635typedef TDSRET tds_func_put_data(TDSSOCKET *tds, TDSCOLUMN *col, int bcp7);
636typedef int tds_func_check(const TDSCOLUMN *col);
637
638typedef struct tds_column_funcs
639{
640 tds_func_get_info *get_info;
641 tds_func_get_data *get_data;
642 tds_func_row_len *row_len;
648 tds_func_put_info_len *put_info_len;
654 tds_func_put_info *put_info;
664 tds_func_put_data *put_data;
665#if ENABLE_EXTRA_CHECKS
680 tds_func_check *check;
681#endif
682#if 0
683 TDSRET (*convert)(TDSSOCKET *tds, TDSCOLUMN *col);
684#endif
685} TDSCOLUMNFUNCS;
686
691{
692 const TDSCOLUMNFUNCS *funcs;
693 TDS_INT column_usertype;
694 TDS_INT column_flags;
695
696 TDS_INT column_size;
697
698 TDS_SERVER_TYPE column_type;
703 TDS_TINYINT column_varint_size;
704
705 TDS_TINYINT column_prec;
706 TDS_TINYINT column_scale;
707
708 struct
709 {
710 TDS_SERVER_TYPE column_type;
711 TDS_INT column_size;
712 } on_server;
713
714 TDSICONV *char_conv;
715
716 DSTR table_name;
717 DSTR column_name;
718 DSTR table_column_name;
719
720 unsigned char *column_data;
721 void (*column_data_free)(struct tds_column *column);
722 unsigned char column_nullable:1;
723 unsigned char column_writeable:1;
724 unsigned char column_identity:1;
725 unsigned char column_key:1;
726 unsigned char column_hidden:1;
727 unsigned char column_output:1;
728 unsigned char column_timestamp:1;
729 unsigned char column_computed:1;
730 TDS_UCHAR column_collation[5];
731
732 /* additional fields flags for compute results */
733 TDS_SMALLINT column_operand;
734 TDS_TINYINT column_operator;
735
736 /* FIXME this is data related, not column */
739
740 /* related to binding or info stored by client libraries */
741 /* FIXME find a best place to store these data, some are unused */
742 TDS_SMALLINT column_bindtype;
743 TDS_SMALLINT column_bindfmt;
744 TDS_UINT column_bindlen;
745 TDS_SMALLINT *column_nullbind;
746 TDS_CHAR *column_varaddr;
747 TDS_INT *column_lenbind;
748 TDS_INT column_textpos;
749 TDS_INT column_text_sqlgetdatapos;
750 TDS_CHAR column_text_sqlputdatainfo;
751 unsigned char column_iconv_left;
752 char column_iconv_buf[9];
753
754 BCPCOLDATA *bcp_column_data;
764 TDS_INT bcp_term_len;
765 TDS_CHAR *bcp_terminator;
766};
767
768
770typedef struct tds_result_info
771{
772 /* TODO those fields can became a struct */
773 TDSCOLUMN **columns;
774 TDS_USMALLINT num_cols;
775 TDS_USMALLINT computeid;
776 TDS_INT ref_count;
777 TDSSOCKET *attached_to;
778 unsigned char *current_row;
779 void (*row_free)(struct tds_result_info* result, unsigned char *row);
780 TDS_INT row_size;
781
782 TDS_SMALLINT *bycolumns;
783 TDS_USMALLINT by_cols;
784 bool rows_exist;
785 /* TODO remove ?? used only in dblib */
786 bool more_results;
788
799
800typedef enum tds_operations
801{
802 TDS_OP_NONE = 0,
803
804 /* mssql operations */
805 TDS_OP_CURSOR = TDS_SP_CURSOR,
806 TDS_OP_CURSOROPEN = TDS_SP_CURSOROPEN,
807 TDS_OP_CURSORPREPARE = TDS_SP_CURSORPREPARE,
808 TDS_OP_CURSOREXECUTE = TDS_SP_CURSOREXECUTE,
809 TDS_OP_CURSORPREPEXEC = TDS_SP_CURSORPREPEXEC,
810 TDS_OP_CURSORUNPREPARE = TDS_SP_CURSORUNPREPARE,
811 TDS_OP_CURSORFETCH = TDS_SP_CURSORFETCH,
812 TDS_OP_CURSOROPTION = TDS_SP_CURSOROPTION,
813 TDS_OP_CURSORCLOSE = TDS_SP_CURSORCLOSE,
814 TDS_OP_EXECUTESQL = TDS_SP_EXECUTESQL,
815 TDS_OP_PREPARE = TDS_SP_PREPARE,
816 TDS_OP_EXECUTE = TDS_SP_EXECUTE,
817 TDS_OP_PREPEXEC = TDS_SP_PREPEXEC,
818 TDS_OP_PREPEXECRPC = TDS_SP_PREPEXECRPC,
819 TDS_OP_UNPREPARE = TDS_SP_UNPREPARE,
820
821 /* sybase operations */
822 TDS_OP_DYN_DEALLOC = 100,
823} TDS_OPERATION;
824
825#define TDS_DBG_LOGIN __FILE__, ((__LINE__ << 4) | 11)
826#define TDS_DBG_HEADER __FILE__, ((__LINE__ << 4) | 10)
827#define TDS_DBG_FUNC __FILE__, ((__LINE__ << 4) | 7)
828#define TDS_DBG_INFO2 __FILE__, ((__LINE__ << 4) | 6)
829#define TDS_DBG_INFO1 __FILE__, ((__LINE__ << 4) | 5)
830#define TDS_DBG_NETWORK __FILE__, ((__LINE__ << 4) | 4)
831#define TDS_DBG_WARN __FILE__, ((__LINE__ << 4) | 3)
832#define TDS_DBG_ERROR __FILE__, ((__LINE__ << 4) | 2)
833#define TDS_DBG_SEVERE __FILE__, ((__LINE__ << 4) | 1)
834
835#define TDS_DBGFLAG_FUNC 0x80
836#define TDS_DBGFLAG_INFO2 0x40
837#define TDS_DBGFLAG_INFO1 0x20
838#define TDS_DBGFLAG_NETWORK 0x10
839#define TDS_DBGFLAG_WARN 0x08
840#define TDS_DBGFLAG_ERROR 0x04
841#define TDS_DBGFLAG_SEVERE 0x02
842#define TDS_DBGFLAG_ALL 0xfff
843#define TDS_DBGFLAG_LOGIN 0x0800
844#define TDS_DBGFLAG_HEADER 0x0400
845#define TDS_DBGFLAG_PID 0x1000
846#define TDS_DBGFLAG_TIME 0x2000
847#define TDS_DBGFLAG_SOURCE 0x4000
848#define TDS_DBGFLAG_THREAD 0x8000
849
850#if 0
856enum TDS_DBG_LOG_STATE
857{
858 TDS_DBG_LOGIN = (1 << 0)
860 , TDS_DBG_API = (1 << 1)
861 , TDS_DBG_ASYNC = (1 << 2)
862 , TDS_DBG_DIAG = (1 << 3)
863 , TDS_DBG_error = (1 << 4)
864 /* TODO: ^^^^^ make upper case when old #defines (above) are removed */
865 /* Log FreeTDS runtime/logic error occurs. */
866 , TDS_DBG_PACKET = (1 << 5)
867 , TDS_DBG_LIBTDS = (1 << 6)
868 , TDS_DBG_CONFIG = (1 << 7)
869 , TDS_DBG_DEFAULT = 0xFE
870};
871#endif
872
873typedef struct tds_result_info TDSCOMPUTEINFO;
874
875typedef TDSRESULTINFO TDSPARAMINFO;
876
877typedef struct tds_message
878{
879 TDS_CHAR *server;
880 TDS_CHAR *message;
881 TDS_CHAR *proc_name;
882 TDS_CHAR *sql_state;
883 TDS_INT msgno;
884 TDS_INT line_number;
885 /* -1 .. 255 */
886 TDS_SMALLINT state;
887 TDS_TINYINT priv_msg_type;
888 TDS_TINYINT severity;
889 /* for library-generated errors */
890 int oserr;
891} TDSMESSAGE;
892
893typedef struct tds_upd_col
894{
895 struct tds_upd_col *next;
896 TDS_INT colnamelength;
897 char * columnname;
898} TDSUPDCOL;
899
900typedef enum {
901 TDS_CURSOR_STATE_UNACTIONED = 0 /* initial value */
902 , TDS_CURSOR_STATE_REQUESTED = 1 /* called by ct_cursor */
903 , TDS_CURSOR_STATE_SENT = 2 /* sent to server */
904 , TDS_CURSOR_STATE_ACTIONED = 3 /* acknowledged by server */
905} TDS_CURSOR_STATE;
906
907typedef struct tds_cursor_status
908{
909 TDS_CURSOR_STATE declare;
910 TDS_CURSOR_STATE cursor_row;
911 TDS_CURSOR_STATE open;
912 TDS_CURSOR_STATE fetch;
913 TDS_CURSOR_STATE close;
914 TDS_CURSOR_STATE dealloc;
915} TDS_CURSOR_STATUS;
916
917typedef enum tds_cursor_operation
918{
919 TDS_CURSOR_POSITION = 0,
920 TDS_CURSOR_UPDATE = 1,
921 TDS_CURSOR_DELETE = 2,
922 TDS_CURSOR_INSERT = 4
923} TDS_CURSOR_OPERATION;
924
925typedef enum tds_cursor_fetch
926{
927 TDS_CURSOR_FETCH_NEXT = 1,
928 TDS_CURSOR_FETCH_PREV,
929 TDS_CURSOR_FETCH_FIRST,
930 TDS_CURSOR_FETCH_LAST,
931 TDS_CURSOR_FETCH_ABSOLUTE,
932 TDS_CURSOR_FETCH_RELATIVE
933} TDS_CURSOR_FETCH;
934
938typedef struct tds_cursor
939{
940 struct tds_cursor *next;
941 TDS_INT ref_count;
943 TDS_INT cursor_id;
944 TDS_TINYINT options;
949 char *query;
950 /* TODO for updatable columns */
951 /* TDS_TINYINT number_upd_cols; */
952 /* TDSUPDCOL *cur_col_list; */
953 TDS_INT cursor_rows;
954 /* TDSPARAMINFO *params; */
955 TDS_CURSOR_STATUS status;
956 TDS_USMALLINT srv_status;
957 TDSRESULTINFO *res_info;
958 TDS_INT type, concurrency;
960
964typedef struct tds_env
965{
968 char *language;
970 char *charset;
972 char *database;
974
978typedef struct tds_dynamic
979{
981 TDS_INT ref_count;
983 TDS_INT num_id;
989 char id[30];
995 TDS_TINYINT emulated;
1000 /* int dyn_state; */ /* TODO use it */
1001 TDSPARAMINFO *res_info;
1009 TDSPARAMINFO *params;
1011 char *query;
1013
1014typedef enum {
1015 TDS_MULTIPLE_QUERY,
1016 TDS_MULTIPLE_EXECUTE,
1017 TDS_MULTIPLE_RPC
1018} TDS_MULTIPLE_TYPE;
1019
1020typedef struct tds_multiple
1021{
1022 TDS_MULTIPLE_TYPE type;
1023 unsigned int flags;
1024} TDSMULTIPLE;
1025
1026/* forward declaration */
1027typedef struct tds_context TDSCONTEXT;
1028typedef int (*err_handler_t) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1029
1031{
1032 TDSLOCALE *locale;
1033 void *parent;
1034 /* handlers */
1035 int (*msg_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1036 int (*err_handler) (const TDSCONTEXT *, TDSSOCKET *, TDSMESSAGE *);
1037 int (*int_handler) (void *);
1038 bool money_use_2_digits;
1039};
1040
1041enum TDS_ICONV_ENTRY
1042{
1043 client2ucs2
1044 , client2server_chardata
1045 , initial_char_conv_count /* keep last */
1046};
1047
1049{
1050 uint8_t *packet;
1051 int packet_len;
1052 TDSRET (*free)(TDSCONNECTION* conn, struct tds_authentication * auth);
1053 TDSRET (*handle_next)(TDSSOCKET * tds, struct tds_authentication * auth, size_t len);
1054} TDSAUTHENTICATION;
1055
1056typedef struct tds_packet
1057{
1058 struct tds_packet *next;
1059 short sid;
1060 unsigned len, capacity;
1061 unsigned char buf[1];
1062} TDSPACKET;
1063
1064typedef struct tds_poll_wakeup
1065{
1066 TDS_SYS_SOCKET s_signal, s_signaled;
1067} TDSPOLLWAKEUP;
1068
1069/* field related to connection */
1071{
1072 TDS_USMALLINT tds_version;
1074 char *product_name;
1075
1076 TDS_SYS_SOCKET s;
1077 TDSPOLLWAKEUP wakeup;
1078 const TDSCONTEXT *tds_ctx;
1079
1082
1093
1094 int char_conv_count;
1095 TDSICONV **char_convs;
1096
1097 TDS_UCHAR collation[5];
1098 TDS_UCHAR tds72_transaction[8];
1099
1100 TDS_CAPABILITIES capabilities;
1101 unsigned int emul_little_endian:1;
1102 unsigned int use_iconv:1;
1103 unsigned int tds71rev1:1;
1104 unsigned int pending_close:1;
1105 unsigned int encrypt_single_packet:1;
1106#if ENABLE_ODBC_MARS
1107 unsigned int mars:1;
1108
1109 TDSSOCKET *in_net_tds;
1110 TDSPACKET *packets;
1111 TDSPACKET *recv_packet;
1112 TDSPACKET *send_packets;
1113 unsigned send_pos, recv_pos;
1114
1115 tds_mutex list_mtx;
1116#define BUSY_SOCKET ((TDSSOCKET*)(TDS_UINTPTR)1)
1117#define TDSSOCKET_VALID(tds) (((TDS_UINTPTR)(tds)) > 1)
1118 struct tds_socket **sessions;
1119 unsigned num_sessions;
1120 unsigned num_cached_packets;
1121 TDSPACKET *packet_cache;
1122#endif
1123
1124 int spid;
1125 int client_spid;
1126
1127 void *tls_session;
1128#if defined(HAVE_GNUTLS)
1129 void *tls_credentials;
1130#elif defined(HAVE_OPENSSL)
1131 void *tls_ctx;
1132#else
1133 void *tls_dummy;
1134#endif
1135 TDSAUTHENTICATION *authentication;
1136 char *server;
1137};
1138
1143{
1144#if ENABLE_ODBC_MARS
1145 TDSCONNECTION *conn;
1146#else
1147 TDSCONNECTION conn[1];
1148#endif
1149
1155 unsigned char *in_buf;
1156
1162 unsigned char *out_buf;
1163
1168 unsigned int out_buf_max;
1169 unsigned in_pos;
1170 unsigned out_pos;
1171 unsigned in_len;
1172 unsigned char in_flag;
1173 unsigned char out_flag;
1174
1175 void *parent;
1176
1177#if ENABLE_ODBC_MARS
1178 short sid;
1179 tds_condition packet_cond;
1180 TDS_UINT recv_seq;
1181 TDS_UINT send_seq;
1182 TDS_UINT recv_wnd;
1183 TDS_UINT send_wnd;
1184#endif
1185 /* packet we received */
1186 TDSPACKET *recv_packet;
1188 TDSPACKET *send_packet;
1189
1196 TDSRESULTINFO *res_info;
1197 TDS_UINT num_comp_info;
1198 TDSCOMPUTEINFO **comp_info;
1199 TDSPARAMINFO *param_info;
1203 bool in_row;
1204 TDS_INT ret_status;
1205 TDS_STATE state;
1206 volatile
1207 unsigned char in_cancel;
1209
1210 TDS_INT8 rows_affected;
1211 TDS_INT query_timeout;
1212
1214
1215 TDSLOGIN *login;
1216
1217 void (*env_chg_func) (TDSSOCKET * tds, int type, char *oldval, char *newval);
1218 TDS_OPERATION current_op;
1219
1220 int option_value;
1221 tds_mutex wire_mtx;
1222};
1223
1224#define tds_get_ctx(tds) ((tds)->conn->tds_ctx)
1225#define tds_set_ctx(tds, val) do { ((tds)->conn->tds_ctx) = (val); } while(0)
1226#define tds_get_parent(tds) ((tds)->parent)
1227#define tds_set_parent(tds, val) do { ((tds)->parent) = (val); } while(0)
1228#define tds_get_s(tds) ((tds)->conn->s)
1229#define tds_set_s(tds, val) do { ((tds)->conn->s) = (val); } while(0)
1230
1231
1232/* config.c */
1234typedef void (*TDSCONFPARSE) (const char *option, const char *value, void *param);
1235bool tds_read_conf_section(FILE * in, const char *section, TDSCONFPARSE tds_conf_parse, void *parse_param);
1236bool tds_read_conf_file(TDSLOGIN * login, const char *server);
1237void tds_parse_conf_section(const char *option, const char *value, void *param);
1238TDSLOGIN *tds_read_config_info(TDSSOCKET * tds, TDSLOGIN * login, TDSLOCALE * locale);
1239void tds_fix_login(TDSLOGIN* login);
1240TDS_USMALLINT * tds_config_verstr(const char *tdsver, TDSLOGIN* login);
1241struct addrinfo *tds_lookup_host(const char *servername);
1242TDSRET tds_lookup_host_set(const char *servername, struct addrinfo **addr);
1243const char *tds_addrinfo2str(struct addrinfo *addr, char *name, int namemax);
1244char *tds_get_home_file(const char *file);
1245
1246TDSRET tds_set_interfaces_file_loc(const char *interfloc);
1247extern const char STD_DATETIME_FMT[];
1248int tds_parse_boolean(const char *value, int default_value);
1249int tds_config_boolean(const char *option, const char *value, TDSLOGIN * login);
1250
1251TDSLOCALE *tds_get_locale(void);
1252TDSRET tds_alloc_row(TDSRESULTINFO * res_info);
1253TDSRET tds_alloc_compute_row(TDSCOMPUTEINFO * res_info);
1254BCPCOLDATA * tds_alloc_bcp_column_data(unsigned int column_size);
1255TDSDYNAMIC *tds_lookup_dynamic(TDSCONNECTION * conn, const char *id);
1256/*@observer@*/ const char *tds_prtype(int token);
1257int tds_get_varint_size(TDSCONNECTION * conn, int datatype);
1258TDS_SERVER_TYPE tds_get_cardinal_type(TDS_SERVER_TYPE datatype, int usertype);
1259
1260
1261/* iconv.c */
1262TDSRET tds_iconv_open(TDSCONNECTION * conn, const char *charset, int use_utf16);
1263void tds_iconv_close(TDSCONNECTION * conn);
1264void tds_srv_charset_changed(TDSCONNECTION * conn, const char *charset);
1265void tds7_srv_charset_changed(TDSCONNECTION * conn, int sql_collate, int lcid);
1266int tds_iconv_alloc(TDSCONNECTION * conn);
1267void tds_iconv_free(TDSCONNECTION * conn);
1268TDSICONV *tds_iconv_from_collate(TDSCONNECTION * conn, TDS_UCHAR collate[5]);
1269
1270
1271/* mem.c */
1272void tds_free_socket(TDSSOCKET * tds);
1273void tds_free_all_results(TDSSOCKET * tds);
1274void tds_free_results(TDSRESULTINFO * res_info);
1275void tds_free_param_results(TDSPARAMINFO * param_info);
1276void tds_free_param_result(TDSPARAMINFO * param_info);
1277void tds_free_msg(TDSMESSAGE * message);
1278void tds_cursor_deallocated(TDSCONNECTION *conn, TDSCURSOR *cursor);
1279void tds_release_cursor(TDSCURSOR **pcursor);
1280void tds_free_bcp_column_data(BCPCOLDATA * coldata);
1281TDSRESULTINFO *tds_alloc_results(TDS_USMALLINT num_cols);
1282TDSCOMPUTEINFO **tds_alloc_compute_results(TDSSOCKET * tds, TDS_USMALLINT num_cols, TDS_USMALLINT by_cols);
1283TDSCONTEXT *tds_alloc_context(void * parent);
1284void tds_free_context(TDSCONTEXT * locale);
1285TDSPARAMINFO *tds_alloc_param_result(TDSPARAMINFO * old_param);
1287void tds_release_dynamic(TDSDYNAMIC ** dyn);
1288static inline
1289void tds_release_cur_dyn(TDSSOCKET * tds)
1290{
1292}
1293void tds_dynamic_deallocated(TDSCONNECTION *conn, TDSDYNAMIC *dyn);
1294void tds_set_cur_dyn(TDSSOCKET *tds, TDSDYNAMIC *dyn);
1295TDSSOCKET *tds_realloc_socket(TDSSOCKET * tds, size_t bufsize);
1296char *tds_alloc_client_sqlstate(int msgno);
1297char *tds_alloc_lookup_sqlstate(TDSSOCKET * tds, int msgno);
1298TDSLOGIN *tds_alloc_login(int use_environment);
1299TDSDYNAMIC *tds_alloc_dynamic(TDSCONNECTION * conn, const char *id);
1300void tds_free_login(TDSLOGIN * login);
1301TDSLOGIN *tds_init_login(TDSLOGIN * login, TDSLOCALE * locale);
1302TDSLOCALE *tds_alloc_locale(void);
1303void *tds_alloc_param_data(TDSCOLUMN * curparam);
1304void tds_free_locale(TDSLOCALE * locale);
1305TDSCURSOR * tds_alloc_cursor(TDSSOCKET * tds, const char *name, TDS_INT namelen, const char *query, TDS_INT querylen);
1306void tds_free_row(TDSRESULTINFO * res_info, unsigned char *row);
1307TDSSOCKET *tds_alloc_socket(TDSCONTEXT * context, unsigned int bufsize);
1308TDSSOCKET *tds_alloc_additional_socket(TDSCONNECTION *conn);
1309void tds_set_current_results(TDSSOCKET *tds, TDSRESULTINFO *info);
1311void * tds_realloc(void **pp, size_t new_size);
1312#define TDS_RESIZE(p, n_elem) \
1313 tds_realloc((void **) &(p), sizeof(*(p)) * (size_t) (n_elem))
1314#define tds_new(type, n) ((type *) malloc(sizeof(type) * (n)))
1315#define tds_new0(type, n) ((type *) calloc(n, sizeof(type)))
1316
1317TDSPACKET *tds_alloc_packet(void *buf, unsigned len);
1318TDSPACKET *tds_realloc_packet(TDSPACKET *packet, unsigned len);
1319void tds_free_packets(TDSPACKET *packet);
1320TDSBCPINFO *tds_alloc_bcpinfo(void);
1321void tds_free_bcpinfo(TDSBCPINFO *bcpinfo);
1322void tds_deinit_bcpinfo(TDSBCPINFO *bcpinfo);
1323
1324
1325/* login.c */
1326void tds_set_packet(TDSLOGIN * tds_login, int packet_size);
1327void tds_set_port(TDSLOGIN * tds_login, int port);
1328bool tds_set_passwd(TDSLOGIN * tds_login, const char *password) TDS_WUR;
1329void tds_set_bulk(TDSLOGIN * tds_login, bool enabled);
1330bool tds_set_user(TDSLOGIN * tds_login, const char *username) TDS_WUR;
1331bool tds_set_app(TDSLOGIN * tds_login, const char *application) TDS_WUR;
1332bool tds_set_host(TDSLOGIN * tds_login, const char *hostname) TDS_WUR;
1333bool tds_set_library(TDSLOGIN * tds_login, const char *library) TDS_WUR;
1334bool tds_set_server(TDSLOGIN * tds_login, const char *server) TDS_WUR;
1335bool tds_set_client_charset(TDSLOGIN * tds_login, const char *charset) TDS_WUR;
1336bool tds_set_language(TDSLOGIN * tds_login, const char *language) TDS_WUR;
1337void tds_set_version(TDSLOGIN * tds_login, TDS_TINYINT major_ver, TDS_TINYINT minor_ver);
1338int tds_connect_and_login(TDSSOCKET * tds, TDSLOGIN * login);
1339
1340
1341/* query.c */
1342void tds_start_query(TDSSOCKET *tds, unsigned char packet_type);
1343
1344TDSRET tds_submit_query(TDSSOCKET * tds, const char *query);
1345TDSRET tds_submit_query_params(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params, TDSHEADERS * head);
1346TDSRET tds_submit_queryf(TDSSOCKET * tds, const char *queryf, ...);
1347TDSRET tds_submit_prepare(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1348TDSRET tds_submit_execdirect(TDSSOCKET * tds, const char *query, TDSPARAMINFO * params, TDSHEADERS * head);
1349TDSRET tds71_submit_prepexec(TDSSOCKET * tds, const char *query, const char *id, TDSDYNAMIC ** dyn_out, TDSPARAMINFO * params);
1350TDSRET tds_submit_execute(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1351TDSRET tds_send_cancel(TDSSOCKET * tds);
1352const char *tds_next_placeholder(const char *start);
1353int tds_count_placeholders(const char *query);
1354int tds_needs_unprepare(TDSCONNECTION * conn, TDSDYNAMIC * dyn);
1355TDSRET tds_deferred_unprepare(TDSCONNECTION * conn, TDSDYNAMIC * dyn);
1356TDSRET tds_submit_unprepare(TDSSOCKET * tds, TDSDYNAMIC * dyn);
1357TDSRET tds_submit_rpc(TDSSOCKET * tds, const char *rpc_name, TDSPARAMINFO * params, TDSHEADERS * head);
1358TDSRET tds_submit_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD command, TDS_OPTION option, TDS_OPTION_ARG *param, TDS_INT param_size);
1359TDSRET tds_submit_begin_tran(TDSSOCKET *tds);
1360TDSRET tds_submit_rollback(TDSSOCKET *tds, int cont);
1361TDSRET tds_submit_commit(TDSSOCKET *tds, int cont);
1362TDSRET tds_disconnect(TDSSOCKET * tds);
1363size_t tds_quote_id(TDSSOCKET * tds, char *buffer, const char *id, int idlen);
1364size_t tds_quote_string(TDSSOCKET * tds, char *buffer, const char *str, int len);
1365const char *tds_skip_comment(const char *s);
1366const char *tds_skip_quoted(const char *s);
1367size_t tds_fix_column_size(TDSSOCKET * tds, TDSCOLUMN * curcol);
1368const char *tds_convert_string(TDSSOCKET * tds, TDSICONV * char_conv, const char *s, int len, size_t *out_len);
1369void tds_convert_string_free(const char *original, const char *converted);
1370#if !ENABLE_EXTRA_CHECKS
1371#define tds_convert_string_free(original, converted) \
1372 do { if (original != converted) free((char*) converted); } while(0)
1373#endif
1374TDSRET tds_get_column_declaration(TDSSOCKET * tds, TDSCOLUMN * curcol, char *out);
1375
1376TDSRET tds_cursor_declare(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1377TDSRET tds_cursor_setrows(TDSSOCKET * tds, TDSCURSOR * cursor, int *send);
1378TDSRET tds_cursor_open(TDSSOCKET * tds, TDSCURSOR * cursor, TDSPARAMINFO *params, int *send);
1379TDSRET tds_cursor_fetch(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_FETCH fetch_type, TDS_INT i_row);
1380TDSRET tds_cursor_get_cursor_info(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_UINT * row_number, TDS_UINT * row_count);
1381TDSRET tds_cursor_close(TDSSOCKET * tds, TDSCURSOR * cursor);
1382TDSRET tds_cursor_dealloc(TDSSOCKET * tds, TDSCURSOR * cursor);
1383TDSRET tds_deferred_cursor_dealloc(TDSCONNECTION *conn, TDSCURSOR * cursor);
1384TDSRET tds_cursor_update(TDSSOCKET * tds, TDSCURSOR * cursor, TDS_CURSOR_OPERATION op, TDS_INT i_row, TDSPARAMINFO * params);
1385TDSRET tds_cursor_setname(TDSSOCKET * tds, TDSCURSOR * cursor);
1386
1387TDSRET tds_multiple_init(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDS_MULTIPLE_TYPE type, TDSHEADERS * head);
1388TDSRET tds_multiple_done(TDSSOCKET *tds, TDSMULTIPLE *multiple);
1389TDSRET tds_multiple_query(TDSSOCKET *tds, TDSMULTIPLE *multiple, const char *query, TDSPARAMINFO * params);
1390TDSRET tds_multiple_execute(TDSSOCKET *tds, TDSMULTIPLE *multiple, TDSDYNAMIC * dyn);
1391
1392
1393/* token.c */
1394TDSRET tds_process_cancel(TDSSOCKET * tds);
1395int tds_get_token_size(int marker);
1396TDSRET tds_process_login_tokens(TDSSOCKET * tds);
1397TDSRET tds_process_simple_query(TDSSOCKET * tds);
1398int tds5_send_optioncmd(TDSSOCKET * tds, TDS_OPTION_CMD tds_command, TDS_OPTION tds_option, TDS_OPTION_ARG * tds_argument,
1399 TDS_INT * tds_argsize);
1400TDSRET tds_process_tokens(TDSSOCKET * tds, /*@out@*/ TDS_INT * result_type, /*@out@*/ int *done_flags, unsigned flag);
1401int determine_adjusted_size(const TDSICONV * char_conv, int size);
1402
1403
1404/* data.c */
1405void tds_set_param_type(TDSCONNECTION * conn, TDSCOLUMN * curcol, TDS_SERVER_TYPE type);
1406void tds_set_column_type(TDSCONNECTION * conn, TDSCOLUMN * curcol, TDS_SERVER_TYPE type);
1407
1408
1409/* tds_convert.c */
1410TDSRET tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC * dr);
1411TDS_SERVER_TYPE tds_get_conversion_type(TDS_SERVER_TYPE srctype, int colsize);
1412extern const char tds_hex_digits[];
1413
1414
1415/* write.c */
1416int tds_init_write_buf(TDSSOCKET * tds);
1417int tds_put_n(TDSSOCKET * tds, const void *buf, size_t n);
1418int tds_put_string(TDSSOCKET * tds, const char *buf, int len);
1419int tds_put_int(TDSSOCKET * tds, TDS_INT i);
1420int tds_put_int8(TDSSOCKET * tds, TDS_INT8 i);
1421int tds_put_smallint(TDSSOCKET * tds, TDS_SMALLINT si);
1423#define tds_put_tinyint(tds, ti) tds_put_byte(tds,ti)
1424int tds_put_byte(TDSSOCKET * tds, unsigned char c);
1425TDSRET tds_flush_packet(TDSSOCKET * tds);
1426int tds_put_buf(TDSSOCKET * tds, const unsigned char *buf, int dsize, int ssize);
1427
1428
1429/* read.c */
1430unsigned char tds_get_byte(TDSSOCKET * tds);
1431void tds_unget_byte(TDSSOCKET * tds);
1432unsigned char tds_peek(TDSSOCKET * tds);
1433TDS_USMALLINT tds_get_usmallint(TDSSOCKET * tds);
1434#define tds_get_smallint(tds) ((TDS_SMALLINT) tds_get_usmallint(tds))
1435TDS_UINT tds_get_uint(TDSSOCKET * tds);
1436#define tds_get_int(tds) ((TDS_INT) tds_get_uint(tds))
1437TDS_UINT8 tds_get_uint8(TDSSOCKET * tds);
1438#define tds_get_int8(tds) ((TDS_INT8) tds_get_uint8(tds))
1439size_t tds_get_string(TDSSOCKET * tds, size_t string_len, char *dest, size_t dest_size);
1440TDSRET tds_get_char_data(TDSSOCKET * tds, char *dest, size_t wire_size, TDSCOLUMN * curcol);
1441bool tds_get_n(TDSSOCKET * tds, /*@out@*/ /*@null@*/ void *dest, size_t n);
1442int tds_get_size_by_type(TDS_SERVER_TYPE servertype);
1443DSTR* tds_dstr_get(TDSSOCKET * tds, DSTR * s, size_t len);
1444
1445
1446/* util.c */
1447int tdserror (const TDSCONTEXT * tds_ctx, TDSSOCKET * tds, int msgno, int errnum);
1448TDS_STATE tds_set_state(TDSSOCKET * tds, TDS_STATE state);
1449void tds_swap_bytes(void *buf, int bytes);
1450unsigned int tds_gettime_ms(void);
1451char *tds_strndup(const void *s, TDS_INTPTR len);
1452
1453
1454/* log.c */
1455void tdsdump_off(void);
1456void tdsdump_on(void);
1457int tdsdump_isopen(void);
1458#include <freetds/popvis.h>
1459int tdsdump_open(const char *filename);
1460#include <freetds/pushvis.h>
1461void tdsdump_close(void);
1462void tdsdump_dump_buf(const char* file, unsigned int level_line, const char *msg, const void *buf, size_t length);
1463void tdsdump_col(const TDSCOLUMN *col);
1464#undef tdsdump_log
1465void tdsdump_log(const char* file, unsigned int level_line, const char *fmt, ...)
1466#if defined(__GNUC__) && __GNUC__ >= 2
1467#if defined(__MINGW32__)
1468 __attribute__ ((__format__ (ms_printf, 3, 4)))
1469#else
1470 __attribute__ ((__format__ (__printf__, 3, 4)))
1471#endif
1472#endif
1473;
1474#define TDSDUMP_LOG_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_log
1475#define tdsdump_log TDSDUMP_LOG_FAST
1476#define TDSDUMP_BUF_FAST if (TDS_UNLIKELY(tds_write_dump)) tdsdump_dump_buf
1477#define tdsdump_dump_buf TDSDUMP_BUF_FAST
1478
1479extern int tds_write_dump;
1480extern int tds_debug_flags;
1481extern int tds_g_append_mode;
1482
1483
1484/* net.c */
1485TDSERRNO tds_open_socket(TDSSOCKET * tds, struct addrinfo *ipaddr, unsigned int port, int timeout, int *p_oserr);
1486void tds_close_socket(TDSSOCKET * tds);
1487int tds7_get_instance_ports(FILE *output, struct addrinfo *addr);
1488int tds7_get_instance_port(struct addrinfo *addr, const char *instance);
1489char *tds_prwsaerror(int erc);
1490void tds_prwsaerror_free(char *s);
1491int tds_connection_read(TDSSOCKET * tds, unsigned char *buf, int buflen);
1492int tds_connection_write(TDSSOCKET *tds, const unsigned char *buf, int buflen, int final);
1493#define TDSSELREAD POLLIN
1494#define TDSSELWRITE POLLOUT
1495int tds_select(TDSSOCKET * tds, unsigned tds_sel, int timeout_seconds);
1496void tds_connection_close(TDSCONNECTION *conn);
1497int tds_goodread(TDSSOCKET * tds, unsigned char *buf, int buflen);
1498int tds_goodwrite(TDSSOCKET * tds, const unsigned char *buffer, size_t buflen);
1499void tds_socket_flush(TDS_SYS_SOCKET sock);
1500int tds_socket_set_nonblocking(TDS_SYS_SOCKET sock);
1501int tds_wakeup_init(TDSPOLLWAKEUP *wakeup);
1502void tds_wakeup_close(TDSPOLLWAKEUP *wakeup);
1503void tds_wakeup_send(TDSPOLLWAKEUP *wakeup, char cancel);
1504static inline TDS_SYS_SOCKET tds_wakeup_get_fd(const TDSPOLLWAKEUP *wakeup)
1505{
1506 return wakeup->s_signaled;
1507}
1508
1509
1510/* packet.c */
1511int tds_read_packet(TDSSOCKET * tds);
1512TDSRET tds_write_packet(TDSSOCKET * tds, unsigned char final);
1513#if ENABLE_ODBC_MARS
1514int tds_append_cancel(TDSSOCKET *tds);
1515TDSRET tds_append_fin(TDSSOCKET *tds);
1516#else
1517int tds_put_cancel(TDSSOCKET * tds);
1518#endif
1519
1520
1521/* vstrbuild.c */
1522TDSRET tds_vstrbuild(char *buffer, int buflen, int *resultlen, const char *text, int textlen, const char *formats, int formatlen,
1523 va_list ap);
1524
1525
1526/* numeric.c */
1527char *tds_money_to_string(const TDS_MONEY * money, char *s, bool use_2_digits);
1528TDS_INT tds_numeric_to_string(const TDS_NUMERIC * numeric, char *s);
1529TDS_INT tds_numeric_change_prec_scale(TDS_NUMERIC * numeric, unsigned char new_prec, unsigned char new_scale);
1530
1531
1532/* getmac.c */
1533void tds_getmac(TDS_SYS_SOCKET s, unsigned char mac[6]);
1534
1535
1536/* challenge.c */
1537#ifndef HAVE_SSPI
1538TDSAUTHENTICATION * tds_ntlm_get_auth(TDSSOCKET * tds);
1539TDSAUTHENTICATION * tds_gss_get_auth(TDSSOCKET * tds);
1540#else
1541TDSAUTHENTICATION * tds_sspi_get_auth(TDSSOCKET * tds);
1542#endif
1543
1544
1545/* random.c */
1546void tds_random_buffer(unsigned char *out, int len);
1547
1548
1549/* sec_negotiate.c */
1550TDSAUTHENTICATION * tds5_negotiate_get_auth(TDSSOCKET * tds);
1551void tds5_negotiate_set_msg_type(TDSSOCKET * tds, TDSAUTHENTICATION * auth, unsigned msg_type);
1552
1553
1554/* bulk.c */
1555
1558{
1559 TDS_BCP_IN = 1,
1560 TDS_BCP_OUT = 2,
1561 TDS_BCP_QUERYOUT = 3
1562};
1563
1565{
1566 const char *hint;
1567 void *parent;
1568 DSTR tablename;
1569 TDS_CHAR *insert_stmt;
1570 TDS_INT direction;
1571 TDS_INT identity_insert_on;
1572 TDS_INT xfer_init;
1573 TDS_INT bind_count;
1574 TDSRESULTINFO *bindinfo;
1575};
1576
1577TDSRET tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1578typedef TDSRET (*tds_bcp_get_col_data) (TDSBCPINFO *bulk, TDSCOLUMN *bcpcol, int offset);
1579typedef void (*tds_bcp_null_error) (TDSBCPINFO *bulk, int index, int offset);
1580TDSRET tds_bcp_send_record(TDSSOCKET *tds, TDSBCPINFO *bcpinfo, tds_bcp_get_col_data get_col_data, tds_bcp_null_error null_error, int offset);
1581TDSRET tds_bcp_done(TDSSOCKET *tds, int *rows_copied);
1582TDSRET tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1583TDSRET tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo);
1584
1585TDSRET tds_bcp_fread(TDSSOCKET * tds, TDSICONV * conv, FILE * stream,
1586 const char *terminator, size_t term_len, char **outbuf, size_t * outbytes);
1587
1588TDSRET tds_writetext_start(TDSSOCKET *tds, const char *objname, const char *textptr, const char *timestamp, int with_log, TDS_UINT size);
1589TDSRET tds_writetext_continue(TDSSOCKET *tds, const TDS_UCHAR *text, TDS_UINT size);
1590TDSRET tds_writetext_end(TDSSOCKET *tds);
1591
1592
1593static inline
1594bool tds_capability_enabled(const TDS_CAPABILITY_TYPE *cap, unsigned cap_num)
1595{
1596 return (cap->values[sizeof(cap->values)-1-(cap_num>>3)] >> (cap_num&7)) & 1;
1597}
1598#define tds_capability_has_req(conn, cap) \
1599 tds_capability_enabled(&conn->capabilities.types[0], cap)
1600
1601#define IS_TDS42(x) (x->tds_version==0x402)
1602#define IS_TDS46(x) (x->tds_version==0x406)
1603#define IS_TDS50(x) (x->tds_version==0x500)
1604#define IS_TDS70(x) (x->tds_version==0x700)
1605#define IS_TDS71(x) (x->tds_version==0x701)
1606#define IS_TDS72(x) (x->tds_version==0x702)
1607#define IS_TDS73(x) (x->tds_version==0x703)
1608
1609#define IS_TDS50_PLUS(x) ((x)->tds_version>=0x500)
1610#define IS_TDS7_PLUS(x) ((x)->tds_version>=0x700)
1611#define IS_TDS71_PLUS(x) ((x)->tds_version>=0x701)
1612#define IS_TDS72_PLUS(x) ((x)->tds_version>=0x702)
1613#define IS_TDS73_PLUS(x) ((x)->tds_version>=0x703)
1614#define IS_TDS74_PLUS(x) ((x)->tds_version>=0x704)
1615
1616#define TDS_MAJOR(x) ((x)->tds_version >> 8)
1617#define TDS_MINOR(x) ((x)->tds_version & 0xff)
1618
1619#define IS_TDSDEAD(x) (((x) == NULL) || (x)->state == TDS_DEAD)
1620
1622#define TDS_IS_SYBASE(x) (!((x)->conn->product_version & 0x80000000u))
1624#define TDS_IS_MSSQL(x) (((x)->conn->product_version & 0x80000000u)!=0)
1625
1629#define TDS_MS_VER(maj,min,x) (0x80000000u|((maj)<<24)|((min)<<16)|(x))
1630
1631/* TODO test if not similar to ms one*/
1633#define TDS_SYB_VER(maj,min,x) (((maj)<<24)|((min)<<16)|(x)<<8)
1634
1635#ifdef __cplusplus
1636#if 0
1637{
1638#endif
1639}
1640#endif
1641
1642#include <freetds/popvis.h>
1643
1644#define TDS_PUT_INT(tds,v) tds_put_int((tds), ((TDS_INT)(v)))
1645#define TDS_PUT_SMALLINT(tds,v) tds_put_smallint((tds), ((TDS_SMALLINT)(v)))
1646#define TDS_PUT_BYTE(tds,v) tds_put_byte((tds), ((unsigned char)(v)))
1647
1648#endif /* _tds_h_ */
int tds_iconv_alloc(TDSCONNECTION *conn)
Allocate iconv stuff.
Definition iconv.c:266
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
void tdsdump_on(void)
Turn logging back on.
Definition log.c:88
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:394
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:112
struct tds_variant TDSVARIANT
Store variant informations.
void tdsdump_close(void)
Close the TDS dump log file.
Definition log.c:193
void tds_set_column_type(TDSCONNECTION *conn, TDSCOLUMN *curcol, TDS_SERVER_TYPE type)
Set type of column initializing all dependency.
Definition data.c:227
bool tds_set_server(TDSLOGIN *tds_login, const char *server) TDS_WUR
Set the servername in a TDSLOGIN structure.
Definition login.c:125
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.
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
TDSRET tds_bcp_start_copy_in(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start bulk copy to server.
Definition bulk.c:887
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 TDS 7....
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:1118
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:1048
TDSRET tds_bcp_start(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Start sending BCP data to server.
Definition bulk.c:840
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:249
tds_states
values for tds->state
Definition tds.h:791
@ TDS_PENDING
cilent is waiting for data
Definition tds.h:795
@ TDS_SENDING
client would send data
Definition tds.h:794
@ TDS_READING
client is reading data
Definition tds.h:796
@ TDS_WRITING
client is writing data
Definition tds.h:793
@ TDS_IDLE
no data expected
Definition tds.h:792
@ TDS_DEAD
no connection
Definition tds.h:797
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:408
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:1156
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:307
enum tds_states TDS_STATE
values for tds->state
TDSRET tds_writetext_end(TDSSOCKET *tds)
Finish sending writetext data.
Definition bulk.c:1173
void tdsdump_off(void)
Temporarily turn off logging.
Definition log.c:76
TDSRET tds_bcp_init(TDSSOCKET *tds, TDSBCPINFO *bcpinfo)
Initialize BCP information.
Definition bulk.c:82
tds_bcp_directions
bcp direction
Definition tds.h:1558
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:337
TDSRET tds_bcp_done(TDSSOCKET *tds, int *rows_copied)
Tell we finished sending BCP data to server.
Definition bulk.c:810
struct tds_encoding TDS_ENCODING
Information relevant to libiconv.
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:691
TDS_USMALLINT * tds_config_verstr(const char *tdsver, TDSLOGIN *login)
Set TDS version from given string.
Definition config.c:905
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:1324
struct addrinfo * tds_lookup_host(const char *servername)
Get the IP address for a hostname.
Definition config.c:974
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:504
bool tds_read_conf_file(TDSLOGIN *login, const char *server)
Read configuration info for given server return 0 on error.
Definition config.c:347
TDSRET tds_set_interfaces_file_loc(const char *interfloc)
Set the full name of interface file.
Definition config.c:948
char * tds_get_home_file(const char *file)
Return filename from HOME directory.
Definition config.c:326
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:286
TDSRET tds_datecrack(TDS_INT datetype, const void *di, TDSDATEREC *dr)
Convert from db date format to a structured date format.
Definition convert.c:3124
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:1211
TDSRET tds_alloc_row(TDSRESULTINFO *res_info)
Allocate space for row store return NULL on out of memory.
Definition mem.c:524
void tds_detach_results(TDSRESULTINFO *info)
Detach result info from it current socket.
Definition mem.c:488
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:364
TDSLOGIN * tds_init_login(TDSLOGIN *login, TDSLOCALE *locale)
Initialize login structure with locale information and other stuff for connection.
Definition mem.c:800
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:1819
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:1844
const char * tds_skip_quoted(const char *s)
Skip quoting string (like 'sfsf', "dflkdj" or [dfkjd])
Definition query.c:537
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:1474
void tds_start_query(TDSSOCKET *tds, unsigned char packet_type)
Start query packet of a given type.
Definition query.c:347
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:2125
TDSRET tds_submit_execute(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Sends a previously prepared dynamic statement to the server.
Definition query.c:1739
size_t tds_fix_column_size(TDSSOCKET *tds, TDSCOLUMN *curcol)
Get column size for wire.
Definition query.c:1566
TDSRET tds_get_column_declaration(TDSSOCKET *tds, TDSCOLUMN *curcol, char *out)
Return declaration for column (like "varchar(20)").
Definition query.c:739
TDSRET tds_submit_commit(TDSSOCKET *tds, int cont)
Send a commit request.
Definition query.c:3798
TDSRET tds_deferred_cursor_dealloc(TDSCONNECTION *conn, TDSCURSOR *cursor)
Deallocate cursor on idle.
Definition query.c:3131
TDSRET tds_submit_query(TDSSOCKET *tds, const char *query)
Sends a language string to the database server for processing.
Definition query.c:209
TDSRET tds_submit_rpc(TDSSOCKET *tds, const char *rpc_name, TDSPARAMINFO *params, TDSHEADERS *head)
Calls a RPC from server.
Definition query.c:2023
size_t tds_quote_string(TDSSOCKET *tds, char *buffer, const char *str, int len)
Quote a string.
Definition query.c:2312
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:1189
TDSRET tds_submit_begin_tran(TDSSOCKET *tds)
Send a rollback request.
Definition query.c:3739
size_t tds_quote_id(TDSSOCKET *tds, char *buffer, const char *id, int idlen)
Quote an id.
Definition query.c:2268
const char * tds_next_placeholder(const char *start)
Get position of next placeholder.
Definition query.c:557
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:365
TDSRET tds_submit_rollback(TDSSOCKET *tds, int cont)
Send a rollback request.
Definition query.c:3767
TDSRET tds_deferred_unprepare(TDSCONNECTION *conn, TDSDYNAMIC *dyn)
Unprepare dynamic on idle.
Definition query.c:1866
int tds_count_placeholders(const char *query)
Count the number of placeholders ('?
Definition query.c:593
TDSRET tds_cursor_dealloc(TDSSOCKET *tds, TDSCURSOR *cursor)
Send a deallocation request to server.
Definition query.c:3080
const char * tds_skip_comment(const char *s)
Skip a comment in a query.
Definition query.c:512
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:125
TDSRET tds_submit_queryf(TDSSOCKET *tds, const char *queryf,...)
Format and submit a query.
Definition query.c:489
TDSRET tds_submit_execdirect(TDSSOCKET *tds, const char *query, TDSPARAMINFO *params, TDSHEADERS *head)
Submit a prepared query with parameters.
Definition query.c:1328
void tds_set_cur_dyn(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Set current dynamic.
Definition query.c:191
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:3463
TDSRET tds_submit_unprepare(TDSSOCKET *tds, TDSDYNAMIC *dyn)
Send a unprepare request for a prepared query.
Definition query.c:1889
DSTR * tds_dstr_get(TDSSOCKET *tds, DSTR *s, size_t len)
Reads a string from wire and put in a DSTR.
Definition read.c:311
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:93
unsigned char tds_peek(TDSSOCKET *tds)
Reads a byte from the TDS stream without removing it.
Definition read.c:100
int tds_goodwrite(TDSSOCKET *tds, const unsigned char *buffer, size_t buflen)
Definition net.c:987
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:534
TDSRET tds_flush_packet(TDSSOCKET *tds)
Flush packet to server.
Definition write.c:285
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_UINT8 tds_get_uint8(TDSSOCKET *tds)
Get an uint64 from the server.
Definition read.c:148
TDSRET tds_get_char_data(TDSSOCKET *tds, char *dest, size_t wire_size, TDSCOLUMN *curcol)
Fetch character data the wire.
Definition read.c:213
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:184
int tds7_get_instance_ports(FILE *output, struct addrinfo *addr)
Get port of all instances.
Definition net.c:1093
TDS_UINT tds_get_uint(TDSSOCKET *tds)
Get an int32 from the server.
Definition read.c:131
int tds7_get_instance_port(struct addrinfo *addr, const char *instance)
Get port of given instance.
Definition net.c:1229
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:612
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:248
const char * tds_prtype(int token)
Returns string representation of the given type.
Definition token.c:3053
TDSDYNAMIC * tds_lookup_dynamic(TDSCONNECTION *conn, const char *id)
Finds a dynamic given string id.
Definition token.c:2584
int determine_adjusted_size(const TDSICONV *char_conv, int size)
Allow for maximum possible size of converted data, while being careful about integer division truncat...
Definition token.c:3280
TDSRET tds_process_login_tokens(TDSSOCKET *tds)
tds_process_login_tokens() is called after sending the login packet to the server.
Definition token.c:409
int tds_get_token_size(int marker)
tds_get_token_size() returns the size of a fixed length token used by tds_process_cancel() to determi...
Definition token.c:2751
TDSRET tds_process_tokens(TDSSOCKET *tds, TDS_INT *result_type, int *done_flags, unsigned flag)
process all streams.
Definition token.c:529
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:876
TDSRET tds_process_cancel(TDSSOCKET *tds)
Definition token.c:2551
struct tds_dstr * DSTR
Structure to hold a string.
Definition iconv.h:92
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
Definition tds.h:329
Definition tds.h:490
Definition tds.h:499
Definition tds.h:506
Definition tds.h:512
DSTR crlfile
certificate revocation file
Definition tds.h:526
DSTR server_realm_name
server realm name (in freetds.conf)
Definition tds.h:522
DSTR user_name
account for login
Definition tds.h:529
DSTR password
password of account login
Definition tds.h:530
DSTR db_filename
database filename to attach (MSSQL)
Definition tds.h:524
DSTR server_name
server name (in freetds.conf)
Definition tds.h:513
struct addrinfo * ip_addrs
ip(s) of server
Definition tds.h:541
DSTR server_charset
charset of server e.g.
Definition tds.h:518
TDS_USMALLINT tds_version
TDS version.
Definition tds.h:515
DSTR new_password
new password to set (TDS 7.2+)
Definition tds.h:531
unsigned int bulk_copy
if bulk copy should be enabled
Definition tds.h:551
DSTR cafile
certificate authorities file
Definition tds.h:525
DSTR server_spn
server SPN (in freetds.conf)
Definition tds.h:523
int port
port of database service
Definition tds.h:514
Definition tds.h:569
Definition tds.h:577
Information about blobs (e.g.
Definition tds.h:588
Store variant informations.
Definition tds.h:599
Information relevant to libiconv.
Definition tds.h:613
const char * name
name of the encoding (ie UTF-8)
Definition tds.h:615
unsigned char canonic
internal numeric index into array of all encodings
Definition tds.h:619
Definition tds.h:623
Definition tds.h:639
tds_func_put_data * put_data
Send column data to server.
Definition tds.h:664
tds_func_put_info_len * put_info_len
Returns metadata column information size.
Definition tds.h:648
tds_func_put_info * put_info
Send metadata column information to server.
Definition tds.h:654
Metadata about columns in regular and compute rows.
Definition tds.h:691
TDS_INT bcp_prefix_len
The length, in bytes, of any length prefix this column may have.
Definition tds.h:763
TDS_TINYINT column_varint_size
size of length when reading from wire (0, 1, 2 or 4)
Definition tds.h:703
TDS_INT column_size
maximun size of data.
Definition tds.h:696
TDS_TINYINT column_prec
precision for decimal/numeric
Definition tds.h:705
TDS_SERVER_TYPE column_type
This type can be different from wire type because conversion (e.g.
Definition tds.h:698
TDSICONV * char_conv
refers to previously allocated iconv information
Definition tds.h:714
TDS_TINYINT column_scale
scale for decimal/numeric
Definition tds.h:706
TDS_INT column_cur_size
size written in variable (ie: char, text, binary).
Definition tds.h:738
Hold information for any results.
Definition tds.h:771
Definition tds.h:878
Definition tds.h:894
Definition tds.h:908
Holds informations about a cursor.
Definition tds.h:939
TDS_TINYINT options
read only|updatable TODO use it
Definition tds.h:944
bool defer_close
true if cursor was marker to be closed when connection is idle
Definition tds.h:948
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition tds.h:941
TDS_INT cursor_id
cursor id returned by the server after cursor declare
Definition tds.h:943
TDS_INT cursor_rows
< number of updatable columns
Definition tds.h:953
struct tds_cursor * next
next in linked list, keep first
Definition tds.h:940
TDS_INT type
row fetched from this cursor
Definition tds.h:958
TDS_CURSOR_STATUS status
cursor parameter
Definition tds.h:955
char * query
SQL query.
Definition tds.h:949
char * cursor_name
name of the cursor
Definition tds.h:942
Current environment as reported by the server.
Definition tds.h:965
char * charset
character set encoding
Definition tds.h:970
int block_size
packet size (512-65535)
Definition tds.h:967
char * database
database name
Definition tds.h:972
Holds information for a dynamic (also called prepared) query.
Definition tds.h:979
char * query
saved query, we need to know original query if prepare is impossible
Definition tds.h:1011
TDS_INT ref_count
reference counter so client can retain safely a pointer
Definition tds.h:981
bool defer_close
true if dynamic was marker to be closed when connection is idle
Definition tds.h:999
TDSPARAMINFO * res_info
query results
Definition tds.h:1001
TDS_TINYINT emulated
this dynamic query cannot be prepared so libTDS have to construct a simple query.
Definition tds.h:995
TDSPARAMINFO * params
query parameters.
Definition tds.h:1009
struct tds_dynamic * next
next in linked list, keep first
Definition tds.h:980
TDS_INT num_id
numeric id for mssql7+
Definition tds.h:983
Definition tds.h:1021
Definition tds.h:1031
Definition tds.h:1049
Definition tds.h:1057
Definition tds.h:1065
Definition tds.h:1071
TDSENV env
environment is shared between all sessions
Definition tds.h:1081
TDSCURSOR * cursors
linked list of cursors allocated for this connection contains only cursors allocated on the server
Definition tds.h:1087
TDS_SYS_SOCKET s
tcp socket, INVALID_SOCKET if not connected
Definition tds.h:1076
TDS_UINT product_version
version of product (Sybase/MS and full version)
Definition tds.h:1073
TDSDYNAMIC * dyns
list of dynamic allocated for this connection contains only dynamic allocated on the server
Definition tds.h:1092
unsigned int pending_close
true is connection has pending closing (cursors or dynamic)
Definition tds.h:1104
Information for a server connection.
Definition tds.h:1143
TDSLOGIN * login
config for login stuff.
Definition tds.h:1215
unsigned in_len
input buffer length
Definition tds.h:1171
TDSPACKET * send_packet
packet we are preparing to send
Definition tds.h:1188
unsigned char * in_buf
Input buffer.
Definition tds.h:1155
TDS_INT ret_status
return status from store procedure
Definition tds.h:1204
unsigned out_pos
current position in out_buf
Definition tds.h:1170
TDSRESULTINFO * current_results
Current query information.
Definition tds.h:1195
unsigned char in_flag
input buffer type
Definition tds.h:1172
TDS_INT8 rows_affected
rows updated/deleted/inserted/selected, TDS_NO_COUNT if not valid
Definition tds.h:1210
unsigned char out_flag
output buffer type
Definition tds.h:1173
unsigned in_pos
current position in in_buf
Definition tds.h:1169
TDSCURSOR * cur_cursor
cursor in use
Definition tds.h:1200
bool in_row
true if we are getting rows
Definition tds.h:1203
bool bulk_query
true is query sent was a bulk query so we need to switch state to QUERYING
Definition tds.h:1201
bool has_status
true is ret_status is valid
Definition tds.h:1202
unsigned char * out_buf
Output buffer.
Definition tds.h:1162
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:1207
unsigned int out_buf_max
Maximum size of packet pointed by out_buf.
Definition tds.h:1168
TDSDYNAMIC * cur_dyn
dynamic structure in use
Definition tds.h:1213
Definition tds.h:1565
Definition thread.h:278