Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: VO2ADO with MariaDB Date: Sun, 15 Jul 2018 07:38:08 +0200 Lines: 52 Message-ID: References: <18031e71-610c-4b76-a2b1-fff95e27e8f9@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-Trace: individual.net 524E0ip6jNgX3THdTGBFpQxLvR9iBaaCFLxFw2A22hEQaVXqk= Cancel-Lock: sha1:2h1IzRszg/IZgKYV82qGhP+TIL8= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:11760 Hi Richard, do you have the VO2Ado Pro version together with the sources? If yes, try to look at the source code. If not, buy the Pro upgrade and look at the code. And try to debug the library to see what is going on. Do you have the latest VO2Ado? Maybe this issue is already fixed. Wolfgang Pilks wrote: > Hi All > > Maintaining and old system that uses VO 2.7 and makes use of VO2ADO > to connect to a mysql database via ODBC. The server was upgraded to > MariaDB recently and all was fine until we upgraded a workstation to > Win 10. That person started experiencing problems with rounding of > decimal numbers to integers when saving to the database. I updated > the connector to a MariaDB connector and solved that problem. > > Now if I pull all fields from a table I get an error for the Win 10 > PC on the Execute method call: > > // Error message > Error Code: Data provider or other service returned an E_FAIL status. > Subsystem: Vo2Ado > Error SubCode: 16389 > > The code involved is in the init of a DataWindow: > // sSqlText = "SELECT * FROM projects where project_id='2634'" > SELF:oCmnd := AdoCommand{} > SELF:oCmnd:ActiveConnection := oDMSC // global variable > SELF:oCmnd:CommandText := sSqlText > uRet := SELF:oCmnd:Execute(NIL,NIL,NIL) // Error on this line > > I am busy with a translation to XSharp but that is quite a long way > off and this problem is immediate. > > Anyone with a clue? Maybe a description of the error subcode (16389)? > > TIA > > Richard --