https://bugs.freedesktop.org/show_bug.cgi?id=46237

Alex Thurgood <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|WORKSFORME                  |---
           Priority|medium                      |high

--- Comment #15 from Alex Thurgood <[email protected]> ---
Hmm, after trying to open up other odbc-connected ODB files, I can actually
confirm and reproduce the buggy behaviour.

My previous tests focussed on a connection to the mysql system db itself, which
are displayed.

If however, I try and connect to any other ODBC datasource, i.e. a test db, or
my usual work db, then the tables are not listed.

This is confirmed by the fact that if I attempt to query the db from the query
editor, I get an error message that no database has been selected, which would
indicate that the db parameter from the odbc.ini entry is not being explicitly
passed to the server upon connection, or else is dropped in some way by LO.

If I go to Tools > SQL, then issue

use mydb

Executes successfully 

Then enter a select query for any table :

Select * from MyTable

and ask for the results to be displayed in the bottom window, the query
executes and the results are displayed.



Alex

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to