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