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

[Brent Robinson]

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