On 6/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hallo, > > I have OpenOffice 1.1.4, Sun's Java 2 SDK Standard Edition 1.5.0.3, > mysql Connector/J 3.1.8, MySQL 4.0.23a, Linux 2.6.11. > Connector/J is in my CLASSPATH, class com.mysql.jdbc.Driver can be > found by javac. > With mysql I have full access to data base "jaybee" with one table > "adressen". > In Tools -> Data Sources I have defined a data base "jaybee" of type > MySQL, use Connetor/J3, driver class com.mysql.jdbc.Driver. > When I press <F4> in Writer, the data base shows up, but when I try > to access the tables, I get the message "Specified driver could not > be loaded". > What could be wrong? > > Groetjes, > > Hans. > > --- GoldED+/LNX 1.1.5/040412 > * Origin: The Wizard is using MBSE/Linux (2:280/1018) > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
Hans: I've used myodbc instead of jdbc to reasonable success. There is a pretty good myodbc install available from the mysql folks. After installing it, there is a file (... erm..... /etc/myodbc.conf?) and you can enter your data source there. Once that's done, if you select 'ODBC' as your driver type in Base, the dropdown box for selecting a datasource should contain your db of choice. Also, you need to add a user to your MySQL DB with necessary permissions from '127.0.0.1'. I haven't figured out why yet, but I've had problems with accessing from 'localhost'. Hope this helps, please feel free to write. -- Douglas Hernandez (612) 331-2547 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
