On Friday 18 March 2005 00:10, Andrew Douglas Pitonyak wrote: > SOTL wrote: > >On Thursday 17 March 2005 06:14, CPHennessy wrote: > >>On Wednesday 16 March 2005 01:19, Ennio-Sr wrote: > >>>Hi all. > >>>Do understand well that the 1.1.4 capacity to connect to an existing > >>>database (via the New > Spreadsheet > Tools > Data Sources ,etc ...) is > >>>no longer available in coming OOo-2.0 ? > >> > >>The exact steps may not be the same but I'm almost sure that the > >>functionality is still available ( and should be easier to use). > > > >I am not so sure about that. > > > >Yes it is suppose to work go to: File -> New -> Database -> Connect to an > >existing Database > > > >and you should be able to connect. > > > >I have been able to connect to a dBase test database I have but I have NOT > >been able to connect to a test MySQL database I have with no idea of why > > not so I subscribed to user database list. Unfortunately either that list > > is dead or something as in 3 days I have received exactly 1 posting > > saying I was subscribed. > > > >Previously I had posted questions concerning that very issue on this list > >without receiving comments which is a good indicator that database issue > > are not on the top of people's list of issues at the present time. > > > >Frank > > Are you using ODBC or JDBC? I did some limited testing today and I was > able to connect to a MySQL database using the latest production JDBC > driver. I added a brief descriptions, complete with pictures an arrows > to my web site. Let me know after you have it so that I can remove it > from my web site. >
> http://www.pitonyak.org/MySQLTest.sxw > > At which step do things fail for you? Quick answer understanding. OK what I have is 2 computers networked with a router where I am trying to learn to set a database and other items up. One computer is an MSI box called Reality_Check @192.168.1.2 data in this computer is located at /System_Data which is a separate partition. I have learned to place data in a separate non standard partition so that if and when I crash a system the data will be safe and given my level of knowledge crashing is a certainty. The other computer is a IBM Thinkpad called Big_Nate @192.168.1.4 data in this computer is located at /home/trunk/Common_Data with the DBs being at /home/trunk/Common_Data/DataBase. [The IBM box is also dual boot with MS XP named Allie_Oop @ 192.168.1.3 hence the weird location of data which is accessable from both the MS and Linux sides.] Both Big_Nate and Reality_Check are Mandrake 10.1 boxes. I have created a database by using MySQL and 3 tables in this small test database by using OO Spreadsheat. I have placed that DB in both computer by means of fish. So I have identical information in both places. First BD file location: I have attempted to create a config file my.cnf but it keeps failing. The contents of my my.cnf file follows: [mysql] datadir=<data dir> I believe that from other email that this file should be as follows: [mysql] datadir=<data dir> pid_file= basedir=/ bindir=/usr/bin Unfortunately I do not have a clue as to what or where pid_file is so I am stuck with having my DB files located at /var/lib/mysql. Accessing DB The eventual plan is to locate the DB in Reality_Check and access it with 3 computers. How the DB is to operate is still in question meaning I do not know the exact structure of if one or all users will be able to modify the DB. The answers to those questions are months away. The current issue is access period. As Reality_Check is not only acting as a server for the DB but as a desktop the DB needs to be accessed both locally and by LAN. If I understand the OO DB connection correct that means that I need both ODBC and JDBC. For ODBC The first hing one must do is enter the name of the ODBC data source on your system. I haven't clue what this means. I am assuming that this is the directory location of the DB is located but when I click on Browse the window is blank so that leads to the question of what is this really suppose to be? For JDBC There are several issues here with the first being who has right to access the DB. My simple DB in MySQL were created as root not as a user in as much when I attempt to create a DB as user I am informed that access is denied. I know how to grant access to a user but what I do not know is which user. For me being simple minded and Linux / Unix being a tree file structure with master access to root I have name users as trunk, branch, twig, leaf et. The user for Big_Nate is trunk. The user for Reality_Check is branch. Now for Reality_Check I create a DB as root and then grant access to who? Trunk? Branch? A completely New Name et. Most confusing. Next there are a variety of URL and access issues of how one access the DB. So with my DB in Reality_Check located at /System_Data I first have the issue of accessing /System_Data from Big_Nate and then I have the issue of permission to access a DB that is accessable by which user using which password. This issue of access also applies to ODBC too. Thanks for your previous help. Frank --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
