21#ifndef _tdsguard_gQHaPEvp2dAAa45TAutROb_
22#define _tdsguard_gQHaPEvp2dAAa45TAutROb_
24#define TDS_DONT_DEFINE_DEFAULT_FUNCTIONS
26#include <freetds/thread.h>
27#include <freetds/data.h>
29#if defined(UNIXODBC) || defined(_WIN32) || defined(TDS_NO_DM)
32#if defined(UNIXODBC) || defined(_WIN32)
38#ifdef HAVE_IODBCINST_H
49#define SQLULEN SQLUINTEGER
52#define SQLLEN SQLINTEGER
56#ifndef HAVE_SQLSETPOSIROW
57#define SQLSETPOSIROW SQLUSMALLINT
60#ifndef HAVE_SQLROWOFFSET
61#define SQLROWOFFSET SQLLEN
64#ifndef HAVE_SQLROWSETSIZE
65#define SQLROWSETSIZE SQLULEN
76#include <freetds/pushvis.h>
78#define ODBC_API SQL_API __attribute__((visibility("default")))
79#elif defined(__GNUC__) && __GNUC__ >= 4 && !defined(__MINGW32__)
80#define ODBC_API SQL_API __attribute__((externally_visible))
82#define ODBC_API SQL_API
85#if (defined(_WIN32) || defined(__CYGWIN__)) && defined(__GNUC__)
86# define ODBC_PUBLIC __attribute__((dllexport))
91#define ODBC_MAX(a,b) ( (a) > (b) ? (a) : (b) )
92#define ODBC_MIN(a,b) ( (a) < (b) ? (a) : (b) )
93#define ODBC_CLAMP(x,a,b) ( (x) < (a) ? (a) : (x) > (b) ? (b) : (x) )
118#if ENABLE_EXTRA_CHECKS
119void odbc_check_struct_extra(
void *p);
121static inline void odbc_check_struct_extra(
void *p TDS_UNUSED) {}
124#define ODBC_RETURN(handle, rc) \
125 do { odbc_check_struct_extra(handle); \
126 return handle->errs.lastrc = (rc); } while(0)
127#define ODBC_RETURN_(handle) \
128 do { odbc_check_struct_extra(handle); \
129 return handle->errs.lastrc; } while(0)
131#define ODBC_EXIT(handle, rc) \
132 do { SQLRETURN _odbc_rc = handle->errs.lastrc = (rc); \
133 odbc_check_struct_extra(handle); \
134 tds_mutex_unlock(&handle->mtx); \
135 return _odbc_rc; } while(0)
136#define ODBC_EXIT_(handle) \
137 do { SQLRETURN _odbc_rc = handle->errs.lastrc; \
138 odbc_check_struct_extra(handle); \
139 tds_mutex_unlock(&handle->mtx); \
140 return _odbc_rc; } while(0)
147void odbc_errs_add(
struct _sql_errors *errs,
const char *sqlstate,
const char *msg);
150void odbc_errs_add_rdbms(
struct _sql_errors *errs, TDS_UINT native,
const char *sqlstate,
const char *msg,
int linenum,
151 int msgstate,
const char *server,
int row);
156 SQLSMALLINT sql_desc_alloc_type;
158 SQLSMALLINT sql_desc_count;
159 SQLINTEGER sql_desc_bind_type;
160 SQLULEN sql_desc_array_size;
161 SQLUSMALLINT *sql_desc_array_status_ptr;
162 SQLULEN *sql_desc_rows_processed_ptr;
163 SQLLEN *sql_desc_bind_offset_ptr;
169 DSTR sql_desc_base_column_name;
170 DSTR sql_desc_base_table_name;
171 SQLUINTEGER sql_desc_auto_unique_value;
172 SQLINTEGER sql_desc_case_sensitive;
173 DSTR sql_desc_catalog_name;
174 SQLPOINTER sql_desc_data_ptr;
175 SQLSMALLINT sql_desc_concise_type;
176 SQLSMALLINT sql_desc_datetime_interval_code;
177 SQLINTEGER sql_desc_datetime_interval_precision;
178 SQLLEN sql_desc_display_size;
179 SQLLEN *sql_desc_indicator_ptr;
181 SQLULEN sql_desc_length;
183 const char *sql_desc_literal_prefix;
185 const char *sql_desc_literal_suffix;
186 DSTR sql_desc_local_type_name;
188 SQLSMALLINT sql_desc_fixed_prec_scale;
189 SQLSMALLINT sql_desc_nullable;
190 SQLINTEGER sql_desc_num_prec_radix;
191 SQLLEN sql_desc_octet_length;
192 SQLLEN *sql_desc_octet_length_ptr;
193 SQLSMALLINT sql_desc_parameter_type;
194 SQLSMALLINT sql_desc_precision;
195 SQLSMALLINT sql_desc_rowver;
196 SQLSMALLINT sql_desc_scale;
197 DSTR sql_desc_schema_name;
198 DSTR sql_desc_table_name;
199 SQLSMALLINT sql_desc_searchable;
200 SQLSMALLINT sql_desc_type;
202 const char *sql_desc_type_name;
203 SQLSMALLINT sql_desc_unnamed;
204 SQLSMALLINT sql_desc_unsigned;
205 SQLSMALLINT sql_desc_updatable;
235 SQLUINTEGER connection_pooling;
236 SQLUINTEGER cp_match;
237 SQLINTEGER odbc_version;
238 SQLINTEGER output_nts;
259 SQLUINTEGER access_mode;
260 SQLUINTEGER async_enable;
261 SQLUINTEGER auto_ipd;
262 SQLUINTEGER autocommit;
263 SQLUINTEGER connection_dead;
264 SQLUINTEGER connection_timeout;
265 DSTR current_catalog;
266 SQLUINTEGER login_timeout;
267 SQLUINTEGER metadata_id;
268 SQLUINTEGER odbc_cursors;
269 SQLUINTEGER packet_size;
272 SQLUINTEGER translate_option;
273 SQLUINTEGER txn_isolation;
274 SQLUINTEGER mars_enabled;
275 SQLUINTEGER cursor_type;
276 SQLUINTEGER bulk_enabled;
283#define TDS_MAX_APP_DESC 100
295#ifdef ENABLE_ODBC_WIDE
296 int original_charset_num;
313 unsigned int use_oldpwd:1;
314 TDS_INT default_query_timeout;
324 SQLUINTEGER async_enable;
325 SQLUINTEGER concurrency;
326 SQLUINTEGER cursor_scrollable;
327 SQLUINTEGER cursor_sensitivity;
328 SQLUINTEGER cursor_type;
329 SQLUINTEGER enable_auto_ipd;
330 SQLPOINTER fetch_bookmark_ptr;
334 SQLUINTEGER metadata_id;
348 SQLUINTEGER query_timeout;
349 SQLUINTEGER retrieve_data;
363 SQLUINTEGER simulate_cursor;
364 SQLUINTEGER use_bookmarks;
370 SQLUINTEGER qn_timeout;
371 SQLUINTEGER param_focus;
381} TDS_ODBC_ROW_STATUS;
385 ODBC_SPECIAL_NONE = 0,
386 ODBC_SPECIAL_GETTYPEINFO = 1,
387 ODBC_SPECIAL_COLUMNS = 2,
388 ODBC_SPECIAL_PROCEDURECOLUMNS = 3,
389 ODBC_SPECIAL_SPECIALCOLUMNS = 4
390} TDS_ODBC_SPECIAL_ROWS;
409 unsigned is_prepared_query:1;
410 unsigned prepared_query_is_func:1;
411 unsigned prepared_query_is_rpc:1;
417 unsigned param_data_called:1;
418 unsigned params_queried:1;
419 unsigned params_set:1;
429 unsigned int curr_param_row, num_param_rows;
442 SQLULEN sql_rowset_size;
445 TDS_ODBC_SPECIAL_ROWS special_row;
458 void (*set_type_info)(
TDSCOLUMN *col,
struct _drecord *drec, SQLINTEGER odbc_ver);
461#define IS_HENV(x) (((TDS_CHK *)x)->htype == SQL_HANDLE_ENV)
462#define IS_HDBC(x) (((TDS_CHK *)x)->htype == SQL_HANDLE_DBC)
463#define IS_HSTMT(x) (((TDS_CHK *)x)->htype == SQL_HANDLE_STMT)
464#define IS_HDESC(x) (((TDS_CHK *)x)->htype == SQL_HANDLE_DESC)
468#if SQL_INTERVAL_YEAR == (100 + SQL_CODE_SECOND)
470#undef SQL_INTERVAL_YEAR
471#undef SQL_INTERVAL_MONTH
472#undef SQL_INTERVAL_DAY
473#undef SQL_INTERVAL_HOUR
474#undef SQL_INTERVAL_MINUTE
475#undef SQL_INTERVAL_SECOND
476#undef SQL_INTERVAL_YEAR_TO_MONTH
477#undef SQL_INTERVAL_DAY_TO_HOUR
478#undef SQL_INTERVAL_DAY_TO_MINUTE
479#undef SQL_INTERVAL_DAY_TO_SECOND
480#undef SQL_INTERVAL_HOUR_TO_MINUTE
481#undef SQL_INTERVAL_HOUR_TO_SECOND
482#undef SQL_INTERVAL_MINUTE_TO_SECOND
484#define SQL_INTERVAL_YEAR (100 + SQL_CODE_YEAR)
485#define SQL_INTERVAL_MONTH (100 + SQL_CODE_MONTH)
486#define SQL_INTERVAL_DAY (100 + SQL_CODE_DAY)
487#define SQL_INTERVAL_HOUR (100 + SQL_CODE_HOUR)
488#define SQL_INTERVAL_MINUTE (100 + SQL_CODE_MINUTE)
489#define SQL_INTERVAL_SECOND (100 + SQL_CODE_SECOND)
490#define SQL_INTERVAL_YEAR_TO_MONTH (100 + SQL_CODE_YEAR_TO_MONTH)
491#define SQL_INTERVAL_DAY_TO_HOUR (100 + SQL_CODE_DAY_TO_HOUR)
492#define SQL_INTERVAL_DAY_TO_MINUTE (100 + SQL_CODE_DAY_TO_MINUTE)
493#define SQL_INTERVAL_DAY_TO_SECOND (100 + SQL_CODE_DAY_TO_SECOND)
494#define SQL_INTERVAL_HOUR_TO_MINUTE (100 + SQL_CODE_HOUR_TO_MINUTE)
495#define SQL_INTERVAL_HOUR_TO_SECOND (100 + SQL_CODE_HOUR_TO_SECOND)
496#define SQL_INTERVAL_MINUTE_TO_SECOND (100 + SQL_CODE_MINUTE_TO_SECOND)
502bool get_login_info(HWND hwndParent,
TDSLOGIN * login);
505#define ODBC_PARAM_LIST \
506 ODBC_PARAM(Servername) \
511 ODBC_PARAM(Address) \
513 ODBC_PARAM(TDS_Version) \
514 ODBC_PARAM(Language) \
515 ODBC_PARAM(Database) \
516 ODBC_PARAM(TextSize) \
517 ODBC_PARAM(PacketSize) \
518 ODBC_PARAM(ClientCharset) \
519 ODBC_PARAM(DumpFile) \
520 ODBC_PARAM(DumpFileAppend) \
521 ODBC_PARAM(DebugFlags) \
522 ODBC_PARAM(Encryption) \
523 ODBC_PARAM(Trusted_Connection) \
526 ODBC_PARAM(UseNTLMv2) \
527 ODBC_PARAM(MARS_Connection) \
529 ODBC_PARAM(ServerSPN) \
530 ODBC_PARAM(AttachDbFilename) \
531 ODBC_PARAM(ApplicationIntent) \
532 ODBC_PARAM(Timeout) \
533 ODBC_PARAM(Encrypt) \
534 ODBC_PARAM(HostNameInCertificate)
536#define ODBC_PARAM(p) ODBC_PARAM_##p,
543#define ODBC_PARAM(p) extern const char odbc_param_##p[];
563bool odbc_parse_connect_string(
TDS_ERRS *errs,
const char *connect_string,
const char *connect_string_end,
574 TDS_CHAR * dest, SQLULEN destlen,
const struct _drecord *drec_ixd);
575SQLLEN odbc_tds2sql_int4(
TDS_STMT * stmt, TDS_INT *src,
int desttype, TDS_CHAR * dest, SQLULEN destlen);
588TDS_DESC *desc_alloc(SQLHANDLE parent,
int desc_type, SQLSMALLINT alloc_type);
589SQLRETURN desc_free(
TDS_DESC * desc);
590SQLRETURN desc_alloc_records(
TDS_DESC * desc,
unsigned count);
592SQLRETURN desc_free_records(
TDS_DESC * desc);
595void tvp_free(
SQLTVP *tvp);
601SQLRETURN odbc_SQLRowCount(SQLHSTMT hstmt, SQLLEN FAR * pcrow);
606#if ENABLE_EXTRA_CHECKS
608#define CHECK_ENV_EXTRA(env) odbc_check_env_extra(env)
609#define CHECK_DBC_EXTRA(dbc) odbc_check_dbc_extra(dbc)
610#define CHECK_STMT_EXTRA(stmt) odbc_check_stmt_extra(stmt)
611#define CHECK_DESC_EXTRA(desc) odbc_check_desc_extra(desc)
613void odbc_check_env_extra(
TDS_ENV * env);
614void odbc_check_dbc_extra(
TDS_DBC * dbc);
615void odbc_check_stmt_extra(
TDS_STMT * stmt);
616void odbc_check_desc_extra(
TDS_DESC * desc);
619#define CHECK_ENV_EXTRA(env)
620#define CHECK_DBC_EXTRA(dbc)
621#define CHECK_STMT_EXTRA(stmt)
622#define CHECK_DESC_EXTRA(desc)
632#ifdef ENABLE_ODBC_WIDE
639# define _WIDE ,int wide
644# define ODBC_CHAR SQLCHAR
646SQLRETURN odbc_set_stmt_query(
struct _hstmt *stmt,
const ODBC_CHAR *sql,
int sql_len _WIDE);
647void odbc_set_return_status(
struct _hstmt *stmt,
unsigned int n_row);
648void odbc_set_return_params(
struct _hstmt *stmt,
unsigned int n_row);
650void odbc_set_sql_type_info(
TDSCOLUMN * col,
struct _drecord *drec, SQLINTEGER odbc_ver);
652int odbc_sql_to_c_type_default(
int sql_type);
653TDS_SERVER_TYPE odbc_sql_to_server_type(
TDSCONNECTION * conn,
int sql_type,
int sql_unsigned);
656unsigned int odbc_get_string_size(
int size,
const ODBC_CHAR * str _WIDE);
659 const TDS_DESC* axd,
unsigned int n_row);
661#ifdef ENABLE_ODBC_WIDE
662DSTR* odbc_dstr_copy_flag(
TDS_DBC *dbc,
DSTR *s,
int size,
const ODBC_CHAR * str,
int flag);
663#define odbc_dstr_copy(dbc, s, len, out) \
664 odbc_dstr_copy_flag(dbc, s, len, sizeof((out)->mb) ? (out) : (out), wide)
665#define odbc_dstr_copy_oct(dbc, s, len, out) \
666 odbc_dstr_copy_flag(dbc, s, len, out, wide|0x20)
668DSTR* odbc_dstr_copy(
TDS_DBC *dbc,
DSTR *s,
int size,
const ODBC_CHAR * str);
669#define odbc_dstr_copy_oct odbc_dstr_copy
674 const char *s,
int len,
int flag);
675#ifdef ENABLE_ODBC_WIDE
676#define odbc_set_string(dbc, buf, buf_len, out_len, s, s_len) \
677 odbc_set_string_flag(dbc, sizeof((buf)->mb) ? (buf) : (buf), buf_len, out_len, s, s_len, \
678 (wide) | (sizeof(*(out_len)) == sizeof(SQLSMALLINT)?0:0x10))
679#define odbc_set_string_oct(dbc, buf, buf_len, out_len, s, s_len) \
680 odbc_set_string_flag(dbc, buf, buf_len, out_len, s, s_len, (wide) | (sizeof(*(out_len)) == sizeof(SQLSMALLINT)?0x20:0x30))
682#define odbc_set_string(dbc, buf, buf_len, out_len, s, s_len) \
683 odbc_set_string_flag(dbc, buf, buf_len, out_len, s, s_len, (sizeof(*(out_len)) == sizeof(SQLSMALLINT)?0:0x10))
684#define odbc_set_string_oct(dbc, buf, buf_len, out_len, s, s_len) \
685 odbc_set_string_flag(dbc, buf, buf_len, out_len, s, s_len, (sizeof(*(out_len)) == sizeof(SQLSMALLINT)?0x20:0x30))
688#define odbc_set_dstr_oct(dbc, buf, buf_len, out_len, s) \
689 odbc_set_string_oct(dbc, buf, buf_len, out_len, tds_dstr_cstr(s), tds_dstr_len(s))
690#define odbc_set_dstr(dbc, buf, buf_len, out_len, s) odbc_set_string(dbc, buf, buf_len, out_len, tds_dstr_cstr(s), tds_dstr_len(s))
692SQLSMALLINT odbc_get_concise_sql_type(SQLSMALLINT type, SQLSMALLINT interval);
694SQLSMALLINT odbc_get_concise_c_type(SQLSMALLINT type, SQLSMALLINT interval);
697SQLLEN odbc_get_octet_len(
int c_type,
const struct _drecord *drec);
698void odbc_convert_err_set(
struct _sql_errors *errs, TDS_INT err);
703SQLRETURN prepare_call(
struct _hstmt *stmt);
704SQLRETURN native_sql(
struct _hdbc *dbc,
DSTR *s);
705int parse_prepared_query(
struct _hstmt *stmt,
bool compute_row);
706int start_parse_prepared_query(
struct _hstmt *stmt,
bool compute_row);
707int continue_parse_prepared_query(
struct _hstmt *stmt, SQLPOINTER DataPtr, SQLLEN StrLen_or_Ind);
708const char *parse_const_param(
const char * s, TDS_SERVER_TYPE *type);
709const char *odbc_skip_rpc_name(
const char *s);
715 bool compute_row,
const TDS_DESC* axd,
unsigned int n_row);
716TDS_INT convert_datetime2server(
int bindtype,
const void *src,
TDS_DATETIMEALL * dta);
721void odbc_bcp_free_storage(
TDS_DBC *dbc);
722void odbc_bcp_init(
TDS_DBC *dbc,
const ODBC_CHAR *tblname,
const ODBC_CHAR *hfile,
const ODBC_CHAR *errfile,
int direction _WIDE);
723void odbc_bcp_control(
TDS_DBC *dbc,
int field,
void *value);
724void odbc_bcp_colptr(
TDS_DBC *dbc,
const void * colptr,
int table_column);
725void odbc_bcp_sendrow(
TDS_DBC *dbc);
726int odbc_bcp_batch(
TDS_DBC *dbc);
727int odbc_bcp_done(
TDS_DBC *dbc);
728void odbc_bcp_bind(
TDS_DBC *dbc,
const void * varaddr,
int prefixlen,
int varlen,
const void * terminator,
int termlen,
729 int vartype,
int table_column);
734#if SIZEOF_SQLWCHAR != SIZEOF_WCHAR_T
735size_t sqlwcslen(
const SQLWCHAR * s);
737typedef struct sqlwstr_buf {
738 struct sqlwstr_buf *next;
741const wchar_t *sqlwstr(
const SQLWCHAR * s, SQLWSTRBUF **bufs);
742void sqlwstr_free(SQLWSTRBUF *bufs);
743#define SQLWSTR_BUFS(n) SQLWSTRBUF *bufs = NULL
744#define SQLWSTR(s) sqlwstr(s, &bufs)
745#define SQLWSTR_FREE() sqlwstr_free(bufs)
747#define sqlwcslen(s) wcslen(s)
749#define SQLWSTR_BUFS(n) do {} while(0)
750#define SQLWSTR(s) ((const wchar_t*)(s))
751#define SQLWSTR_FREE() do {} while(0)
757#define BCPHINTS_OLD 6
758#define SQL_COPT_TDSODBC_IMPL_BCP_CONTROL_OLD (SQL_COPT_TDSODBC_IMPL_BASE+1)
761#ifndef SQL_ATTR_DRIVER_UNICODE_TYPE
762#define SQL_ATTR_DRIVER_UNICODE_TYPE 1065
765#ifndef SQL_DM_CP_UTF16
766#define SQL_DM_CP_UTF16 1
768#ifndef SQL_DM_CP_UTF8
769#define SQL_DM_CP_UTF8 2
771#ifndef SQL_DM_CP_UCS4
772#define SQL_DM_CP_UCS4 3
775#include <freetds/popvis.h>
Main include file for libtds.
SQLRETURN odbc_set_concise_sql_type(SQLSMALLINT concise_type, struct _drecord *drec, int check_only)
Set concise type and all cascading field.
Definition odbc_util.c:985
SQLRETURN odbc_set_concise_c_type(SQLSMALLINT concise_type, struct _drecord *drec, int check_only)
Set concise type and all cascading field.
Definition odbc_util.c:1112
SQLINTEGER odbc_get_param_len(const struct _drecord *drec_axd, const struct _drecord *drec_ixd, const TDS_DESC *axd, unsigned int n_row)
Return length of parameter from parameter information.
Definition odbc_util.c:867
TDS_SERVER_TYPE odbc_c_to_server_type(int c_type)
Pass this an SQL_C_* type and get a SYB* type which most closely corresponds to the SQL_C_* type.
Definition odbc_util.c:602
SQLRETURN odbc_set_string_flag(TDS_DBC *dbc, SQLPOINTER buffer, SQLINTEGER cbBuffer, void FAR *pcbBuffer, const char *s, int len, int flag)
Copy a string to client setting size according to ODBC convenction.
Definition odbc_util.c:302
void odbc_rdbms_version(TDSSOCKET *tds_socket, char *pversion_string)
Returns the version of the RDBMS in the ODBC format.
Definition odbc_util.c:858
Descriptor header.
Definition odbc.h:155
Descriptor record.
Definition odbc.h:168
int focus
Nested descriptor to use.
Definition odbc.h:220
struct _hstmt * stmt_list
list of all statements allocated from this connection
Definition odbc.h:307
TDS_DESC * uad[TDS_MAX_APP_DESC]
descriptors associated to connection
Definition odbc.h:310
struct _hstmt * current_statement
Statement executing.
Definition odbc.h:305
unsigned int cursor_support
<>0 if server handle cursors
Definition odbc.h:312
unsigned int param_count
number of parameter in current query
Definition odbc.h:432
TDS_ODBC_ROW_STATUS row_status
status of row, it can happen that this flag mark that we are still parsing row, this it's normal
Definition odbc.h:437
size_t prepared_pos
position in prepared query to check parameters, used only in RPC
Definition odbc.h:427
TDS_INT8 row_count
row count to return
Definition odbc.h:435
int param_num
last valid parameter in params, it's a ODBC index (from 1 relative to descriptor)
Definition odbc.h:425
DSTR query
query to execute
Definition odbc.h:399
unsigned need_reprepare
Prepared statement needs to be prepared again.
Definition odbc.h:416
struct _hstmt * next
next in list
Definition odbc.h:404
TDSSOCKET * tds
socket (only if active)
Definition odbc.h:401
struct _hstmt * prev
previous in list
Definition odbc.h:406
TDSPARAMINFO * params
parameters saved
Definition odbc.h:423
This structure is not directly connected to TDS protocol but keeps any DATE/TIME information.
Definition tds.h:145
Metadata about columns in regular and compute rows.
Definition tds.h:674
Hold information for any results.
Definition tds.h:754
Holds information about a cursor.
Definition tds.h:922
Holds information for a dynamic (also called prepared) query.
Definition tds.h:962
Information for a server connection.
Definition tds.h:1162
Structure to hold a string.
Definition string.h:36