Received: from smarthost-2.mail.telinco.net (smarthost-2.mail.telinco.net
	[212.1.128.91]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA82828
	for <pgsql-interfaces@postgresql.org>;
	Wed, 9 Feb 2000 14:42:20 -0500 (EST)
	(envelope-from paulg@themutual.net)
Received: from ppp-3-109.cvx6.telinco.net ([212.1.158.109] helo=mc4)
	by smarthost-2.mail.telinco.net with smtp (Exim 3.02 #4)
	id 12Id0A-000N0h-00
	for pgsql-interfaces@postgresql.org; Wed, 09 Feb 2000 19:42:14 +0000
Message-ID: <000801bf7334$31842260$6d9e01d4@mc4>
From: "Paul Green" <paulg@themutual.net>
To: <pgsql-interfaces@postgresql.org>
Subject: Linux+postgresql+ODBC+StarOffice
Date: Wed, 9 Feb 2000 19:30:19 -0000
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01BF7334.19BEEDE0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BF7334.19BEEDE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

My objective is to use StarOffice 5.1a (StarBase 5.1) as the front-end =
to postgresql 6.5.2-1 both of these are running on a Linux machine. To =
achieve this I assume I need to use ODBC.

The postgresql I am using came with Redhat 6.1 and included =
postgresql-odbc 6.5.2-1. The description of this package says that it =
includes sample configuration files but only 3 files are listed, since 2 =
of these are pointers to the third file there is effectively only one =
which is /usr/lib/libpsqlodbc.so.25 (i.e. the driver).

After reading the postgresql documentation I discovered that I needed a =
driver manager on the system the driver is to be used. I subsequently =
got hold of iodbc-2-12. After building iodbc iodbc-2.12.so was placed in =
my home directory.

After having read the documentation that came with postgresql and iodbc =
I unsuccessfully tried creating a configuration file (~.odbc.ini). I am =
unclear as to what this configuration file should look like.

I am also unclear as to how StarBase will pick this up when launching =
the new database wizard when selecting the ODBC option for the type of =
database.

Hopefully what I have done is not totally wrong and any help with both =
the .odbc configuration file and connection to StarBase would be =
appreciated. Is there an easy way to test the .odbc configuration file =
seperately.

Incidently my postgresql configuration works and I have a database that =
I can connect to using the standard postgresql tools.

Thanking any response in advance

Paul.


------=_NextPart_000_0005_01BF7334.19BEEDE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#c0c0c0>
<DIV><FONT size=3D2>
<P>My objective is to use StarOffice 5.1a (StarBase 5.1) as the =
front-end to=20
postgresql 6.5.2-1 both of these are running on a Linux machine. To =
achieve this=20
I assume I need to use ODBC.</P>
<P>The postgresql I am using came with Redhat 6.1 and included =
postgresql-odbc=20
6.5.2-1. The description of this package says that it includes sample=20
configuration files but only 3 files are listed, since 2 of these are =
pointers=20
to the third file there is effectively only one which is=20
/usr/lib/libpsqlodbc.so.25 (i.e. the driver).</P>
<P>After reading the postgresql documentation I discovered that I needed =
a=20
driver manager on the system the driver is to be used. I subsequently =
got hold=20
of iodbc-2-12. After building iodbc iodbc-2.12.so was placed in my home=20
directory.</P>
<P>After having read the documentation that came with postgresql and =
iodbc I=20
unsuccessfully tried creating a configuration file (~.odbc.ini). I am =
unclear as=20
to what this configuration file should look like.</P>
<P>I am also unclear as to how StarBase will pick this up when launching =
the new=20
database wizard when selecting the ODBC option for the type of =
database.</P>
<P>Hopefully what I have done is not totally wrong and any help with =
both the=20
.odbc configuration file and connection to StarBase would be =
appreciated. Is=20
there an easy way to test the .odbc configuration file seperately.</P>
<P>Incidently my postgresql configuration works and I have a database =
that I can=20
connect to using the standard postgresql tools.</P>
<P>Thanking any response in advance</P>
<P>Paul.</P></FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01BF7334.19BEEDE0--