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!
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.
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?
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.
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.
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.
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
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...
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
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