psqlodbc - prepared statement crash
Xuesong Gao <[email protected]> Fri, 26 Jul 2019 13:56:06 +0000
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <SN6PR16MB257432B26AE20A788EECE3CDA9C00@SN6PR16MB2574.namprd16.prod.outlook.com> |
--_004_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_
Content-Type: multipart/alternative;
boundary="_000_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_"
--_000_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I am using MS ODBCTest tool for testing purpose here, and it crashed after =
I did following steps:
1. Full connect to DSN.
2. SQLPrepare: select city, ? as i from public.city where city =3D ?
3. SQLBindParameter: number 1, value type SQL_C_CHAR, parameter type =
SQL_CHAR, value 1;
4. SQLBindParameter: number 2, value type SQL_C_CHAR, parameter type =
SQL_CHAR, value Abha;
5. SQLExecute
* your ODBC driver version
Unicode x64, 9.06.05.00
* your PostgreSQL database version
PostgreSQL 10, sample database dvdrental
* any error messages you saw on the screen
messages in ODBCTest tool console:
Full Connect(Default)
Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3
Successfully connected to DSN 'dvdrental'.
SQLPrepare:
In: =
StatementHandle =3D 0x00000000047221C0, StatementText =
=3D "select city, ? as i from public.city where city =3D ...", TextLength =
=3D 51
Return: SQL_SUCCE=
SS=3D0
SQLBindParameter:
In: =
StatementHandle =3D 0x00000000047221C0, ParameterNumber=
=3D 1, InputOutputtype =3D SQL_PARAM_INPUT=3D1, ValueType =3D SQL_C_CHAR=
=3D1,
=
ParameterType =3D SQL_CHAR=3D1=
, ColumnSize =3D 0, DecimalDigits =3D 0, ParameterValuePtr =3D "1", BufferL=
ength =3D 0, StrLen_or_IndPtr =3D SQL_NTS=3D-3, SQL_LEN_DATA_AT_EXEC =3D FA=
LSE,
=
Buffer Size =3D 600
Return: SQL_SUCCE=
SS=3D0
SQLBindParameter:
In: =
StatementHandle =3D 0x00000000047221C0, ParameterNumber=
=3D 2, InputOutputtype =3D SQL_PARAM_INPUT=3D1, ValueType =3D SQL_C_CHAR=
=3D1,
=
ParameterType =3D SQL_CHAR=3D1=
, ColumnSize =3D 0, DecimalDigits =3D 0, ParameterValuePtr =3D "Abha", Buff=
erLength =3D 0, StrLen_or_IndPtr =3D SQL_NTS=3D-3, SQL_LEN_DATA_AT_EXEC =3D=
FALSE,
=
Buffer Size =3D 600
Return: SQL_SUCCE=
SS=3D0
* the debug log (mylog_????.log) file (you will have to enable the mylo=
g driver option)
attached
[X]
Song X. Gao
Solutions Architect
Email [email protected]<mailto:[email protected]>
Mobile 732 406 6347
senturus.com<http://www.senturus.com/>
--_000_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:388848840;
mso-list-template-ids:2069926788;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:398289924;
mso-list-template-ids:836655818;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:685398992;
mso-list-type:hybrid;
mso-list-template-ids:1365947428 67698703 67698713 67698715 67698703 67698=
713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l2:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l3
{mso-list-id:869756766;
mso-list-template-ids:-1780307398;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:1189837309;
mso-list-template-ids:1930313038;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5
{mso-list-id:2114200411;
mso-list-template-ids:269768218;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I am using MS ODBCTest tool for testing purpose here=
, and it crashed after I did following steps:<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoListParagraph" style=3D"text-indent:-.25in;mso-list:l2 level=
1 lfo2"><![if !supportLists]><span style=3D"mso-list:Ignore">1.<span style=
=3D"font:7.0pt "Times New Roman""> &=
nbsp;
</span></span><![endif]>Full connect to DSN.<o:p></o:p></p>
<p class=3D"MsoListParagraph" style=3D"text-indent:-.25in;mso-list:l2 level=
1 lfo2"><![if !supportLists]><span style=3D"mso-list:Ignore">2.<span style=
=3D"font:7.0pt "Times New Roman""> &=
nbsp;
</span></span><![endif]>SQLPrepare: select city, ? as i from public.city wh=
ere city =3D ?<o:p></o:p></p>
<p class=3D"MsoListParagraph" style=3D"text-indent:-.25in;mso-list:l2 level=
1 lfo2"><![if !supportLists]><span style=3D"mso-list:Ignore">3.<span style=
=3D"font:7.0pt "Times New Roman""> &=
nbsp;
</span></span><![endif]>SQLBindParameter: number 1, value type SQL_C_CHAR, =
parameter type SQL_CHAR, value 1;<o:p></o:p></p>
<p class=3D"MsoListParagraph" style=3D"text-indent:-.25in;mso-list:l2 level=
1 lfo2"><![if !supportLists]><span style=3D"mso-list:Ignore">4.<span style=
=3D"font:7.0pt "Times New Roman""> &=
nbsp;
</span></span><![endif]>SQLBindParameter: number 2, value type SQL_C_CHAR, =
parameter type SQL_CHAR, value Abha;<o:p></o:p></p>
<p class=3D"MsoListParagraph" style=3D"text-indent:-.25in;mso-list:l2 level=
1 lfo2"><![if !supportLists]><span style=3D"mso-list:Ignore">5.<span style=
=3D"font:7.0pt "Times New Roman""> &=
nbsp;
</span></span><![endif]>SQLExecute<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<ul type=3D"disc">
<li class=3D"MsoNormal" style=3D"color:black;mso-margin-top-alt:auto;mso-ma=
rgin-bottom-alt:auto;mso-list:l0 level1 lfo5">
<span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser=
if">your ODBC driver version<o:p></o:p></span></li></ul>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">Unicode x64, 9.06.05.00<o:p></o:p></span></p>
<ul type=3D"disc">
<li class=3D"MsoNormal" style=3D"color:black;mso-margin-top-alt:auto;mso-ma=
rgin-bottom-alt:auto;mso-list:l0 level1 lfo5">
<span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser=
if">your PostgreSQL database version<o:p></o:p></span></li></ul>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">PostgreSQL 10, sample database dvdrental<o:p></o:p></span></p>
<ul type=3D"disc">
<li class=3D"MsoNormal" style=3D"color:black;mso-margin-top-alt:auto;mso-ma=
rgin-bottom-alt:auto;mso-list:l0 level1 lfo5">
<span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser=
if">any error messages you saw on the screen<o:p></o:p></span></li></ul>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">messages in ODBCTest tool console:<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp; Full Connect(Default)<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"><o:p> </o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp; Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3<o:p></o:p></span>=
</p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"><o:p> </o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp; Successfully connected to DSN 'dvdrental'.<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">SQLPrepare:<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; In:&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; StatementHandle =3D 0x00000000047221C0, St=
atementText =3D "select city, ? as i from public.city
where city =3D ...", TextLength =3D 51<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; Retu=
rn: SQL_SUCCESS=
=3D0<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">SQLBindParameter:<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; In:&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; StatementHandle =3D 0x00000000047221C0, Pa=
rameterNumber =3D 1, InputOutputtype =3D SQL_PARAM_INPUT=3D1,
ValueType =3D SQL_C_CHAR=3D1, <o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp; ParameterType =3D SQL_=
CHAR=3D1, ColumnSize =3D 0, DecimalDigits =3D 0,
ParameterValuePtr =3D "1", BufferLength =3D 0, StrLen_or_IndPtr =
=3D SQL_NTS=3D-3, SQL_LEN_DATA_AT_EXEC =3D FALSE,
<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp; Buffer Size =3D 600<o:=
p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; Retu=
rn: SQL_SUCCESS=
=3D0<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">SQLBindParameter:<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; In:&=
nbsp; &nbs=
p; &=
nbsp; &nbs=
p; StatementHandle =3D 0x00000000047221C0, Pa=
rameterNumber =3D 2, InputOutputtype =3D SQL_PARAM_INPUT=3D1,
ValueType =3D SQL_C_CHAR=3D1, <o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp; ParameterType =3D SQL_=
CHAR=3D1, ColumnSize =3D 0, DecimalDigits =3D 0,
ParameterValuePtr =3D "Abha", BufferLength =3D 0, StrLen_or_IndP=
tr =3D SQL_NTS=3D-3, SQL_LEN_DATA_AT_EXEC =3D FALSE,
<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp;  =
; &n=
bsp; Buffer Size =3D 600<o:=
p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0"> &n=
bsp;  =
; &n=
bsp; Retu=
rn: SQL_SUCCESS=
=3D0<o:p></o:p></span></p>
<ul type=3D"disc">
<li class=3D"MsoNormal" style=3D"color:black;mso-margin-top-alt:auto;mso-ma=
rgin-bottom-alt:auto;mso-list:l0 level1 lfo5">
<span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser=
if">the debug log (mylog_????.log) file (you will have to enable the mylog =
driver option)<o:p></o:p></span></li></ul>
<p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a=
lt:auto;margin-left:.5in">
<span style=3D"font-size:12.0pt;font-family:"Arial",sans-serif;co=
lor:#00B0F0">attached<o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<table class=3D"MsoNormalTable" border=3D"0" cellspacing=3D"0" cellpadding=
=3D"0" style=3D"border-collapse:collapse">
<tbody>
<tr>
<td rowspan=3D"2" valign=3D"top" style=3D"padding:0in 0in 0in 0in">
<p class=3D"MsoNormal" style=3D"line-height:12.0pt"><span style=3D"font-siz=
e:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71"><img=
width=3D"110" height=3D"105" id=3D"_x0000_i1025" src=3D"file:///C:\Users\S=
ong\AppData\Roaming\Microsoft\Signatures\senturus-signature_files\senturus-=
logo-small.jpg"><o:p></o:p></span></p>
</td>
<td style=3D"padding:4.5pt 0in 7.5pt 3.75pt">
<p class=3D"MsoNormal" style=3D"line-height:12.0pt"><b><span style=3D"font-=
size:10.0pt;color:black">Song X. Gao</span></b><span style=3D"font-si=
ze:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71"><br=
>
Solutions Architect<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style=3D"padding:0in 0in 0in 3.75pt">
<p class=3D"MsoNormal" style=3D"line-height:12.0pt"><span style=3D"font-siz=
e:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71">Emai=
l
<a href=3D"mailto:[email protected]"><span style=3D"color:blue">xgao@sentur=
us.com</span></a><br>
Mobile 732 406 6347<br>
<a href=3D"http://www.senturus.com/"><b><span style=3D"font-size:10.0pt;col=
or:black;text-decoration:none">senturus.com</span></b></a><o:p></o:p></span=
></p>
</td>
</tr>
</tbody>
</table>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
--_000_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_--
--_004_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_
Content-Type: application/octet-stream; name="mylog_odbct32w_7728.log"
Content-Description: mylog_odbct32w_7728.log
Content-Disposition: attachment; filename="mylog_odbct32w_7728.log";
size=2633; creation-date="Fri, 26 Jul 2019 13:48:58 GMT";
modification-date="Fri, 26 Jul 2019 13:54:51 GMT"
Content-Transfer-Encoding: base64
WzEyODY4LTAuMDAwXSAgIG15bG9nLmNbbG9nc19vbl9vZmZdMjc0OiBteWxvZ19vbj0xIHFsb2df
b249MQpbMTI4NjgtMC4wMDBdCXN0YXJ0X2xvZ2dpbmc6R2xvYmFsLmRlYnVnJmNvbW1sb2c9MSYx
ClsxMjg2OC0wLjAwMF1wc3Fsb2RiYy5jW0RsbE1haW5dMTMwOiBleGUgbmFtZT1vZGJjdDMydwpb
MTI4NjgtMC4wMDBdb2RiY2FwaTMwLltTUUxBbGxvY0hhbmRsZV00MDogRW50ZXJpbmcKWzEyODY4
LTAuMDAwXSBlbnZpcm9uLmNbUEdBUElfQWxsb2NFbnZdNjk6IGVudGVyaW5nClsxMjg2OC0wLjAw
MF0gZW52aXJvbi5jW1BHQVBJX0FsbG9jRW52XTg4OiBsZWF2aW5nIHBoZW52PTAwMDAwMDAwMDA2
MUQyRDAKWzEyODY4LTAuMDE1XW9kYmNhcGkzMC5bU1FMU2V0RW52QXR0cl00Nzc6IEVudGVyaW5n
IGF0dD0yMDAsMwpbMTI4NjgtMC4wMTVdb2RiY2FwaTMwLltTUUxBbGxvY0hhbmRsZV00MDogRW50
ZXJpbmcKWzEyODY4LTAuMDE1XWNvbm5lY3Rpb25bUEdBUElfQWxsb2NDb25uZWN0XTgwOiBlbnRl
cmluZy4uLgpbMTI4NjgtMC4wMTVdY29ubmVjdGlvbltQR0FQSV9BbGxvY0Nvbm5lY3RdODM6ICoq
KiogaGVudiA9IDAwMDAwMDAwMDA2MUQyRDAsIGNvbm4gPSAwMDAwMDAwMDAwNjI0MkQwClsxMjg2
OC0wLjAxNV0gZW52aXJvbi5jW0VOX2FkZF9jb25uZWN0aW9uXTU4OTogZW50ZXJpbmcgc2VsZiA9
IDAwMDAwMDAwMDA2MUQyRDAsIGNvbm4gPSAwMDAwMDAwMDAwNjI0MkQwClsxMjg2OC0wLjAxNV0g
ZW52aXJvbi5jW0VOX2FkZF9jb25uZWN0aW9uXTYxMzogICAgICAgIGFkZGVkIGF0IDAsIGNvbm4t
PmhlbnYgPSAwMDAwMDAwMDAwNjFEMkQwLCBjb25uc1swXS0+aGVudiA9IDAwMDAwMDAwMDA2MUQy
RDAKWzEyODY4LTAuMDE1XW9kYmNhcGl3LmNbU1FMR2V0SW5mb1ddNDE3OiBFbnRlcmluZwpbMTI4
NjgtMC4wMTVdICAgIGluZm8uY1tQR0FQSV9HZXRJbmZvXTcxOiBlbnRlcmluZy4uLmZJbmZvVHlw
ZT03NwpbMTI4NjgtMC4wMTVdICAgIGluZm8uY1tQR0FQSV9HZXRJbmZvXTEwMzA6IHA9JzAzLjUx
JywgbGVuPTAsIHZhbHVlPTAsIGNiTWF4PTEyClsxMjg2OC0wLjAxNV1vZGJjYXBpMzB3W1NRTFNl
dENvbm5lY3RBdHRyV105NTogRW50ZXJpbmcKWzEyODY4LTAuMDMxXSBwZ2FwaTMwLmNbUEdBUElf
U2V0Q29ubmVjdEF0dHJdMTY1NzogZW50ZXJpbmcgZm9yIDAwMDAwMDAwMDA2MjQyRDA6IDExNSAw
MDAwMDAwMDAwMDAwMDAwClsxMjg2OC0wLjAzMV0gcGdhcGkzMC5jW1BHQVBJX1NldENvbm5lY3RB
dHRyXTE2NzI6IHRoZSBhcHBsaWNhdGlvbiBpcyB1bmljb2RlClsxMjg2OC0wLjAzMV1vZGJjYXBp
dy5jW1NRTERyaXZlckNvbm5lY3RXXTE0MDogRW50ZXJpbmcKWzEyODY4LTAuMDMxXXdpbl91bmlj
b2RbdWNzMl90b191dGY4XTEzNTogMDAwMDAwMDAwNDcyMjFDMCBpbGVuPS0zICBuZXdsZW49MTQg
b2xlbj0xNCB1dGY4c3RyPURTTj1kdmRyZW50YWw7ClsxMjg2OC0wLjAzMV0gZHJ2Y29ubi5jW1BH
QVBJX0RyaXZlckNvbm5lY3RdMTE5OiBlbnRlcmluZy4uLgpbMTI4NjgtMC4wMzFdIGRydmNvbm4u
Y1tQR0FQSV9Ecml2ZXJDb25uZWN0XTEzMDogKioqKiBmRHJpdmVyQ29tcGxldGlvbj0xLCBjb25u
U3RySW49J0RTTj1kdmRyZW50YWw7JwpbMTI4NjgtMC4wMzFdZGxnX3NwZWNpZltDQ19jb25uaW5m
b19pbml0XTE2ODY6IGVudGVyaW5nIG9wdD0yClsxMjg2OC0wLjAzMV0gZHJ2Y29ubi5jW2Rjb25u
X2dldF9hdHRyaWJ1dGVzXTQ2Nzogb3VyX2Nvbm5lY3Rfc3RyaW5nID0gJ0RTTj1kdmRyZW50YWw7
JwpbMTI4NjgtMC4wMzFdZGxnX3NwZWNpZltnZXREU05pbmZvXTg1ODogZW50ZXJpbmcgRFNOPWR2
ZHJlbnRhbCBkcml2ZXI9JihudWxsKQpbMTI4NjgtMC4wMzFdZGxnX3NwZWNpZltnZXRDaURlZmF1
bHRzXTc3NjogZW50ZXJpbmcKWzEyODY4LTAuMDMxXWRsZ19zcGVjaWZbZ2V0RFNOaW5mb104Nzk6
IGRyaXZlcm5hbWU9UG9zdGdyZVNRTCBVbmljb2RlKHg2NCkKWzEyODY4LTAuMDMxXWRsZ19zcGVj
aWZbZ2V0RHJpdmVyc0RlZmF1bHRzXTg0MDogMDAwMDAwMDAwMDYyNEI1MCBvZiB0aGUgZHJpdmVy
IFBvc3RncmVTUUwgVW5pY29kZSh4NjQpClsxMjg2OC0wLjAzMV1kbGdfc3BlY2lmW2dldF9DaV9E
cml2ZXJzXTE0MDI6IGNvbXZhbD0wMDAwMDAwMDAwNjI0QjUwIGNvbXZhbC0+ZXh0cmFfc3lzdGFi
bGVfcHJlZml4ZXMgPSAnJwpbMTI4NjgtMC4wNDZdZGxnX3NwZWNpZltnZXREU05pbmZvXTEwMjc6
IGZvcmNlX2FiYnJldj0wIGJkZT0wIGN2dF9udWxsX2RhdGU9MApbMTI4NjgtMC4wNDZdZGxnX3Nw
ZWNpZltnZXRfQ2lfRHJpdmVyc10xMzA0OiBzZXR0aW5nIE9EQkMuSU5JIHBvc2l0aW9uIG9mIGR2
ZHJlbnRhbCgwMDAwMDAwMDAwNjI0QjUwKQpbMTI4NjgtMC4wNDZdZGxnX3NwZWNpZltnZXRfQ2lf
RHJpdmVyc10xNDAyOiBjb212YWw9MDAwMDAwMDAwMDYyNEI1MCBjb212YWwtPmV4dHJhX3N5c3Rh
YmxlX3ByZWZpeGVzID0gJycKWzEyODY4LTAuMDQ2XSBkcnZjb25uLmNbZGNvbm5fZ2V0X2F0dHJp
YnV0ZXNdNDY3OiBvdXJfY29ubmVjdF9zdHJpbmcgPSAnRFNOPWR2ZHJlbnRhbDsnClsxMjg2OC0w
LjA0Nl1kbGdfc3BlY2lmW2NvcHlDb25uQXR0cmlidXRlc103Njc6IGtleT0nRFNOJyB2YWx1ZT0n
ZHZkcmVudGFsJwo=
--_004_SN6PR16MB257432B26AE20A788EECE3CDA9C00SN6PR16MB2574namp_--