The 'LCmySQL' MySQL plugin for use with A7 Lite-C 1.5 or higher has been released.

Thanks for working so hard on that one and keeping it up to date

WOW!...thanks man.great effort...this is very handy indeed.

i just couldnt get it work.

im using mysql 5.0.45 and a7.06 comm.
Created the a datbase and ran the sql command inluded.

as i can see from the acklog.txt it crashes when it calls a dll function.

it crased at mySQL_Connectdb function, I commented the line to see if mySQL_IsConnected function working, and it crased again.

One week before the new year i've switched to a host in Canada. So I need to upload everything again. This will take some time. I will try the dll today on another system, but i'm sure it's working fine like last time. Can you show me your script? Also make sure you are using LCmySQL.dll for Lite-C.

i am using te demo.c included in this file : http://a7-files.nixip.com/gsmysql/BETA/LCmySQL.zip

just edited the mySQL_Connectdb line to macth my server info.

Just tried LCmySQL and it is working fine. Do you want me to make a video tutorial how to setup a database on MySQL, insert a player and then have it displayed inside GameStudio engine window?

Some things that come to mind are:

#1 Your MySQL Database server doesn't allow remote connections
#2 You have entered wrong credentials for the connection*
#3 While running from SED/VC you have blocked the application by firewall

* On my remote host (a7-files.nixip.com) a username becomes nixipcom_username

Use this Code:

---

mySQL_Connectdb("nixipcom_gsa7db","67.159.44.57","nixipcom_pip","SGz9QeRi5");

---

inside demo.c for testing remote connections with the LCmySQL.dll and when the application is loaded hit "SPACEBAR" to activate login. Enter for both username and password: demo

This will be available until someone cripple the database. I could use Cron to create anew, but its on my previous host so I not really use their services anymore and this allows you to test the LCmySQL.dll engine extension.

well,
now im sure its not about server.

used mySQL_Connectdb("nixipcom_gsa7db","67.159.44.57","nixipcom_pip","SGz9QeRi5");

as line281 at demo.c it,crashed again. It cant load dll's properly or something?

there is no firewall or antivirus software working in background.

True I now tested on a clean XP Home SP2b system and come to notice that you will be needing to install vcredistx86 for 32bit Windows. If you don't like to install the vcredist, which is actually used by more applications than just this MySQL engine extension. I can compile a dll for you that doesn't require the vcredist at all when I get back to work next week.

If you are creating a real application/game with GameStudio and use this dll you can always distribute the vcredist with your software. If required you can also silently install it, while installing your game on the end-user system.

It will be more useful when vcredist is not need but as u said some other applications installs it too and most people wont reject installing a microsft redist. pack. so its not a problem

thank you D3D ill give it another try now.