Hello Guest it is December 12, 2024, 10:36:05 PM

Author Topic: Mach4 and luasql integration (mySql and ODBC)  (Read 5845 times)

0 Members and 1 Guest are viewing this topic.

Offline smurph

*
  • *
  •  1,550 1,550
  • "That there... that's an RV."
Re: Mach4 and luasql integration (mySql and ODBC)
« Reply #1 on: August 08, 2020, 08:28:10 AM »
Hello,
Thanks but this don't work in the current Mach4 as the LUA used is 5.3. This is fine for LUA 5.1 only.

Offline smurph

*
  • *
  •  1,550 1,550
  • "That there... that's an RV."
Re: Mach4 and luasql integration (mySql and ODBC)
« Reply #2 on: August 08, 2020, 12:49:49 PM »
??  What build are you running?  The current modules are for LUA 5.3

  lua53.dll
    Import Address Table:               0x00014154
    Import Name Table:                  0x0001A648
    Time Date Stamp:                    0x00000000
    Index of first forwarder reference: 0x00000000

Steve
Re: Mach4 and luasql integration (mySql and ODBC)
« Reply #3 on: August 08, 2020, 04:56:58 PM »
Hello and thanks for your reply. I am running Mach 4 at build level 4.2.0.4517
Just curious, where did you download luasql. I cannot find a version for 5.3.
Thanks!
Re: Mach4 and luasql integration (mySql and ODBC)
« Reply #4 on: August 08, 2020, 05:44:34 PM »
No worries, connect to mysql using mysql driver and returned an error on require: %1 not a win32 application.
Defined an ODBC 32 bits datasource, then changed driver in LUA code to luasql.odbc and voila, works just fine.
So the problem is that the libmysql.dll is 64 bits versus 32 bits. So will go ODBC instead.
Thanks!

Offline smurph

*
  • *
  •  1,550 1,550
  • "That there... that's an RV."
Re: Mach4 and luasql integration (mySql and ODBC)
« Reply #5 on: August 08, 2020, 06:45:53 PM »
Hello and thanks for your reply. I am running Mach 4 at build level 4.2.0.4517
Just curious, where did you download luasql. I cannot find a version for 5.3.
Thanks!

I got the luasql source and compiled the modules.  As with all of the modules in the modules directory.  They are custom made for the Mach LUA version and Mach 4 environment (module directory). 

Steve