GPF - DataSet/Open - TMySQLDatasource

[Hurricane]

I'm developing an application that connects to different types of databases.
After connecting to MySQL, GPF when opening the table, other methods work (execute, etc).

Código: Seleccionar todo

METHOD BtnConnClick( oSender ) CLASS TForm1
   with object ::oDsMySQL
      :cPassword:='root'
      :cUser    :='root'
      :cHost    :='localhost'
      :cDatabase:='hurricane'
      :Disconnect()

      if :Connect()
         with object :Table('country')
            if :open() // GPF
               LogDebug('opened!')

               :close()
            endif
         end with

      endif
   end with
   RETURN Nil

message from Xailer 4.02

#1: XAILER-MySQL type not supported: 63
#2: XAILER-MySQL type not supported: 32769
#3: XAILER-MySQL type not supported: 18
#4: XAILER-MySQL type not supported: 1024
#5: XAILER-MySQL type not supported: 63
#6: XAILER-MySQL type not supported: 32769
#7: XAILER-MySQL type not supported: 18
#8: XAILER-MySQL type not supported: 1024
#9: GPF (Code = c0000005):
Access violation

TMYSQLRECORDS:DBSTRUCT (0)
TMYSQLRECORDS:QUERYALL (262)
TMYSQLRECORDS:OPEN (193)
TSQLTABLE:OPEN (320)
TFORM1:BUTTON3CLICK (57)
TBUTTON:ONCLICK (0)
TBUTTON:CLICK (101)
(b)XCONTROL (152)
TBUTTON:COMMAND (0)
TSCROLLINGWINCONTROL:WMCOMMAND (275)
TFORM1:WMCOMMAND (948)
RUNFORM (0)
TAPPLICATION:RUN (287)
MAIN (15)

general:

• The code above works normally if I use the MariaDB component to connect to MySQL.
  Error also happens in Xailer Demo 5.0.3 and 5.1.1 (other lines).
  I tested with MySQL versions: 5.7.21 (2018) and 5.1.72 (2013)

[jfgimenez]

Hi,
you're probably mixing DLLs. Try to copy the MariaDB DLLs from \xailer\bin to your application directory

[Hurricane]

Good Morning.

No! I did several tests totally isolated, no possibility of mixing.
I tested it with LibMariaDB.dll (Xailer), after MariaDB itself, after MySQL, etc.
The TMySQLDatasource component works partially, then generates GPF.
This component is connecting in MYSQL and MariaDB without any DLL.

I am normally using the MariaDB component (and libMariaDB.dll) to connect to MySQL and MariaDB.

[jfgimenez]

I'm using both MySQL and MariaDB for years, and I've never got such kind of GPF.
Please, send us a very small and self-contained sample, including a small database, to test it.