I am using a free download of MYSQL 5.0.18 which is supposed to
support Geometric data types. I'm able to create the geometry column
within the MySQL table as well as a spatial index for it however when
I attempt to populate the table using FME I keep getting an error on
the following:
Error executing SQL query ('CREATE TABLE `root.ATSQTRS` (`ATSQTRID`
int PRIMARY KEY,`MER` int,`QTR` char(2),`QTRID` int,`RGE` int,`SEC`
int,`TWP` int,`TWPID` int,`QTRSHAPE` GEOMETRY)
ENGINE=MYISAM'): 'Incorrect table name 'root.ATSQTRS''.
Successfully closed MYSQL database writer.
Writer failed in open() call.
Writer failed in open() call.
Is this due to a licensing problem? Do I require a specfic MySQL FME
extension to get this to work? All that I am doing is mapping the
contents of a shape file into FME and storing a polygon shape into
the geometry column of the MySQL table. Can someone point me in the
right direction for help on using this feature.
Thanks.
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
