Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #12094
| Newsgroups | comp.lang.clipper.visual-objects |
|---|---|
| Date | 2018-10-30 13:42 -0700 |
| References | <18031e71-610c-4b76-a2b1-fff95e27e8f9@googlegroups.com> <0b3daf16-eeef-44e1-b034-44754994e3a8@googlegroups.com> |
| Message-ID | <295c8a02-b2e2-405e-99ef-b7f7fad77c4d@googlegroups.com> (permalink) |
| Subject | Re: VO2ADO with MariaDB |
| From | epremuz@gmail.com |
Richard, you are an ADO angel if such a thing even exists. Thank you.
In case someone googled this error and ended up here let me tell you that going the cheap way and disallowing nulls in your table won't help you, or at least it didn't help me. Also, this doesn't seem to be an issue with VO2ADO but more of a general ADO <--> MariaDB issue (or maybe even related to the ODBC driver, who knows).
For the record, this could be a regression between versions 2.0.15 and 2.0.18 of MariaDB ODBC's driver. Can't really test it as of now but might be useful information in case you need to troubleshoot this issue.
On Thursday, July 19, 2018 at 12:54:03 PM UTC-3, Pilks wrote:
> Hi All
>
> Just reporting back that I was able to find a workaround to the problem.
>
> It turned out the date and datetime fields that allowed nulls gave problems. I had to change all occurrences where I selected all fields (select * from tablename where ...) from tables that had dates where they could be null. I also had to use DATE_FORMAT(dateField,'%Y-%m-%d') or similar to extract the date values in the select statement.
>
> These two adjustments seemed to solve the problem for me.
>
> Thanks for suggestions and assistance.
>
> Richard
>
> On Friday, 13 July 2018 17:45:28 UTC+2, 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
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