MySQL and MsSQL compatability...?

T

Tex8503

Active Member

Licensed User

Longtime User

• May 6, 2011

• #1

Hey guys,

So I saw Agraham posted a library here that does MsSQL - http://www.b4x.com/forum/additional-libraries/6184-mssql-sql-server-library.html#post36303

Does this work on the device side and for windows?

Also - I haven't seen anything for MySQL for the device (just this tutorial : http://www.b4x.com/forum/tutorials/5859-using-mysql-basic4ppc.html for working with the desktop apps) Does anyone know if / how MySQL might work for a device?

Just was curious as one of our guys asked me and I haven't played around with that part too much.

Thanks!

 

agraham

Expert

Licensed User

Longtime User

• May 6, 2011

• #2

I'm not very familiar with databses but I think it works on both as it operates through the .NET System.Data.SQLClient class. If I remember correctly the client is standard on the desktop Framework but needs adding to the device.

EDIT :- It's Mssql I'm referring to.

 

T

Tex8503

Active Member

Licensed User

Longtime User

• May 8, 2011

• #3

Meaning that your library won't let the device connect to a MsSQL database, but a PC app could? Or is there just a DLL that needs to be added to the device?

 

agraham

Expert

Licensed User

Longtime User

• May 8, 2011

• #4

Like I said, I don't know much about databases. What I do know is all in the MSSQL library thread whose link you posted, and in the link to the original library in the first post, which is all referring to using MSSQL on devices.

 

G

georgea

Member

Licensed User

• May 13, 2011

• #5

Agraham's MSSQL Library works great on both desktop and device side. It's fully tested and being used with MSSQL 2000 MSDE and MSSQL Express 2005.

It just want the correct connection string (with port number) depending on which version of sql server you want to connect.

 

T

Tex8503

Active Member

Licensed User

Longtime User

• May 13, 2011

• #6

georgea - Thanks for the input. Good to know that's a route we can take our clients.

Now It'd be nice to know if there's a solution for contacting a MySQL DB from a device.

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• May 14, 2011

• #7

You will need to use a web service for that. You can do something similar to this example: http://www.b4x.com/forum/basic4andr...-connect-android-mysql-database-tutorial.html

 

T

Tex8503

Active Member

Licensed User

Longtime User

• Aug 26, 2011

• #8

If anyone is interested - There is a compact framework dll to write to MySQL (MySQL :: Download Connector/Net) its mysql.data.cf.dll in that package.

I don't know if anyone has the time to write it (agraham? ) but I think it probably boost the usability of B4P...

 

assistai

Member

Licensed User

Longtime User

• Aug 28, 2011

• #9

An example with Basic4ppc will be very important.

Obrigado (pt-br)
Thank (Eng)

 

T

Tex8503

Active Member

Licensed User

Longtime User

• Aug 30, 2011

• #10

Are you looking for an example of the MSSQL functionality or the MySQL functionality?

I've got an MSSQL example written - I'd be happy to share.

The MySQL functionality would require someone to write a wrapper for the MySQL compact framework DLL that exists... I'd love to see someone who actually has talent write the wrapper rather than for me to stumble through writing it