I have been testing LibreOffice Base 3.5 and MySQL on a Windows 7 64bit computer. I have found that the OpenOffice connector does work for me with LibreOffice but the discussion that it does not work for everyone and is likely to fail at some time in the future encouraged me to have another look at using the ODBC connector.
I also found that I received a 'can't find driver' error but this is caused by 64bit/32bit issues. As I understand it, LibreOffice requires a 32bit ODBC driver and needs to be configured with the 32bit ODBC administrator. The default ODBC administrator on my computer is the 64bit. Anyway all these issues and the solutions are described in http://ltlbgr.files.wordpress.com/2012/05/mysql_odbc.odt at my blog site. cheers Mike On Wed, May 9, 2012 at 6:09 PM, Tony Sumner <[email protected]> wrote: > A while back Tom asked people to tell their stories so this is mine. > > I started with a project to create an application using a DBMS to > manage our local currency. This would be used by relatively basic > users who would almost certainly want to use Windows. I already had a > working knowledge of MySQL and I knew how to use that to do all the > admin tasks but I needed a GUI to do data entry and report writing. So > I started by trying to connect LO to MySQL with the ODBC connector. > After a lot of reading I installed the MyODBC connector, created a > driver and a DSN amd LO said "Can't find driver" or something like > that. I thought I'd try it in Linux to get the hang of it before > settling down to work in Windows and this gave me "Can't find library" > or something like that. Then I found that LO will connect to MySQL > directly without the need for a connector so I tried that and it > worked. But this facility is not available in Windows. OOo does have > the facility to connect directly to MySQL in Windows so at last I can > get on with the project. OOo does what I want and OOo Base is pretty > much like LO Base so I'm afraid it is goodbye LO. > > Been good to know you > > Tony > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
