[Chargeable] MSMariaDB - Another connector to MySQL

[tango]

im licanced user of mariodb library. i need 1.06 version

 

[DonManfred]

im licanced user of mariodb library. i need 1.06 version

You can download the newest version always from the same link you got when you have registered.

 

[Roberto P.]

HI DonManfred,
before making the donation to try your nice library, those who ask:

- You can connect to Microsoft SQLServer database?
- The connection can be made even without Wifi?
- The grid that I see in some images included in your project?

Thank you and congratulations for your work

 

[jahswant]

Is it a question or some sort of joke ?

 

[Roberto P.]

are questions to understand exactly what makes the library and see if you can help me.

 

[jahswant]

Then these are answers to your question:
1.No it will exclusively connect to a MySQL OR Maria DB server No MS SQL Server
2.Yes you can use you mobile network to access you server.
For

- The grid that I see in some images included in your project?

Not sur to understand but :
3.These grids are the Flexi Table Class that can be used to display query results.

 

[DonManfred]

You can connect to Microsoft SQLServer database?

No. ONLY MySQL

The connection can be made even without Wifi?

If your MySQL Database IS accessible from outside, yes.

The grid that I see in some images included in your project?

It is not part of my Library. You need to ask @Peter Simpson which libraries he uses in his examples he wrote.
AFAIK it is using the Appcompatibrary and uses Klaus Tableclass (but i´m not sure)

You mean the image here, right?

 

[Roberto P.]

Hi DonManfred,
I did not understand your answer, do not do anything because I use Microsoft SqlServer / Express. I hope that you will do this version of your beautiful library.

 

[jahswant]

Hi Mr @DonManfred.I am doing a long task with the batch object.I want to put a progress Dialog Seems not to show wondering.When the task finishes before it shows Up.Wondering now on the significance of Async Not on Main Thread...

 

[DonManfred]

I hope that you will do this version of your beautiful library.

It will be an ADDITIONAL library. MSMySQL can ONLY Connect to a MySQL Database. MSMaria DB can work with MySQL and MariaDB.
I have a third library already written. For MSSQL. But actually it is not working.

BUT i´m now in Holiday and can probably find some time to get it running

 

[DonManfred]

.I want to put a progress Dialog Seems not to show wondering.When the task finishes before it shows Up

i did not understand well i think... Can you describe it more clearly what exactly you want to do, what your code is...?

 

[jahswant]

Have Achieved something with this...
https://www.b4x.com/android/forum/threads/sales-and-inventory-system-compagnon.58939/#post-371097

 

[DonManfred]

I STILL did not understand what exactly your question is!?

 

[jahswant]

I STILL did not understand what exactly your question is!?

It's no more a question bro.Sorry it's to tell you i achived something with this your lib...LOL

 

[Reyes5]

Hello DonManfred, I donated some hours ago, got your e-mail and have downloaded your SQL libs, thanks a lot !
What I hope to do with your libs : I have a tablet running a KSWEB, in there a MySQL server.
On the same tablet, in a B4A app, i want to use the tables in the db in the MySQL server
Could you guide me a little on how to get started ?
Thanks !

 

[DonManfred]

See the examples.

Note that you probably can use "localhost" as hostname. username, password and databasename you can use the credentials you setup in your mysql inside your KSWEB

If the ksweb is already up and properly configured running then you should get the libs to work in a minute...

 

[Reyes5]

Thanks 4 quick reply !
what lib should I use ? LibMySQLv106 OR MSMariaDB ?
To install the libs, put all 3 files in the additional lib dir in B4A ?
grtz, Reyes

 

[Reyes5]

Oops, gave it a try with LibMySQL and your example, but bit modoified (my db and table name, user, password etc)
bad news : An error has occured in sub:main_mysql_queryresult (java line 425) java.lang.NullPointerExeption
Logs are empty ...
You got any idea ?

 

[DonManfred]

You got any idea ?

Yes. Post your code. without it i cant help here as the error happens in mysql_queryresult

 

[DonManfred]

To install the libs, put all 3 files in the additional lib dir in B4A ?

Correct

LibMySQLv106 OR MSMariaDB ?

It depends. I personally like the Maria version. Both are good. Maria is a lot smaller (apk-size due to the big jar file of msmysql version; Especially the mysql-connector jar)