Have a look through http://www.safe.com/reader_writerPDF/mysql.pdf to see if there is anything in there relating to the settings that will help. There is a great troubleshooting section for connecting to MySQL.
In theory I think FME is only certified to work with the paid version of MySQL, not the free download. I'm 90% sure that this isn't the problem here, but thought I'd mention it anyway. Failing this can you write non-spatial data? Or does it produce the same message? Hope this helps. Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "wallace_tobin" <[EMAIL PROTECTED]> wrote: > > --- In [email protected], Hans van der Maarel <hans@> 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 / hans@ > > > 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/
