Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11760

Re: VO2ADO with MariaDB

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: VO2ADO with MariaDB
Date Sun, 15 Jul 2018 07:38:08 +0200
Lines 52
Message-ID <fr04u0Fd99fU1@mid.individual.net> (permalink)
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

Show key headers only | View raw


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



-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-13 08:45 -0700
  Re: VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-13 08:54 -0700
    Re: VO2ADO with MariaDB D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2018-07-14 09:13 +0200
      Re: VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-16 08:13 -0700
    Re: VO2ADO with MariaDB gianluca.pinoli@proximacentauri.it - 2018-07-16 03:19 -0700
      Re: VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-16 08:10 -0700
  Re: VO2ADO with MariaDB Sherlock <sherlock@sherlock.com.au> - 2018-07-14 07:19 -0700
  Re: VO2ADO with MariaDB "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-07-15 07:38 +0200
    Re: VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-16 08:06 -0700
  Re: VO2ADO with MariaDB Pilks <richardp@lukhozi.co.za> - 2018-07-19 08:54 -0700
    Re: VO2ADO with MariaDB epremuz@gmail.com - 2018-10-30 13:42 -0700
      Re: VO2ADO with MariaDB dlzc <dlzc1@cox.net> - 2018-10-30 13:52 -0700

csiph-web