From owner-freebsd-questions Sun Feb 4 21:54:13 2001 Delivered-To: freebsd-questions@freebsd.org Received: from guru.mired.org (okc-65-26-235-186.mmcable.com [65.26.235.186]) by hub.freebsd.org (Postfix) with SMTP id 25AD937B503 for ; Sun, 4 Feb 2001 21:53:54 -0800 (PST) Received: (qmail 35082 invoked by uid 100); 5 Feb 2001 05:53:52 -0000 From: Mike Meyer MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14974.16368.871787.634721@guru.mired.org> Date: Sun, 4 Feb 2001 23:53:52 -0600 (CST) To: "O. Hartmann" Cc: questions@freebsd.org Subject: Re: StarOffice 5.2 and ODBC In-Reply-To: <94444946@toto.iv> X-Mailer: VM 6.75 under 21.1 (patch 10) "Capitol Reef" XEmacs Lucid X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`;h9L,Yg`+vb1>RG% *h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\ Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG O. Hartmann types: > Dear Sirs. > Again, and again ... My troubles with ODBC were solved with help from freebsd-database@freebsd.org. You might try there instead of -questions. 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-questions" in the body of the message > -- Mike Meyer http://www.mired.org/home/mwm/ Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message