Re: [libreoffice-users] Connecting LO Base to an SQL DB

Hi :)
Congrats on fixing that issue Ian!  Is there any chance of adding it somewhere in the Faq?
http://wiki.documentfoundation.org/Faq#Base
Regards from 
Tom :)  





> ________________________________
> From: Ian Whitfield <whitfield@telkomsa.net>
> To: users@global.libreoffice.org 
> Sent: Thursday, 1 November 2012, 12:42
> Subject: Re: [libreoffice-users] Connecting LO Base to an SQL DB
>
> Thanks Heinz
>
> Well I even went off this morning looking at 'other' solutions for this and it seems to be - Use 
> Base or go and learn PHP or Ruby or something like that!!
>
> So I got into Base again and found an interesting fact - Base had _NOT_ stored the link in it's 
> Driver Class!! After a couple of re-tries it now seems to have done that and I can now get past 
> the 'Test Class' stage OK!!!
>
> The next screen is 'Authentication' - I enter the User Name and select "Test Connection" and I get
>
>    Communication Link Failure
>    The last packet sent successfully to the Server was 0 milliseconds ago.
>    The driver has not received any packets from the Server.
>
> OK - Now I'm stuck again...... My Database (Schema) was called 'federals_Members.sql' when I first 
> created it but last week I had to re-install my OpSys and to get it back into MyAdmin I had to 
> import it and it's now there called 'Test'!! Neither of the above two file names make any 
> difference to the error message.
>
> Next the User Name - In My Admin it is 'root', when I set-up the Database I used 'Ianw' and my 
> System login is 'Ianw' also. Again neither of these changes the error message.
>
> To check I started MyAdmin and it connects fine with the Database and displays the table structure 
> just fine.
>
> So why wont Base connect to it???
>
> Thanks
>
> IanW
>
>
> -- 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
-- 
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