[mapguide-users] RE: RE: Informix database support

[Ismael Cams]

Hello Dave,

the used driver for the Informix database is: IBM Informix 3.82 32 Bit (I
have attached the DSN configuration in attachment).
The key column for the table was defaulted, so I did not have to select one.
On the other hand I had to select the Geometry column in the Studio when I
created the layer. This was not by default completed.
When I try to create a thematic and use the get button for retrieving the
distinct values I get following error:

An exception occurred in FDO component.
RDBMS: [Informix][Informix ODBC driver][Informix]A syntax error has
occurred.

I have tried it also with the latest MapGuide version (1.2 Beta) but
unfortunately the same problem occurs. 

Is there anything else I can try or maybe a possible workaround to overcome
this problem. As all the x-y coordinates are stored in the informix database
it is really blocking me.

Kind regards,
Ismaël





Dave Wilson-3 wrote:
> 
> Did you specify a coordinate system that corresponds with your X/Y or
> geometry columns? I'm guessing you have. Was the key column for the
> table you are trying to use defaulted or did you have to select it? I'm
> not familiar with Informix so I don't know if there are any special
> parameters you might need to include in the connection string.
> 
> I don't' have an Informix database to test against so sending the driver
> will be of limited value other than to see the interface via the ODBC
> Admin.
> 
> Regards,
> Dave
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Ismael Cams
> Sent: Friday, May 18, 2007 1:02 AM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] RE: Informix database support
> 
> 
> I have only tried a DSN based connection. With this connection I can see
> the
> database tables in the studio but the geometries are not shown in the
> map.
> Also when I try to perform a get for e.g. a filter it returns a FDO
> error.
> Currently I am not in the office but I can send the driver used and the
> exact error message afterwards. 
> Thanks in advance for the support.
> 
> 
> Dave Wilson-3 wrote:
>> 
>> I assume you have a driver for this? Did you try both a DSN and a
>> Connection string based connection?
>> 
>> Regards,
>> Dave
>> 
>> -----Original Message-----
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Ismael
> Cams
>> Sent: Thursday, May 17, 2007 6:46 AM
>> To: mapguide-users at lists.osgeo.org
>> Subject: [mapguide-users] Informix database support
>> 
>> 
>> Hello all,
>> 
>> it seems to be it is not possible to connect to an Informix database
>> with
>> the ODBC provider. Is it planned to have the informix database
> supported
>> in
>> the future ?
>> 
>> 
>> -- 
>> View this message in context:
>>
> http://www.nabble.com/Informix-database-support-tf3771742s16610.html#a10
>> 663521
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Informix-database-support-tf3771742s16610.html#a10
> 677424
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 
http://www.nabble.com/file/p10732528/ODBC_Conf.jpg 
-- 
View this message in context: http://www.nabble.com/Informix-database-support-tf3771742s16610.html#a10732528
Sent from the MapGuide Users mailing list archive at Nabble.com.