Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DE4D4475AFF for ; Tue, 31 Dec 2002 10:47:11 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 528FD475843 for ; Tue, 31 Dec 2002 10:47:11 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 43DAA43AF41; Tue, 31 Dec 2002 10:47:11 -0500 (EST) From: Robert Hord X-Newsgroups: comp.databases.postgresql.interfaces Subject: OpenOffice connection Date: Tue, 31 Dec 2002 09:48:32 -0600 Organization: reh enterprise Lines: 51 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: usenet@news.hub.org User-Agent: KNode/0.7.1 To: pgsql-interfaces@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/11 X-Sequence-Number: 3511 I'm new to PostgreSQL, coming from MSSQL and trying to get an understanding of this. I have a database setup I can access via "psql rob". First; with the standard install from RedHat 8.0, I don't know if it was compiled with the odbc or jdbc support. Second; How do you connect through OO. OO crashes when I click on the Tables tab during setup. I tried the odbd and jdbc for connections. Here is my /etc; odbd.ini ------------------------------------------------ [db_rob] Description = Rob's database Driver = PostgreSQL Trace = No TraceFile = Database = rob Servername = localhost UserName = rhordjr Password = Port = 5432 Protocol = 6.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = odbdinst.ini ----------------------------------------- # Example driver definitinions # # # Included in the unixODBC package [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 -- reh - Texas,USA RedHat 8.0 http://flashpages.prodigy.net/rhordjr