Re: psqlodbc - prepared statement crash
"Inoue, Hiroshi" <[email protected]> Wed, 31 Jul 2019 20:51:21 +0900
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------68AF7C0EF0273535A66583A9 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, Sorry for the late reply. You seem to turn on Mylog optipn of Global settings only. Could you please turn on Mylog option of Advanced Options (DataSource) as well? I have a question. What does "city = ..." of StatementText = "select city, ? as i from public.city where city = ...", mean? regards, Hiroshi Inoue On 2019/07/26 22:56, Xuesong Gao wrote: > > 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 = ? > > 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 = 0x00000000047221C0, StatementText = "select > city, ? as i from public.city where city = ...", TextLength = 51 > > Return: SQL_SUCCESS=0 > > SQLBindParameter: > > In: StatementHandle = 0x00000000047221C0, ParameterNumber = 1, > InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1, > > ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, > ParameterValuePtr = "1", BufferLength = 0, StrLen_or_IndPtr = > SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE, > > Buffer Size = 600 > > Return: SQL_SUCCESS=0 > > SQLBindParameter: > > In: StatementHandle = 0x00000000047221C0, ParameterNumber = 2, > InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1, > > ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, > ParameterValuePtr = "Abha", BufferLength = 0, StrLen_or_IndPtr = > SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE, > > Buffer Size = 600 > > Return: SQL_SUCCESS=0 > > * the debug log (mylog_????.log) file (you will have to enable the > mylog driver option) > > attached > > > > *Song X. Gao* > Solutions Architect > > Email [email protected] <mailto:[email protected]> > Mobile 732 406 6347 > *senturus.com* <http://www.senturus.com/> > --- このメールは、AVG によってウイルス チェックされています。 http://www.avg.com --------------68AF7C0EF0273535A66583A9 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body text="#000000" bgcolor="#FFFFFF"> Hi,<br> <br> Sorry for the late reply.<br> <br> You seem to turn on Mylog optipn of Global settings only.<br> Could you please turn on Mylog option of Advanced Options (DataSource) as well?<br> <br> I have a question.<br> What does "city = ..." of<br> <span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> StatementText = "select city, ? as i from public.city where city = ...",<br> mean?<br> </span><br> regards,<br> Hiroshi Inoue<br> <br> <div class="moz-cite-prefix">On 2019/07/26 22:56, Xuesong Gao wrote:<br> </div> <blockquote type="cite" cite="mid:SN6PR16MB257432B26AE20A788EECE3CDA9C00@SN6PR16MB2574.namprd16.prod.outlook.com"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="Generator" content="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 67698713 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="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> <div class="WordSection1"> <p class="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="MsoNormal"><o:p> </o:p></p> <p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l2 level1 lfo2"><!--[if !supportLists]--><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman""> </span></span><!--[endif]-->Full connect to DSN.<o:p></o:p></p> <p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l2 level1 lfo2"><!--[if !supportLists]--><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman""> </span></span><!--[endif]-->SQLPrepare: select city, ? as i from public.city where city = ?<o:p></o:p></p> <p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l2 level1 lfo2"><!--[if !supportLists]--><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman""> </span></span><!--[endif]-->SQLBindParameter: number 1, value type SQL_C_CHAR, parameter type SQL_CHAR, value 1;<o:p></o:p></p> <p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l2 level1 lfo2"><!--[if !supportLists]--><span style="mso-list:Ignore">4.<span style="font:7.0pt "Times New Roman""> </span></span><!--[endif]-->SQLBindParameter: number 2, value type SQL_C_CHAR, parameter type SQL_CHAR, value Abha;<o:p></o:p></p> <p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l2 level1 lfo2"><!--[if !supportLists]--><span style="mso-list:Ignore">5.<span style="font:7.0pt "Times New Roman""> </span></span><!--[endif]-->SQLExecute<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <ul type="disc"> <li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo5"> <span style="font-size:12.0pt;font-family:"Times New Roman",serif">your ODBC driver version<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">Unicode x64, 9.06.05.00<o:p></o:p></span></p> <ul type="disc"> <li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo5"> <span style="font-size:12.0pt;font-family:"Times New Roman",serif">your PostgreSQL database version<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">PostgreSQL 10, sample database dvdrental<o:p></o:p></span></p> <ul type="disc"> <li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo5"> <span style="font-size:12.0pt;font-family:"Times New Roman",serif">any error messages you saw on the screen<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">messages in ODBCTest tool console:<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Full Connect(Default)<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"><o:p> </o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"><o:p> </o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Successfully connected to DSN 'dvdrental'.<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">SQLPrepare:<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> In: StatementHandle = 0x00000000047221C0, StatementText = "select city, ? as i from public.city where city = ...", TextLength = 51<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Return: SQL_SUCCESS=0<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">SQLBindParameter:<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> In: StatementHandle = 0x00000000047221C0, ParameterNumber = 1, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1, <o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "1", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE, <o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Buffer Size = 600<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Return: SQL_SUCCESS=0<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">SQLBindParameter:<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> In: StatementHandle = 0x00000000047221C0, ParameterNumber = 2, InputOutputtype = SQL_PARAM_INPUT=1, ValueType = SQL_C_CHAR=1, <o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> ParameterType = SQL_CHAR=1, ColumnSize = 0, DecimalDigits = 0, ParameterValuePtr = "Abha", BufferLength = 0, StrLen_or_IndPtr = SQL_NTS=-3, SQL_LEN_DATA_AT_EXEC = FALSE, <o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Buffer Size = 600<o:p></o:p></span></p> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0"> Return: SQL_SUCCESS=0<o:p></o:p></span></p> <ul type="disc"> <li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo5"> <span style="font-size:12.0pt;font-family:"Times New Roman",serif">the debug log (mylog_????.log) file (you will have to enable the mylog driver option)<o:p></o:p></span></li> </ul> <p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:.5in"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#00B0F0">attached<o:p></o:p></span></p> <p class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal"><o:p> </o:p></p> <table class="MsoNormalTable" style="border-collapse:collapse" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td rowspan="2" style="padding:0in 0in 0in 0in" valign="top"> <p class="MsoNormal" style="line-height:12.0pt"><span style="font-size:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71"><img id="_x0000_i1025" src="file:///C:\Users\Song\AppData\Roaming\Microsoft\Signatures\senturus-signature_files\senturus-logo-small.jpg" moz-do-not-send="true" width="110" height="105"><o:p></o:p></span></p> </td> <td style="padding:4.5pt 0in 7.5pt 3.75pt"> <p class="MsoNormal" style="line-height:12.0pt"><b><span style="font-size:10.0pt;color:black">Song X. Gao</span></b><span style="font-size:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71"><br> Solutions Architect<o:p></o:p></span></p> </td> </tr> <tr> <td style="padding:0in 0in 0in 3.75pt"> <p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Trebuchet MS",sans-serif;color:#6D6E71">Email <a href="mailto:[email protected]" moz-do-not-send="true"><span style="color:blue">[email protected]</span></a><br> Mobile 732 406 6347<br> <a href="http://www.senturus.com/" moz-do-not-send="true"><b><span style="font-size:10.0pt;color:black;text-decoration:none">senturus.com</span></b></a></span><o:p><br> </o:p></p> </td> </tr> </tbody> </table> <p class="MsoNormal"><o:p> </o:p></p> </div> </blockquote> <br> <div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top: 1px solid #D3D4DE;"> <tr> <td style="width: 55px; padding-top: 18px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td> <td style="width: 470px; padding-top: 17px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">ウイルス フリー｡ <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a> </td> </tr> </table> <a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body> </html> --------------68AF7C0EF0273535A66583A9--