Re: postgresql odbc driver for fc4? or how-to connect to OpenOffice's oobase?
- From: Randy Yates <yates@xxxxxxxx>
- Date: Fri, 29 Dec 2006 20:36:54 -0500
Randy Yates <yates@xxxxxxxx> writes:
Randy Yates <yates@xxxxxxxx> writes:
When I invoke oobase and select odbc -> browse, I get no data sources.
Of course I haven't set any up. I do have the postmaster running and
pgadmin3 runs and connects fine. How do i connect to a database using
openoffice?
For others' reference, I'll document what I did:
1. Install the unixODBC package. This is an ODBC driver manager.
2. Install the ODBC driver for your particular database. In the
case of postgresql, the driver is psqlODBC. Note that the driver
on the postreq site is the one to use, NOT pgfoundry.
PS: I also found out that when you connect to an ODBC datasource with
oobase and open a table, it is read-only unless the table has a unique
field or primary key.
--
% Randy Yates % "She tells me that she likes me very much,
%% Fuquay-Varina, NC % but when I try to touch, she makes it
%%% 919-577-9882 % all too clear."
%%%% <yates@xxxxxxxx> % 'Yours Truly, 2095', *Time*, ELO
http://home.earthlink.net/~yatescr
.
- References:
- Prev by Date: Re: Weird Problem: no contact to selected websites only on one linux machine in local subnet
- Next by Date: Converting Mono MP3 To Simulated Stereo on Linux
- Previous by thread: Re: postgresql odbc driver for fc4? or how-to connect to OpenOffice's oobase?
- Next by thread: DVD/CDROM writes not working!
- Index(es):
Relevant Pages
|
