MySQL and MsSQL compatability...?

T

Tex8503

Active Member
Licensed User
Longtime User
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

agraham

Expert
Licensed User
Longtime User
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
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?
 
G

georgea

Member
Licensed User
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
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.
 
T

Tex8503

Active Member
Licensed User
Longtime User
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

assistai

Member
Licensed User
Longtime User
An example with Basic4ppc will be very important.

Obrigado (pt-br)
Thank (Eng)
 
T

Tex8503

Active Member
Licensed User
Longtime User
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 :)
 
You must log in or register to reply here.
Top