Test ODBC Progress <br>connected to DSN: Progress <br>executing 'SELECT * FROM usr_mstr' Results: <table BGCOLOR='#AAFFAA' border=3 width=30% bordercolordark='#FF0000' ><tr><th>usr_userid</th><th>usr_lang</th><th>usr_user1</th><th>usr_user2</th><th>usr_site</th><th>usr__qadc05</th><th>usr_passwd</th><th>usr_name</th><th>usr_last_date</th><th>usr__qad01</th><th>usr__qad02</th><th>usr__qadl03</th><th>usr__qadc03</th><th>usr_addr</th><th>usr_restrict</th><th>usr__qadc02</th><th>usr__qadi02</th><th>usr__qadc01</th><th>usr__qadl01</th><th>usr__qadl02</th><th>usr__qadc04</th><th>usr__qadi01</th><th>usr_mail_address</th><th>usr_type</th><th>usr_timezone</th><th>usr_access_type</th><th>usr_access_loc</th><th>usr_ctry_code</th><th>usr_variant_code</th><th>usr_failed_attempts</th><th>usr_force_change</th><th>usr_logon_date</th><th>usr_active</th><th>usr_active_by</th><th>usr_active_reason</th><th>usr_active_date</th><th>usr_logon_timezone</th><th>usr_remark</th><th>usr_logon_time</th><th>oid_usr_mstr</th><th>usr_initials</th><th>usr_enabled</th><th>usr_tzdb</th><th>usr_last_time</th><th>usr_active_dir_userid</th><th>usr_ldap_dn</th><th>usr_active_dir_enabled</th><th>usr_mail_address_login</th><th>usr_ldap_instance</th></tr>
<tr><td>1-01</td><td>US</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIRF6+UREWNScgjwc3tmCw5X2pstupkGMscTZkR3Ika61FfH0RBucR65k=</td><td>BUYER</td><td>2020-07-29</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>Primary</td><td>USA</td><td></td><td>0</td><td>0</td><td>2020-07-29</td><td>1</td><td>rgk</td><td>QAD_DEF</td><td>2010-05-11</td><td>-240</td><td></td><td>33836</td><td>201005110001587446.0009000000</td><td></td><td>1</td><td></td><td>55435</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>1-02</td><td>US</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>1-02</td><td>2010-05-11</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>Primary</td><td>USA</td><td></td><td>0</td><td>1</td><td>NULL</td><td>1</td><td>rgk</td><td>QAD_DEF</td><td>2010-05-11</td><td></td><td></td><td>0</td><td>201005110001587488.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>ch</td><td>ch</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Chinese user</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+8</td><td>1</td><td>PRIMARY</td><td>CH</td><td></td><td>0</td><td>0</td><td>2014-07-23</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>PST/PDT</td><td></td><td>61418</td><td>200805280000623603.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>cs</td><td>cs</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Castilian Spanish User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+1</td><td>1</td><td>PRIMARY</td><td>ES</td><td></td><td>0</td><td>0</td><td>2014-03-07</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td></td><td></td><td>71853</td><td>200805280000623589.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>demo</td><td>us</td><td></td><td></td><td></td><td></td><td>ihdbjckkUjcjjfic</td><td>Demo User</td><td>2014-03-14</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td>demo@qaddemo</td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>US</td><td></td><td>1</td><td>0</td><td>2016-02-10</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-02-20</td><td>60</td><td></td><td>64916</td><td>200802200000261355.3792532000</td><td></td><td>1</td><td></td><td>51350</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>du</td><td>du</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Dutch User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+1</td><td>1</td><td>PRIMARY</td><td>NL</td><td></td><td>0</td><td>0</td><td>2012-05-14</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td></td><td></td><td>46624</td><td>200805280000623593.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>fr</td><td>fr</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>French User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+1</td><td>1</td><td>PRIMARY</td><td>FR</td><td></td><td>0</td><td>0</td><td>2014-10-01</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>PST/PDT</td><td></td><td>47770</td><td>200805280000623597.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>ge</td><td>ge</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>German Language User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>DE</td><td></td><td>0</td><td>0</td><td>2014-09-30</td><td>1</td><td>demo</td><td>QAD_DEF</td><td>2008-05-28</td><td>PST/PDT</td><td></td><td>78695</td><td>200805280000623181.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>it</td><td>it</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Italian User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+1</td><td>1</td><td>PRIMARY</td><td>IT</td><td></td><td>0</td><td>0</td><td>2011-01-14</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td></td><td></td><td>74941</td><td>200805280000623634.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>jp</td><td>jp</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Japanese User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+9</td><td>1</td><td>PRIMARY</td><td>JP</td><td></td><td>0</td><td>0</td><td>2012-02-21</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>PST/PDT</td><td></td><td>47713</td><td>200805280000623638.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>ls</td><td>ls</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Latin Spanish User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT-6</td><td>1</td><td>PRIMARY</td><td>MX</td><td></td><td>0</td><td>0</td><td>2011-01-14</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td></td><td></td><td>75793</td><td>200805280000623642.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>mfg</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIDm/TFhpPUuIg0Dukacb1+SB7/CH0mW6GC25ORm6B8nZBfOevFbSJLW0=</td><td>mfg</td><td>2016-12-04</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td>spezionet@yahoo.com.br</td><td>3</td><td>GMT-3</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>0</td><td>0</td><td>2025-04-18</td><td>1</td><td>lrr</td><td>QAD_DEF</td><td>2003-12-09</td><td>120</td><td></td><td>229</td><td>200312090000025559.0000000000</td><td>mfg</td><td>1</td><td></td><td>77222</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>pl</td><td>pl</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Polish User</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+2</td><td>1</td><td>PRIMARY</td><td>PL</td><td></td><td>0</td><td>0</td><td>2012-01-30</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>GMT+2</td><td></td><td>55216</td><td>200805280000623646.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>po</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIR0y3NWdfehIgLEV01PngUTbylwl1rDzapjupaQ/IJZro8l19uxQE5zE=</td><td>Portuguese User</td><td>2021-07-01</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>EST-BRAZ</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>0</td><td>0</td><td>2021-07-01</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>EST/EDT</td><td></td><td>32279</td><td>200805280000623622.0009000000</td><td></td><td>1</td><td></td><td>13552</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>QAD</td><td>us</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAILVXXQVp1bwogrxSZNE6GD9QScdw9IxpKe1Kb8sr9x09zIR5xFyWxfKo=</td><td>Vice President</td><td>2019-04-29</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>US</td><td></td><td>3</td><td>0</td><td>2023-10-16</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2007-06-18</td><td>-240</td><td></td><td>82884</td><td>200706180000192375.3792532000</td><td>QAD</td><td>1</td><td></td><td>68876</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>qmi</td><td>US</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>CFO</td><td>2010-05-13</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>Primary</td><td>USA</td><td></td><td>0</td><td>0</td><td>2016-02-11</td><td>1</td><td>rgk</td><td>QAD_DEF</td><td>2010-05-13</td><td>-480</td><td></td><td>34895</td><td>201005130001591237.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>rgk</td><td>US</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Robin Kronk</td><td>2010-02-02</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td>rgk@qad.com</td><td>1</td><td>EST/EDT</td><td>1</td><td>PRIMARY</td><td>USA</td><td></td><td>2</td><td>0</td><td>2010-08-04</td><td>0</td><td>qmi</td><td>OBSOLETE</td><td>2013-07-31</td><td>PST/PDT</td><td></td><td>58559</td><td>201002020001404440.0009000000</td><td>rgk</td><td>0</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>sysadmin</td><td>US</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIFHkZzfyraqIg1PgGjxJWyyTkxlagDjd746OcN+gjygb3sUReWVWUzL8=</td><td>System Admin User - Daemons</td><td>2016-12-04</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td>demo@qaddemo</td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>USA</td><td></td><td>0</td><td>0</td><td>2024-07-02</td><td>1</td><td>demo</td><td>QAD_DEF</td><td>2010-05-10</td><td>-180</td><td></td><td>53882</td><td>201005100001584635.0009000000</td><td></td><td>1</td><td></td><td>76982</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>syscrm</td><td>us</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Integration User for CRM</td><td>2011-02-11</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>Corp</td><td>us</td><td></td><td>0</td><td>0</td><td>2016-01-19</td><td>1</td><td>qmi</td><td>QAD_DEF</td><td>2011-01-12</td><td>-480</td><td></td><td>46791</td><td>201101120004115816.0009000000</td><td></td><td>1</td><td></td><td>76014</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>tw</td><td>tw</td><td></td><td></td><td></td><td></td><td>pjqtudckibycRKbj</td><td>Traditional Chinese (Taiwan)</td><td>2008-05-28</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>GMT+8</td><td>1</td><td>PRIMARY</td><td>TW</td><td></td><td>0</td><td>0</td><td>2011-01-14</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-05-28</td><td>PST/PDT</td><td></td><td>75941</td><td>200805280000623650.0009000000</td><td></td><td>1</td><td></td><td>0</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>UserA</td><td>US</td><td></td><td></td><td></td><td></td><td>ihdbjckkUjcjjfic</td><td>RF User A</td><td>2012-01-17</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>USA</td><td></td><td>0</td><td>0</td><td>2012-01-17</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-09-23</td><td>PST/PDT</td><td></td><td>54802</td><td>200809230000832599.0009000000</td><td></td><td>1</td><td></td><td>54727</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>UserB</td><td>US</td><td></td><td></td><td></td><td></td><td>ihdbjckkUjcjjfic</td><td>RF User B</td><td>2012-01-17</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>PST/PDT</td><td>1</td><td>PRIMARY</td><td>USA</td><td></td><td>0</td><td>0</td><td>2012-01-17</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2008-09-23</td><td>PST/PDT</td><td></td><td>55032</td><td>200809230000832608.0009000000</td><td></td><td>1</td><td></td><td>54818</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>akira</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAI/qOitYSIzVIggJwXcPwKB7ZJPHf4gKx5kNZJLI0rnQ8iSzaEZKvZURw=</td><td>akira</td><td>2021-06-18</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td>akira.nakafori@highbusiness.com.br</td><td>1</td><td>GMT-3</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>0</td><td>0</td><td>2025-03-21</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2021-06-18</td><td>60</td><td></td><td>47263</td><td>202106180046760206.6081928591</td><td></td><td>1</td><td></td><td>57282</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>UTESTE</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIdzX3n1rcM/EgQUoA68t8s8NwD17vHJwQilSEcbra873vM/Q2m0AyQOo=</td><td>Teste Usurio</td><td>2023-10-16</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>3</td><td>GMT-3</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>2</td><td>0</td><td>NULL</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2023-10-16</td><td></td><td></td><td>0</td><td>202310160046947486.6081928591</td><td>uteste</td><td>1</td><td></td><td>19728</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>TTESTE</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAI7IOlzATIlaMgcazDCE6AimQp1Sz3i4YUf5tDx2MMLXe1wm1/S0D14ag=</td><td>teste usurio</td><td>2024-07-04</td><td></td><td></td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>3</td><td>GMT</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>0</td><td>1</td><td>NULL</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2024-07-04</td><td></td><td></td><td>0</td><td>202407040046951011.6081928591</td><td></td><td>1</td><td></td><td>56727</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
<tr><td>userTI</td><td>po</td><td></td><td></td><td></td><td></td><td>B1NIQS0yNTYFMTAwMDAIE6N08Iilj8IgZ4xIjvhVWdfQ4ipYhxRB96krDQVp5s7XjRoPRxwJ0RE=</td><td>Usurio de TI</td><td>2024-07-05</td><td></td><td>500</td><td>0</td><td></td><td></td><td>0</td><td></td><td>NULL</td><td></td><td>NULL</td><td>NULL</td><td></td><td>NULL</td><td></td><td>1</td><td>CET/CEST</td><td>1</td><td>PRIMARY</td><td>BR</td><td></td><td>5</td><td>0</td><td>NULL</td><td>1</td><td>mfg</td><td>QAD_DEF</td><td>2024-07-05</td><td></td><td></td><td>0</td><td>202407050046953029.6081928591</td><td>userTI</td><td>1</td><td></td><td>56008</td><td></td><td></td><td>0</td><td>0</td><td></td></tr>
</table>
freeing result closing connection Resource id #1