X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8BA5354083 for ; Tue, 3 May 2005 15:28:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75022-01 for ; Tue, 3 May 2005 18:28:55 +0000 (GMT) Received: from extavgw4.ball.com (extavgw4.ball.com [162.18.103.211]) by svr1.postgresql.org (Postfix) with ESMTP id D3F16540CE for ; Tue, 3 May 2005 15:28:54 -0300 (ADT) Received: from AEROMSG4.AERO.BALL.COM (Not Verified[162.18.82.149]) by extavgw4.ball.com with NetIQ MailMarshal (v6, 0, 3, 8) id ; Tue, 03 May 2005 12:29:25 -0600 Received: from daytonmsg2k3.AERO.BALL.COM ([162.18.199.42]) by AEROMSG4.AERO.BALL.COM with Microsoft SMTPSVC(6.0.3790.211); Tue, 3 May 2005 12:28:53 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5500D.F44EEAD5" Subject: ArcCatalog interface to PostgeSql question Date: Tue, 3 May 2005 14:28:51 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ArcCatalog interface to PostgeSql question Thread-Index: AcVQDfMSmZoNZwB9TW291YY9F9BSpQ== From: "Clay, Bruce" To: X-OriginalArrivalTime: 03 May 2005 18:28:53.0317 (UTC) FILETIME=[F57A7F50:01C5500D] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.049 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200505/1 X-Sequence-Number: 5504 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5500D.F44EEAD5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have seen mention of a way to interface ArcCatalog or ArcMap with PostgreSql but I can not find any details. =20 I am using PostgreSql 8.1 and have tried to set up ArcCatalog by way of "Add OLE DB Connection" and "Add Spatial Database Connection" but can not get things to work =20 When I try "OLE DB Connection" I see PostgreSql OLE DB as a provider in the list of options but I can't find anything that says what to use for "Data Source" nor "Location" parameters. I tried "localhost" as the location but got a "Test connection failed because of an error in initializing provider. Unspecified error" message. =20 When I try "Add Spatial Database Connection" I get an error message (Failed to connect to specified server) from ArcCatalog and the postgreSql logs show the following: =20 2005-05-03 14:12:43 LOG: database system was shut down at 2005-05-03 14:12:06 Eastern Standard Time 2005-05-03 14:12:43 LOG: checkpoint record is at 0/14282C0 2005-05-03 14:12:43 LOG: redo record is at 0/14282C0; undo record is at 0/0; shutdown TRUE 2005-05-03 14:12:43 LOG: next transaction ID: 4226; next OID: 22625 2005-05-03 14:12:43 LOG: database system is ready 2005-05-03 14:12:58 FATAL: unsupported frontend protocol 65535.65535: server supports 1.0 to 3.0 2005-05-03 14:13:14 LOG: received fast shutdown request 2005-05-03 14:13:14 LOG: shutting down 2005-05-03 14:13:14 LOG: database system is shut down 2005-05-03 14:13:14 LOG: logger shutting down =20 I believe the unsupported frontend protocol message is coming from the ArcCatalog test connection attempt. =20 If this is not the correct forum for this question please direct me to the correct one. Since this an interface issue I thought I would ask here first. I have used Google to search for set up guides but could not find any. =20 My current task is to get ArcGis tools to display data from a PostgreSql database (first vector then image". =20 Any suggestions would be greatly appreciated. =20 Bruce ------_=_NextPart_001_01C5500D.F44EEAD5 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have seen mention of a way to interface ArcCatalog = or ArcMap with PostgreSql but I can not find any details.

I am using PostgreSql 8.1 and have tried to set up = ArcCatalog by way of “Add OLE DB Connection” and “Add Spatial = Database Connection” but can not get things to work

When I try “OLE DB Connection” I see = PostgreSql OLE DB as a provider in the list of options but I can’t find anything = that says what to use for “Data Source” nor = “Location” parameters. I tried “localhost” as the location but = got a “Test connection failed because of an error in initializing provider. = Unspecified error” message.

When I try “Add Spatial Database = Connection” I get an error message (Failed to connect to specified server) from ArcCatalog = and the postgreSql logs show the following:

2005-05-03 = 14:12:43 LOG: database system was shut down at 2005-05-03 = 14:12:06 Eastern Standard Time

2005-05-03 = 14:12:43 LOG: checkpoint record is at 0/14282C0

2005-05-03 = 14:12:43 LOG: redo record is at 0/14282C0; undo record is at 0/0; shutdown = TRUE

2005-05-03 = 14:12:43 LOG: next transaction ID: 4226; next OID: 22625

2005-05-03 = 14:12:43 LOG: database system is ready

2005-05-03 = 14:12:58 FATAL: unsupported frontend protocol 65535.65535: server supports = 1.0 to 3.0

2005-05-03 = 14:13:14 LOG: received fast shutdown request

2005-05-03 = 14:13:14 LOG: shutting down

2005-05-03 = 14:13:14 LOG: database system is shut down

2005-05-03 = 14:13:14 LOG: logger shutting down

I believe the unsupported frontend protocol message = is coming from the ArcCatalog test connection attempt.

If this is not the correct forum for this question = please direct me to the correct one. Since this an interface issue I = thought I would ask here first.

I have used Google to search for set up guides but = could not find any.

My current task is to get ArcGis tools to display = data from a PostgreSql database (first vector then image”.

Any suggestions would be greatly = appreciated.

Bruce

------_=_NextPart_001_01C5500D.F44EEAD5--