--- In [email protected], Hans van der Maarel <[EMAIL PROTECTED]> wrote:
>
> wallace_tobin wrote:
> > 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.
>
> I never had any trouble using the MySQL reader/writer. If it shows
up in
> your formats list, you have the correct FME version for it.
>
> Check the properties of the MySQL output feature, there should be
an
> option there that says "Table Exists". Based on what you're
writing, it
> sounds as if you have already created the table and then FME tries
to do
> that as well.
>
> Hope this helps...
> --
> Hans van der Maarel
> Red Geographics
> www.redgeographics.com / [EMAIL PROTECTED]
>
Yes Hans. I have already created the table I don't see and option
within FME to select "Table Exists". In fact it was something I had
expected to be able to choose. The root user has ull priveleges on
the database. The interesting thing here is that it is trying to
create the table root.ATSQTRS when in fact the database name
is 'UGS_Database_be'. I supplied 'root' as the database user. Maybe
I'm not supllying the information correctly?
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/
