On Tuesday 22 March 2005 02:22, steve wrote: > 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?
True if one is thinking of security as security but security may inversely be thought of as a way to limit access in which case it could be an issue with one not being able to connect so as you are correctly implying one should set all security to off when one is attempting basic set up and then turn security on only after basic setup is verified to be functional. I only have one issue with my lack of understanding of the above. Which box is C1 and which box is C2? In large installations there is always a computer that is a dedicated server. I do not have a dedicated server. In fact in the classical definition of server I do not have a server. What I do have is two desktop computers connected in a two computer network such that either desktop computer may have the database located in it. Significant one of these computers, Reality_Check, is a desktop and the other, Big_Nate, is a laptop. Eventual plan is to replace Reality_Check with a server but before that I will need to connect two other desktop boxes to Reality_Check. The execution of that part of the plan is in the far distant future at one year or more away. It will take at least that much time to develop a usable DB that from the data input side so I am not currently concerned about that. This data input is also why I can not ascertain which computer is C1 and which is C2. In the office it is easier to use Reality_Check as a desktop for data entry and as a test box for my network set up but that raises an issue that I need to go to the office to do data entry something I can do with my laptop at home. If I approach data entry from that approach then eather computer could be the one that has the DB in it that I am using at any one point in time. If the above approach is not easy to set up and it does require some sort of special configuration that is above the level of a newbie, recall we are on the newbie list, please so inform me and please inform me of which method you would recommend. Thanks Frank --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
