On Tuesday 22 March 2005 14:37, SOTL wrote: > 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
Hi Frank. Whichever box has the mysql server software installed on it, Reality_check I would guess is C1. It is acting as your server even though it's not a dedicated server. The other box, big_nate would be C2. It should not have MySQL server software installed on it but should simply have the mysql client software installed on it. You can have two servers on the same network but they must run on different ports. Our task is to get one server one one client running so we can forget about multiport servers just now. Assuming this is the case then sitting at big_nate, you can type: mysql -h IP-address-of-reality_check -u your-user-name -p test type in your password and access the test database Can you do that? Leave all the other stuff for later. The main thing is to get MySQL installed properly first. Cheers, Steve. <info> I've cc'd this to the dba list as you mentioned earlier so you'll get a squillion copies of this. Either we'll be severely repremanded or we'll be welcomed with open arms! </info> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
