[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Installing MySQL Connector
- Subject: Re: [libreoffice-users] Installing MySQL Connector
- From: Pertti Rönnberg <firstname.lastname@example.org>
- Date: Wed, 08 Feb 2012 21:02:55 +0200
- To: email@example.com
Dear all you LibreO-guys,
It is fantastic that both cunny people and 'dummies' like me can ask for and get help from a community like yours. But.
On another thread, 'spreadsheet or database', one opinion seemed to be that ordinary no-expert 'newies' are afraid of using dbs because they feel it difficult, it requires planning and designing, queries are too complicated, etc. There was a saying about contributions to "lower the barriers" too.
In another thread Andreas said that Base is not a database despite of the embedded HSQLDB - Base is 'only' an front-end tool that requires a "real" database that it shall be connected to.
And now this very long thread explains that such a connection (ODBC) does not work - nothing is said about how or when it will work.
Conclusion: there is no alternative other than to use LO-Base with HSQLDB embedded with all its possible goodies and weaknesses included.
For me this is very frustrating - probably others too. First I had problems to get LO-Base working (JRE) and now when I intend to obey Andreas and connect my LO-Base to either MySQL or SQLite (I need to connect to old MSAccess files too) it will obviously be waist of time and energy. If there is no solution for the problem I must skip LO-Base.
I'm aware of that you seem prefer to lean to Linux ideology (I was very satisfied with Ubuntu for many years myself), but if LO(-Base) is offered to the Windows environment it is of no good to have such an elementary problem unsolved.
I'm sure that you already decided to - or at least planned to - put an effort on solving that ODBC connection problem (and JDBC?) in one way or another, e.g. deciding to have a sufficient and strong enough db-engine embedded or not.
Even if I install the AMPPS package I would like to enjoy LO-Base's flexibility as a report engine - which also seems to be impossible.
On 8.2.2012 18:53, Tom Davies wrote:
--- On Wed, 8/2/12, Tom Davies<firstname.lastname@example.org> wrote:
From: Tom Davies<email@example.com>
Subject: Re: Installing MySQL Connector
Date: Wednesday, 8 February, 2012, 16:51
1. Don't worry about people being weird on-list. Not everyone has good people skills as they might have more skill in other crucial areas. Lets get this back on the list as a new thread.
2. Dan, Alex, Andreas and Jay have more skill and knowledge about Base than most of us. Heinrich and i are stumbling our way through with Heinrich gaining hands-on experience in Windows.
--- On Wed, 8/2/12, Tony Sumner<firstname.lastname@example.org> wrote:
From: Tony Sumner<email@example.com>
Subject: Installing MySQL Connector
To: firstname.lastname@example.org, email@example.com, firstname.lastname@example.org, email@example.com, firstname.lastname@example.org,
Date: Wednesday, 8 February, 2012, 16:22
Thanks for your help. I have made some progress but first of all my
apologies for (inadvertently) hijacking someone else's thread. I have
no idea how that happened and it has not happened before on any of the
many mailing lists I have used. To make sure it does not happen again
I am not using the list for this.
It's interesting, Heinrich, to learn that the native connector works
only in Vista; I am on Windows XP. I don't understand why an extension
should be required when LO says that the 'ODBC connector is
built-in'. Dan suggests I obtain it and Tom says there isn't one so I
can only report on what happens with the built-in one.
I downloaded the Windows connector from MySQL.com and executed the MSI file
mysql-connector-odbc-5.1.10-win32.msi which gave me a file myodbc-installer.exe* and a README.txt which said
run the .exe file in a command window. I tried
RUN thinking that was the same thing which is why I got a window for 1ms.
This time I went to Command Prompt and ran it there and got a help file
which explained what to do. I did what it said and everything went well,
apparently, ie I registered a driver and created a database source name.
Then to LO where I selected 'connect to an existing database', quoted the
DSN and clicked on 'test connection'. The result was "[MySQL][ODBC Driver]
can't connect to MySQL server@localhost".
So all I have done is confirm that it doesn't work.
Maybe I'll try JDBC -- but it did say that ODBC is built in.
For unsubscribe instructions e-mail to: email@example.com
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
|[libreoffice-users] Re: Installing MySQL Connector||Alexander Thurgood <firstname.lastname@example.org>|
|Re: [libreoffice-users] Installing MySQL Connector||Tony Sumner <email@example.com>|
|[libreoffice-users] Installing MySQL Connector||Tom Davies <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-users] Re: Installing MySQL Connect
- Next by Date: Re: [libreoffice-users] Default path for templates
- Previous by thread: [libreoffice-users] Installing MySQL Connector
- Next by thread: Re: [libreoffice-users] Installing MySQL Connector