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

Tue Apr 27 09:48:12 EDT 2010

Hi Andreas,

There are actually two different providers that access PostgreSQL/Postgis:  OSGeo.PostGIS and OSGeo.PostgreSQL.

The OSGeo.PostGIS provider connects to a database in a PostgreSQL instance and then exposes each schema as an FDO datastore. It sounds like the FDO Toolbox is using this provider.

Map3D uses the OSGeo.PostgreSQL provider which does the mapping a bit differently. It exposes each database as an FDO datastore, and each schema within the database as an FDO Feature Schema. It's possible that there is some difference between Topobase2001 beta and Map3D 2011 that affects the connection, but it's more likely an issue at the provider level. When you tried pgadmin3, was it with db at host:port or host:port? psql can also be used to try the same type of connection as the provider:

    psql -h <host> -p <port> -U <username>

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: Tuesday, April 27, 2010 4:25 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] Map3D 2011: PostgreSQL/Postgis provider connection problems

Hi all,

On recommendation of Karl Herrmann from Dornbirn I also installed the
FDO-Toolbox.

Now I can connect with the toolbox but still not with Topobase.

The toolbox takes db at hostname:port as a connection string. After
connection it lists the Postgis schemas of the database.

When I connect with Topobase/Map3D I get a listing of the databases, not
the schemas, which seems strange, since I already provided the database
with the connection string.

So my personal feeling is that the Topobase 2011 beta somehow contains
older software/libraries than the official Autodesk Map3D 2011 release. It
may well be that Map3D can connect, but Topobase can't.

I also tried to replace all the dlls of the FDO and system32 directories
with potentially newer versions from pgadmin3. No luck with Topobase
either. FDO Toolbox still works fine.

Any other idea? Did someone successfully connect to Postgis from
Topobase2011?

Thanks,
Andreas

On Mon, April 26, 2010 9:14 pm, Brent Robinson wrote:
> Hi Andreas,
>
> Checking with a non-Autodesk tool would be fine. Since the initial
> connect, with Map, works with db at host:port but not with host:port, I was
> curious as to whether the other tools also fail to connect with host:port.
> If they do, you might also get a more informative error message.
>
> The provider version would be 3.5 for both Topobase2011 beta and Map3D
> 2011. They might have different build numbers but I'm not sure if there is
> a way to find out. If anyone else knows, feel free to jump in.
>
> 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 2:09 PM
> To: FDO Users Mail List
> Subject: Re: [fdo-users] Map3D 2011: PostgreSQL/Postgis provider
> connection problems
>
> Hi Brent,
>
> With "other tools" I did not mean other Autodesk tools, but pgadmin3,
> one of the graphical Postgres database clients. Pgadmin3 has different
> input widgets for each of the parameters.
>
> Maybe the Topobase2011 beta version has an earlier FDO PostgreSQL driver
> than the official Map3D 2011 release? Can I check the versions somehow?
>
> Thanks,
> Andreas
>
> On 4/26/10 6:44 PM, Brent Robinson wrote:
>> 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
>>>
>>>
>>
>>
>
> _______________________________________________
> 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