[fdo-users] postgis fdo problems

Wed Feb 13 13:36:18 EST 2008

Yes i have primary key on my table an all object are lower case. Actually i'am able to open my database on MGOS 1.2 (with fdo 3.2) without selection problems. I will post post this question to MapGuide first just to make sure this is fdo problem or mg problem

Thx,

Ary Sucaya

----- Original Message ----
From: Jason Birch <Jason.Birch at nanaimo.ca>
To: FDO Users Mail List <fdo-users at lists.osgeo.org>
Sent: Wednesday, February 13, 2008 7:26:58 PM
Subject: RE: [fdo-users] postgis fdo problems

There are some limitations on the PostGIS provider at this point, though I am not sure that they affect you as I can’t see your data.  Specifically:

-          Ensure that you have a primary key defined for the table you are attempting to select from
-          Ensure that all of your objects (database, schema, table, columns) are lower case, and with no special characters other than underscore

The best way to ensure that this problem is addressed by a developer at some point (if you are unable to fix it yourself) would be to create a ticket in our Trac system:

http://trac.osgeo.org/fdo/wiki/SubmitTicket

A good ticket is one which is quickly and easily reproducible by the developer.  Please ensure that you include:

-          A complete description of your problem, including versions of the software (MapGuide, FDO, PostgreSQL, PostGIS) that you are using
-          A reduced-set package of the data that you are experiencing the problem with (database backup and, in this case, MGP of your data source, layer, map
-          A script of steps that the developer can follow to reproduce the problem you are seeing

Thanks!
Jason

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of ary sucaya
Sent: Wednesday, February 13, 2008 10:17
To: FDO Users Mail List
Subject: Re: [fdo-users] postgis fdo problems

Thanks, now i can connect to postgis. But i found another problem, i couldn't make any selection to postgis object on the map. I'm not sure weather it is fdo or mapguide issues. Since i can select sdf object, i consider it as fdo postgis problems

Thanks,

Ary Sucaya
----- Original Message ----
From: Greg Boone <greg.boone at autodesk.com>
To: FDO Users Mail List <fdo-users at lists.osgeo.org>
Sent: Wednesday, February 13, 2008 6:24:32 PM
Subject: RE: [fdo-users] postgis fdo problems
The DLL has been posted.

http://download.osgeo.org/fdo/3.3.0-RC2/fdosdk-3.3.0_win32_supplimental_RC2.tar.gz

Greg

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Greg Boone
Sent: Wednesday, February 13, 2008 11:59 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] postgis fdo problems

I will post a patch to download.osgeo.org and notify the group when it is complete.

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of ary sucaya
Sent: Wednesday, February 13, 2008 4:21 AM
To: FDO Users Mail List
Subject: Re: [fdo-users] postgis fdo problems

I did install Visual C++ 2005 SP1 redistributed package but still have that problem. However, when i tried to check dependency, at least i found two error on dependency:
BOOST_DATE_TIME-VC80-MT-1_34_1.DLL
DWMAPI.DLL
Have idea how to solve this problem?

Thx

Ary Sucaya
----- Original Message ----
From: Jason Birch <Jason.Birch at nanaimo.ca>
To: FDO Users Mail List <fdo-users at lists.osgeo.org>
Sent: Tuesday, February 12, 2008 10:45:16 PM
Subject: RE: [fdo-users] postgis fdo problems
If the connection settings aren’t coming up, then the provider is likely missing some of its prerequisites.  Have you run depends.exe (http://www.dependencywalker.com/) against the provider DLL to see what comes up?   I believe that FDO 3.3 requires the Visual C++ 2005 SP1 redistributable package:

http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

As well, there may be some dependencies for the specific version of PostgreSQL that the provider was build with, but I’m not sure on that one.

Note, I haven’t tried this myself yet and I don’t believe that there are many unit tests for this provider, so there may actually be problems with the 3.3 build.

Jason

From: ary sucaya
Subject: [fdo-users] postgis fdo problems

I was tried to use fdo postgis 3.3 with Mapguide 2.0 RC2 but i didn't get lucky. My Mapguide Studio didn't bring up connection parameter to postgis database. I'm sure that i didn't make any mistake on my setting because i was succesfully use an unofficial postgis fdo (version 3.2 alpha) with mapguide 1.2

-----Inline Attachment Follows-----

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

Never miss a thing. Make Yahoo your homepage. 

-----Inline Attachment Follows-----

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

Never miss a thing. Make Yahoo your homepage. 

-----Inline Attachment Follows-----

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

      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20080213/48017c10/attachment-0001.html