Connecting Handbase desktop enterprise to MYSQL database.

Discuss the HanDBase for Windows Desktop program, conduits, and add-ons.

Connecting Handbase desktop enterprise to MYSQL database.

Postby jaymiles » Thu Jun 26, 2014 9:14 pm

Using the ODBC options I can connect Handbase database to Mircosoft Access and SQL Express. I can connect MS Access to MYSQL using ODBC. However, when I try to upload data from Handbase to MYSQL using ODBC is state transaction completed, but the data does not really update. I have install MYSQL 32 and 64 bit ODBC connector. I am assuming that Handbase is a 32 bit application. Do you have any advice, remedies or recommendation on how to get the applications to communicate with each other?

Secondly, Is there any plans to allow opening Hnadbase mobile in excel form when it select open in other applications.


Thank you,

John M.
jaymiles
 
Posts: 5
Joined: Tue Aug 14, 2012 7:07 pm

Re: Connecting Handbase desktop enterprise to MYSQL database

Postby Brian_Houghton » Sat Jun 28, 2014 4:27 pm

jaymiles wrote:Using the ODBC options I can connect Handbase database to Mircosoft Access and SQL Express. I can connect MS Access to MYSQL using ODBC. However, when I try to upload data from Handbase to MYSQL using ODBC is state transaction completed, but the data does not really update. I have install MYSQL 32 and 64 bit ODBC connector. I am assuming that Handbase is a 32 bit application. Do you have any advice, remedies or recommendation on how to get the applications to communicate with each other?

Secondly, Is there any plans to allow opening Hnadbase mobile in excel form when it select open in other applications.


Thank you,

John M.


Hi John,

Thanks for writing.

Since you are using both Access and MYSQL, I want to clarify for my understanding if you are wanting HanDBase to sync with Access, if you are wanting HanDBase to sync with MYSQL, or both.

Please let me know which you are wanting to do.

Also, I'd like to see copies of the sync exchange configurations you have set up within HanDBase. When you are configuring the sync exchange entry, select the File menu and choose the option to save the configuration to a file. The files will have an extension of .hde.

You should be able to zip these files and attach them to your reply.

Finally, in regards to the mobile version of HanDBase, which handheld platform are you using? I ask because both HanDBase for iPhone and HanDBase for Android already support importing of and exporting to CSV format, which is a great intermediary for Excel.

Sent from my Nexus 7 using Tapatalk HD
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am


Return to HanDBase for Windows

Who is online

Users browsing this forum: No registered users and 1 guest

cron