[libreoffice-users] Installing MySQL Connector

--- 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