My favorites
▼
|
Sign in
pyodbc
Python ODBC library
Project Home
Downloads
Wiki
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
217
attachment: sql.log
(10.1 KB)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
** iODBC Trace file
** Trace started on Sat Oct 15 18:57:38 2011
** Driver Manager: 03.52.0709.0909
Python 7FFF70CEFCC0 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x100504fc0
Python 7FFF70CEFCC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x100504fc0 (0x1003c9ff0)
Python 7FFF70CEFCC0 ENTER SQLSetEnvAttr
SQLHENV 0x1003c9ff0
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * 4
Python 7FFF70CEFCC0 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x1003c9ff0
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * 4
Python 7FFF70CEFCC0 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x1003c9ff0
SQLHANDLE * 0x7fff5fbfe978
Python 7FFF70CEFCC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x1003c9ff0
SQLHANDLE * 0x7fff5fbfe978 (0x1003c7620)
Python 7FFF70CEFCC0 ENTER SQLDriverConnectW
SQLHDBC 0x1003c7620
SQLPOINTER 0x0
SQLWCHAR * 0x1003b7440
| DSN=ms_2005;UID=scott;PWD=*****; |
SQLSMALLINT 32
SQLWCHAR * 0x0
SQLSMALLINT 0
SQLSMALLINT * 0x0
SQLUSMALLINT 0 (SQL_DRIVER_NOPROMPT)
Python 7FFF70CEFCC0 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x1003c7620
SQLPOINTER 0x0
SQLWCHAR * 0x1003b7440
SQLSMALLINT 32
SQLWCHAR * 0x0
SQLSMALLINT 0
SQLSMALLINT * 0x0
SQLUSMALLINT 0 (SQL_DRIVER_NOPROMPT)
Python 7FFF70CEFCC0 ENTER SQLSetConnectAttr
SQLHDBC 0x1003c7620
SQLINTEGER 102 (SQL_ATTR_AUTOCOMMIT)
SQLPOINTER 0x0
SQLINTEGER * 4294967291 (SQL_IS_UINTEGER)
Python 7FFF70CEFCC0 EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
SQLHDBC 0x1003c7620
SQLINTEGER 102 (SQL_ATTR_AUTOCOMMIT)
SQLPOINTER 0x0
SQLINTEGER * 4294967291 (SQL_IS_UINTEGER)
Python 7FFF70CEFCC0 ENTER SQLGetInfo
SQLHDBC 0x1003c7620
SQLUSMALLINT 77 (SQL_DRIVER_ODBC_VER)
SQLPOINTER 0x7fff5fbfe8e0
SQLSMALLINT 20
SQLSMALLINT * 0x7fff5fbfe8de
Python 7FFF70CEFCC0 EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
SQLHDBC 0x1003c7620
SQLUSMALLINT 77 (SQL_DRIVER_ODBC_VER)
SQLPOINTER 0x7fff5fbfe8e0
| 03.50 |
SQLSMALLINT 20
SQLSMALLINT * 0x7fff5fbfe8de (5)
Python 7FFF70CEFCC0 ENTER SQLGetInfo
SQLHDBC 0x1003c7620
SQLUSMALLINT 10002 (SQL_DESCRIBE_PARAMETER)
SQLPOINTER 0x7fff5fbfe8d0
SQLSMALLINT 2
SQLSMALLINT * 0x7fff5fbfe8de
Python 7FFF70CEFCC0 EXIT SQLGetInfo with return code 0 (SQL_SUCCESS)
SQLHDBC 0x1003c7620
SQLUSMALLINT 10002 (SQL_DESCRIBE_PARAMETER)
SQLPOINTER 0x7fff5fbfe8d0
| N |
SQLSMALLINT 2
SQLSMALLINT * 0x7fff5fbfe8de (1)
Python 7FFF70CEFCC0 ENTER SQLAllocHandle
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x1003c7620
SQLHANDLE * 0x7fff5fbfe8c0
Python 7FFF70CEFCC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x1003c7620
SQLHANDLE * 0x7fff5fbfe8c0 (0x100395f60)
Python 7FFF70CEFCC0 ENTER SQLGetTypeInfo
SQLHSTMT 0x100395f60
SQLSMALLINT 93 (SQL_TYPE_TIMESTAMP)
Python 7FFF70CEFCC0 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLSMALLINT 93 (SQL_TYPE_TIMESTAMP)
Python 7FFF70CEFCC0 ENTER SQLFetch
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 ENTER SQLGetData
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
| 335007449111 |
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 ENTER SQLFreeStmt
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 ENTER SQLGetTypeInfo
SQLHSTMT 0x100395f60
SQLSMALLINT 12 (SQL_VARCHAR)
Python 7FFF70CEFCC0 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLSMALLINT 12 (SQL_VARCHAR)
Python 7FFF70CEFCC0 ENTER SQLFetch
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 ENTER SQLGetData
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
| 335007457088 |
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 ENTER SQLFreeStmt
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 ENTER SQLGetTypeInfo
SQLHSTMT 0x100395f60
SQLSMALLINT -9 (SQL_WVARCHAR)
Python 7FFF70CEFCC0 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLSMALLINT -9 (SQL_WVARCHAR)
Python 7FFF70CEFCC0 ENTER SQLFetch
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 ENTER SQLGetData
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
| 335007449098 |
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 ENTER SQLFreeStmt
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 ENTER SQLGetTypeInfo
SQLHSTMT 0x100395f60
SQLSMALLINT -2 (SQL_BINARY)
Python 7FFF70CEFCC0 EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLSMALLINT -2 (SQL_BINARY)
Python 7FFF70CEFCC0 ENTER SQLFetch
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
Python 7FFF70CEFCC0 ENTER SQLGetData
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 3
SQLSMALLINT 4 (SQL_C_LONG)
SQLPOINTER 0x7fff5fbfe8cc
| 335007457088 |
SQLLEN 4
SQLLEN * 0x0
Python 7FFF70CEFCC0 ENTER SQLFreeStmt
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x100395f60
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 ENTER SQLAllocHandle
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x1003c7620
SQLHANDLE * 0x1005dcac8
Python 7FFF70CEFCC0 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x1003c7620
SQLHANDLE * 0x1005dcac8 (0x1003b0ad0)
Python 7FFF70CEFCC0 ENTER SQLFreeStmt
SQLHSTMT 0x1003b0ad0
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x1003b0ad0
SQLUSMALLINT 0 (SQL_CLOSE)
Python 7FFF70CEFCC0 ENTER SQLPrepare
SQLHSTMT 0x1003b0ad0
SQLCHAR * 0x1004b2084
| select ? |
SQLINTEGER -3 (SQL_NTS)
Python 7FFF70CEFCC0 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x1003b0ad0
SQLCHAR * 0x1004b2084
SQLINTEGER -3 (SQL_NTS)
Python 7FFF70CEFCC0 ENTER SQLNumParams
SQLHSTMT 0x1003b0ad0
SQLSMALLINT * 0x7fff5fbfebee
Python 7FFF70CEFCC0 EXIT SQLNumParams with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x1003b0ad0
SQLSMALLINT * 0x7fff5fbfebee (1)
Python 7FFF70CEFCC0 ENTER SQLBindParameter
SQLHSTMT 0x1003b0ad0
SQLSMALLINT 1
SQLSMALLINT 1 (SQL_PARAM_INPUT)
SQLSMALLINT -8 (SQL_C_WCHAR)
SQLSMALLINT -9 (SQL_WVARCHAR)
SQLUINTEGER 2
SQLSMALLINT 0
SQLPOINTER 0x100398d90
SQLLEN 0
SQLLEN * 0x100354b88
Powered by
Google Project Hosting