Re: staroffice 6.0 beta and JDBC/ ODBC: howto?

["Christian Andersson" <ca@xxxxxx>]

your jdbc-string is in error
an jdbc-url should look like something like this

jdbc:mysql://name/database
where name is the name of the computer (or ip-adress) and database is the
name of the database
(jdbc: is already filled in)

The above url should be used with the mm.mysql jdbc drivers
you should also specify in the datasource setting the JDBC driver class, the
username and if you use passowrord to connecto to the database..

the Driver for mm-.mysql is I believe org.gjt.mm.mysql.Driver

The the last part is where to put the mm-mysql .jar file
in the (starofficedir)/user/config directory you shouldfind a java.ini file
you have a line called
SystemClasspath.. on this line add the location to your jar file (including
the filename) to that line

Well, that is the theory anyway..
Sofar All I have gotten is that it cannot load the driver for me :-(

I'll investigate some more first before giving up :-)

/Christian Andersson
----- Original Message -----
From: "Jean-Luc Fontaine" <jfontain@xxxxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Tuesday, October 09, 2001 1:00 PM
Subject: staroffice 6.0 beta and JDBC/ ODBC: howto?


> I am trying to connect to an external data source in writer using ODBC
> or JDBC and it fails.
>
> I enter:
>
> jdbc:1.2.3.4:3306/test
>
> in the data source URL and many other combinations with mysql:, //, ...
> and I always get a "cannot connect..." message.
>
> Watching 1.2.3.4 traffic with tcpdump tells me that there is no attempt
> made from staroffice. The documentation being scarce, has anobody
> achieved that?
>
> Any help will be greatly appreciated, as it seems that the combination
> of Linux, LTSP and StarOffice will really allow us to do without MS
> "software" here...
>
> --
> Jean-Luc Fontaine
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread87421@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail <mysql-unsubscribe-ca=ofs.no@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread87426@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php