From owner-freebsd-database Mon Feb 5 5:40:17 2001 Delivered-To: freebsd-database@freebsd.org Received: from ipamzlx.physik.uni-mainz.de (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by hub.freebsd.org (Postfix) with ESMTP id B29D737B401 for ; Mon, 5 Feb 2001 05:39:57 -0800 (PST) Received: from ipamzlx.Physik.Uni-Mainz.DE (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by ipamzlx.physik.uni-mainz.de (8.11.2/8.11.2) with ESMTP id f15DepS83186 for ; Mon, 5 Feb 2001 14:40:52 +0100 (CET) (envelope-from ohartman@ipamzlx.physik.uni-mainz.de) Date: Mon, 5 Feb 2001 14:40:51 +0100 (CET) From: "O. Hartmann" To: freebsd-database@freebsd.org Subject: StarOffice 5.2 and ODBC (fwd) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Dear Sirs. Again, and again ... I have much trouble to connect StarOffice via ODBC to our MySQL server. With StarOffice and M$-Access 2000 on Windooze platforms and MyODB I do not have any kind of problems connecting the MySQL server. But from all FreeBSD based UNIX clients, on which we run StarOffice 5.2 as a better replacement for the crap on Windows machines, I have no access to our MySQL server. Data: MySQL 2.23.32 runs on FreeBSD 4.2; all clients running FBSD 4.2, StarOffice 5.2 (german) from ports collection. ODBC is MyODBC 2.50.36 compiled with unixODBC 2.0.3. I already set up /usr/local/etc/odbcinst.ini and odbc.ini the right way. I have a user, she's administering our student's library database. She has an account and within this account she has her own .odbc.ini file set up to the right database and table. When running StarOffice, we try to connect to the MySQL server via ODBC, we do exact the same procedure as we did on all Windooze machines with success. But it seems that on FreeBSD StarOffice can not find .odbc.ini. It reports an error and says we should check our configuration against libodbc.so. But this library is present and within search paths we provide. To avoid confudingly path-searches I linked the odbcinst.ini and odbc.ini into all Linux-compat /etc and /usr/local/etc search paths within the Linux compat tree - without any success. I tried to force linux to search the FreeBSD library paths to recognize where the libraries are ... no success. I think this could turn me into big problems because of the difference between Linux and FreeBSD libraries. As often as I asked in StarOffice mailing lists I got some curious answers about how to cross link libraries; so I try to ask again the FreeBSD community. I hope there is someone who's already set up StarOffice with ODBC access ... What is the trick? Do I need Linux libs for ODBC? Is there another way using a simple do use ODBC client to access a MySQL database, simple to use for a commom user, not a crack or hacker or admin ...??? Well, thanks in advance! Best wishes, Oliver -- MfG O. Hartmann ohartman@mail.physik.uni-mainz.de ---------------------------------------------------------------- IT-Administration des Institut fuer Physik der Atmosphaere (IPA) ---------------------------------------------------------------- Johannes Gutenberg Universitaet Mainz Becherweg 21 55099 Mainz Tel: +496131/3924662 (Maschinensaal) Tel: +496131/3924144 FAX: +496131/3923532 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Feb 7 3: 9:10 2001 Delivered-To: freebsd-database@freebsd.org Received: from ipamzlx.physik.uni-mainz.de (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by hub.freebsd.org (Postfix) with ESMTP id F11D337B401 for ; Wed, 7 Feb 2001 03:08:48 -0800 (PST) Received: from ipamzlx.Physik.Uni-Mainz.DE (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by ipamzlx.physik.uni-mainz.de (8.11.2/8.11.2) with ESMTP id f17B9VS09653 for ; Wed, 7 Feb 2001 12:09:31 +0100 (CET) (envelope-from ohartman@ipamzlx.physik.uni-mainz.de) Date: Wed, 7 Feb 2001 12:09:31 +0100 (CET) From: "O. Hartmann" To: freebsd-database@freebsd.org Subject: FreeBSD/MySQL/ODBC/StarOffice (fwd) Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG -- MfG O. Hartmann ohartman@mail.physik.uni-mainz.de ---------------------------------------------------------------- IT-Administration des Institut fuer Physik der Atmosphaere (IPA) ---------------------------------------------------------------- Johannes Gutenberg Universitaet Mainz Becherweg 21 55099 Mainz Tel: +496131/3924662 (Maschinensaal) Tel: +496131/3924144 FAX: +496131/3923532 ---------- Forwarded message ---------- Date: Wed, 7 Feb 2001 12:08:34 +0100 (CET) From: O. Hartmann To: freebsd-database@freebsd Subject: FreeBSD/MySQL/ODBC/StarOffice Dear Sirs. Again I must ask the community because of problems with some standards I can not solve. The system's facts: FreeBSD 4.2 based server machine, running the recent version of MySQL server. A bunch of FreeBSD clients using StarOffice 5.2 (german) and a bunch of Windooze PCs running Win2000 and StarOffice 5.2 and Office 2000. On the Windooze clients I use MyODBC 2.50.36 as ODBC driver with some problems under StarOffice (using varchar(255) truncates in StarOffice inputs to 8 characters ... but inputs made by hand (mysql-client) are shown in the correctly length). Access has no problems. We want to use more UNIX systems, so we install FreeBSD clients and use StarOffice (Linux emulation). We also have several Linux boxes using also StarOffice. On Linux and FreeBSD I compiled the sources for MyODBC 2.50.36 either with iODBC or unixODBC. Search path for the system wide configuration is in both cases /usr/local/etc. For each user using StarOffice in conjunction with the MySQL server we installed an additional .odbc.ini in their homes. So far, this was done on Linux AND FreeBSD. When trying to use an ODBC database out of StarOffice, I can not use ODBC under Linux or FreeBSD. It's always the same error. Under FreeBSD, I try to list all ODBC databases, but this implies that .odbc.ini, /usr/local/etc/odbcinst.ini and /usr/local/etc/odbc.ini has been properly read by StarOffice. StarOffice reports an error and tells me to check my installation/configuration against libodbc.ini. For that, I made some usefull and some senseless links to the existing libraries, to reflect the existence of libodbc.so. Without success. The first time, I try to connect I get this error, all succeeding errors are about to check file ".". The same problem is under Linux, so I think this is not a kind of "Linux vs. FreeBSD compiled libraries of MyODBC". It is a more sophisticated problem how StarOffice reads the proper information. Does anyone did the task successfuly? If you would do this job, what aspects are to be aware of? Any hints, tips? Thanks a lot ... Oliver -- MfG O. Hartmann ohartman@mail.physik.uni-mainz.de ---------------------------------------------------------------- IT-Administration des Institut fuer Physik der Atmosphaere (IPA) ---------------------------------------------------------------- Johannes Gutenberg Universitaet Mainz Becherweg 21 55099 Mainz Tel: +496131/3924662 (Maschinensaal) Tel: +496131/3924144 FAX: +496131/3923532 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Feb 10 5: 5:30 2001 Delivered-To: freebsd-database@freebsd.org Received: from ipamzlx.physik.uni-mainz.de (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by hub.freebsd.org (Postfix) with ESMTP id 8603537B401; Sat, 10 Feb 2001 05:05:08 -0800 (PST) Received: from ipamzlx.Physik.Uni-Mainz.DE (ipamzlx.Physik.Uni-Mainz.DE [134.93.180.54]) by ipamzlx.physik.uni-mainz.de (8.11.2/8.11.2) with ESMTP id f1AD62j32022; Sat, 10 Feb 2001 14:06:05 +0100 (CET) (envelope-from ohartman@ipamzlx.physik.uni-mainz.de) Date: Sat, 10 Feb 2001 14:06:01 +0100 (CET) From: "O. Hartmann" To: questions@freebsd.org Cc: database@freebsd.org Subject: ODBC and StarOffice Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Dear Sirs. Well, I regret bothering you again with this question, but it is very important to me to get an answer about a suitable solution. Background ---------- We use several tbales for our meteorological research on a MySQL server (MySQL 3.23.32). The server is a FreeBSD SMP machine running FreeBSD 4.2-STABLE. So far, the server operating system and the data= base are perfect. Our clients are a mixture from Windows 2000 and FreeBSD clients and a handful Linux boxes. All FreeBSD systems are running FreeBSD 4.2-STABLE. Mostly all Windows machines use StarOffice 5.2 to access the database server via MyODBC 2.50.36. Many use M$ Office and MyODBC. The FreeBSD boxes have the StarOffice 5.2 port installed, running under Linux emulation. MyODBC is compiled against unixODBC version 2.0.4. Problem ------- Main problem is: no one of the FreeBSD clients using StarOffice is able to gain access to the database server via ODBC. When trying to select ODBC in StarOffice's database facility it returns an error that says to check installation about libodbc.so. When trying again the same procedure immediately after the first try it reports the same error, but refers to a file ".". It seems to me that StarOffice can not find the suitable ODBC driver or its ini-file, but the user who uses StarOffice has already a proper set up .odbc.ini file. I was told to use a Linux MyODBC/unixODBC installation due the fact StarOffice is Linux code. But I do not find suitable rpm archives around here to try this. Does anyone out here run StarOffice successfully under FreeBSD with an ODBC driver installed to connect a SQL server? Thanks in advance, Oliver -- MfG O. Hartmann ohartman@mail.physik.uni-mainz.de ---------------------------------------------------------------- IT-Administration des Institut fuer Physik der Atmosphaere (IPA) ---------------------------------------------------------------- Johannes Gutenberg Universitaet Mainz Becherweg 21 55099 Mainz Tel: +496131/3924662 (Maschinensaal) Tel: +496131/3924144 FAX: +496131/3923532 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message