[fdo-users] Map3D 2011: PostgreSQL/Postgis provider connection problems

[Brent Robinson]

Do connection with the other tools work ok with host:port or just with db at host:port?

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Andreas Neumann
Sent: Monday, April 26, 2010 12:16 PM
To: FDO Users Mail List
Subject: RE: [fdo-users] Map3D 2011: PostgreSQL/Postgis provider connection problems

Hi Bren,

Thank you for answering.

I tried only with host:port in the "Service Name", but now I get the error
message that "The specified credentials are not valid or the provider is
unable to establish a connection."

I double checked the credentials and I am sure they are right. Also the
connection seems to work initially when I use db at host:port

Do you have any other suggestions? Are there any DLLs I need to check for
versions?

I am testing on a virtual PC where there is only oracle and Topobase2011
(with Map3D 2011). So there isn't much other software that should
interfere.

I should also note that I am on WinXP Pro with the current service pack.

Thanks,
Andreas


On Mon, April 26, 2010 5:17 pm, Brent Robinson wrote:
> Hi Andreas,
>
> Try host:port for the connection string. Internally, the provider will
> handle adding the datastore that you select to the connection string. The
> 3.5 provider has a bug in that it will add the db part even if it is there
> already so the connection string passed to PostgreSQL was likely
>
> db at db@host:port
>
> This has been fixed in the trunk.
>
> Brent.
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org
> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Andreas Neumann
> Sent: Monday, April 26, 2010 11:10 AM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] Map3D 2011: PostgreSQL/Postgis provider connection
> problems
>
> Hi,
>
> I am trying to get the PostgreSQL/Postgis FDO 3.5 provider runninng in
> Map3D 2011. I can first connect and get the listing of databases. However,
> when I want to continue by pressing the "Connect" button I get a "Failed
> to connect" error message. The detailed error message does not contain
> more details - it just says: "Failed to open FDO connection. RDBMS: Not
> connected to the specified database"
>
> My connection string is: db at host:port
>
> The fact that I get the listing of "Data stores" (the PostgreSQL
> databases) tells me that the connection string should be correct and that
> there is a different problem.
>
> Any idea what could be wrong? My PostgreSQL is 8.4.2 and Postgis is 1.4.1,
> running on Ubuntu server. Connections with other tools work fine.
>
> Andreas
>
>
> --
> Andreas Neumann
> http://www.carto.net/neumann/
> http://www.svgopen.org/
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>


-- 
Andreas Neumann
http://www.carto.net/neumann/
http://www.svgopen.org/

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users