On Monday 21 March 2005 22:41, you wrote: > On Monday 21 March 2005 11:11, steve wrote: > > > If I understand the OO DB connection correct that > > > means that I need both ODBC and JDBC. > > > > No. You can only use one at a time. You only need one > > to connect, not both. > > But which one do I use in which computer? > Do you use ODBC for a DB in the computer you are working > on and JDBC for one in a server? Or do you use JDBC in > both situations? Or do you use ODBC in both situations. >
Let's say C1 is the box which is the MySQL server. C1 has neither ODBC nor JDBC installed on it. All C1 does is serve your databases from /var/lib/mysql. C1 does not have openoffice installed on it. C2 is another computer. C2 is networked to C1. C2 does not have MySQL installed on it. C2 has openoffice on it. C2 has the jre installed on it. C2 has the file .jar file I sent you, lets say in your /home directory. C2 is where the connecting is done via JDBC. I've used JDBC as an example as that's the one I use because you can set it up in under a minute. One other thing you may be doing wrong is to choose the JDBC data type when you are connecting. You should choose MySQL data type. I think the security issues can wait until you have got connected no? HTH Steve. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
