dibesw Active Member Licensed User Longtime User Aug 22, 2014 #1 Hi Erel, I use RDC (with ucanaccess) wery well for about 1 year. My only problem is this: if I run e.g. an insert into table and I run subsequently a query, I found this record; but if I run an insert from access or another application, if I run the same query from RDC, I do not found this record. If I close and open RDC (close and reopen RunRCL.bat) I found it! The same happens if I do update. I tried to run ucanaccess console. From this all works well. What could be the reason? Could be due to anywheresoftware.b4a.remotedatabase.RemoteServer. What is this anywheresoftware.b4a.remotedatabase.RemoteServer? Can you help me? Thanks
Hi Erel, I use RDC (with ucanaccess) wery well for about 1 year. My only problem is this: if I run e.g. an insert into table and I run subsequently a query, I found this record; but if I run an insert from access or another application, if I run the same query from RDC, I do not found this record. If I close and open RDC (close and reopen RunRCL.bat) I found it! The same happens if I do update. I tried to run ucanaccess console. From this all works well. What could be the reason? Could be due to anywheresoftware.b4a.remotedatabase.RemoteServer. What is this anywheresoftware.b4a.remotedatabase.RemoteServer? Can you help me? Thanks
A Antonio1 Member Licensed User Longtime User Aug 23, 2014 #2 hello dibesw I also work with the DRC. With mysql and sqlite works well. With ucanaccess I have the same problem ... It 's not possible to access the db with the DRC and at the same time with msaccess ... ucanaccess not' a jdbc driver ... the tests that I did ucanaccess works well only with connections to the DRC ... google translation ... I'm Italian Upvote 0
hello dibesw I also work with the DRC. With mysql and sqlite works well. With ucanaccess I have the same problem ... It 's not possible to access the db with the DRC and at the same time with msaccess ... ucanaccess not' a jdbc driver ... the tests that I did ucanaccess works well only with connections to the DRC ... google translation ... I'm Italian
Erel B4X founder Staff member Licensed User Longtime User Aug 24, 2014 #3 As I wrote in other threads I highly recommend you to avoid using Access database as the back end database. It is not suitable for this. If the database is accessed from different processes then you should use a database such as MySQL that supports it. Upvote 0
As I wrote in other threads I highly recommend you to avoid using Access database as the back end database. It is not suitable for this. If the database is accessed from different processes then you should use a database such as MySQL that supports it.
A Antonio1 Member Licensed User Longtime User Aug 24, 2014 #4 Erel thanks for the clarification Upvote 0
dibesw Active Member Licensed User Longtime User Sep 3, 2014 #5 I reported this specific issue to the UCanAccess author and I want just to mention that it seems to be fixed with the 2.0.9. Nevertheless he strongly suggests to avoid concurrent and simultaneous transactions from different processes (and so from different dbms') which could involve the risk of the corruption of the accdb/mdb file. In other words, this patch is useful just for a limited and "manual" usage. Upvote 0
I reported this specific issue to the UCanAccess author and I want just to mention that it seems to be fixed with the 2.0.9. Nevertheless he strongly suggests to avoid concurrent and simultaneous transactions from different processes (and so from different dbms') which could involve the risk of the corruption of the accdb/mdb file. In other words, this patch is useful just for a limited and "manual" usage.
Myr0n Active Member Licensed User Longtime User Jan 13, 2015 #6 Hi guys Somebody know if is possible to work with ucanaccess and b4a? If yes, could someone share a code example to work with ucanaccess, please, I would like to work with queries and Jackess can't? Thank you so much Upvote 0
Hi guys Somebody know if is possible to work with ucanaccess and b4a? If yes, could someone share a code example to work with ucanaccess, please, I would like to work with queries and Jackess can't? Thank you so much
Erel B4X founder Staff member Licensed User Longtime User Jan 14, 2015 #7 Yes. You can see the driver class and jdbc url in this B4J example: https://www.b4x.com/android/forum/threads/b4j-and-database-access.37531/#post-221923 Upvote 0
Yes. You can see the driver class and jdbc url in this B4J example: https://www.b4x.com/android/forum/threads/b4j-and-database-access.37531/#post-221923
