In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

GPF - DataSet/Open - TMySQLDatasource

Xailer English public forum
User avatar
Hurricane
Posts: 85
Joined: Tue Mar 24, 2015 10:21 am
Location: Brasil
Contact:

GPF - DataSet/Open - TMySQLDatasource

Postby Hurricane » Tue Apr 17, 2018 1:21 am

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).

Code: Select all

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)
{Delphi, Lazarus, PHP}, ADVPL, SQL, FastReport
Xailer, Fivewin, Hwgui, Minigui, Harbour, Clipper, Corebuilder
Contact: Freelance, Developments, Xailer Training | Facebook Xailer | Downloads
User avatar
jfgimenez
Site Admin
Posts: 5568
Joined: Mon Apr 06, 2015 8:48 pm
Contact:

Re: GPF - DataSet/Open - TMySQLDatasource

Postby jfgimenez » Sun Apr 22, 2018 4:16 pm

Hi,
you're probably mixing DLLs. Try to copy the MariaDB DLLs from \xailer\bin to your application directory
José F. Giménez
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info
User avatar
Hurricane
Posts: 85
Joined: Tue Mar 24, 2015 10:21 am
Location: Brasil
Contact:

Re: GPF - DataSet/Open - TMySQLDatasource

Postby Hurricane » Mon Apr 23, 2018 4:37 am

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.
User avatar
jfgimenez
Site Admin
Posts: 5568
Joined: Mon Apr 06, 2015 8:48 pm
Contact:

Re: GPF - DataSet/Open - TMySQLDatasource

Postby jfgimenez » Thu May 03, 2018 10:16 am

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.
José F. Giménez
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info

Return to “English”