Re: [libreoffice-users] Installing MySQL Connector

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.
Best regards
Pertti Rönnberg

On 8.2.2012 18:53, Tom Davies wrote:
> --- On Wed, 8/2/12, Tom Davies<tomdavies04@yahoo.co.uk>  wrote:
>
> From: Tom Davies<tomdavies04@yahoo.co.uk>
> Subject: Re: Installing MySQL Connector
> To: ...
> Date: Wednesday, 8 February, 2012, 16:51
>
> Hi :)
> 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. 
>
> Regards from
> Tom :)
>
>
> --- On Wed, 8/2/12, Tony Sumner<tony@whittycat.me.uk>  wrote:
>
> From: Tony Sumner<tony@whittycat.me.uk>
> Subject: Installing MySQL Connector
> To: elderdanlewis@gmail.com, tomdavies04@yahoo.co.uk, jslozier@gmail.com, alex.thurgood@gmail.com, 
> sos@pmgroup.be,
>   hc.stoellinger@aon.at
> 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.
>
> Thanks again
>
> Tony


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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