Hi Chad, >From our Readers and Writers Manual... ---------------------------------------------- The GeoMedia SQL Server Warehouse Writer writes to existing Microsoft SQL Server databases. If the database does not exist, the translation will be terminated. If the metadata tables and/or data tables do not exist in the database specified in the DATASET keyword, they will be created provided user has enough permissions to create and write to tables to the database. If the metadata tables exist, then information about newly created data table(s) will be appended to them.
The GeoMedia SQL Server Warehouse Writer does not require GeoMedia to be installed. However, for successful writing, users must have sufficient permissions for creating and deleting tables, and inserting and updating rows in existing tables. All metadata and feature tables will be created with "dbo" ownership, which ensures that any user with permissions has access to the tables. A table with "dbo" ownership means that it is owned by the database administrator. ---------------------------------------------- I hope this helps. It sounds like you'll need admin permissions to create tables (though not necessarily to write data to them). If you're still having problems then write to the support team, since we'll be able to talk to the developer and find out directly what permissions are going to be required. [EMAIL PROTECTED] is the address (I'm assuming you have a maintenance contract?) Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "nehalemus" <[EMAIL PROTECTED]> wrote: > > Hello, > > I'm getting an error when I try to write to a SQL Server GeoMedia > warehouse. This is the error: > > GeoMedia SQL Server Writer: Database error 'SQL call failed.' > in 'CreateDataTableView()'. > SQL Server returned following error message(s): > - [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE VIEW > permission denied, database 'HARP', owner 'dbo'. > GeoMedia SQL Writer: failed to create view for 'SEG' table. > > So, is this writer always going to try to create a view when it > writes? As it is now permissions will not allow that. If something > like this is necessary then what are the minimum permissions needed? > Can the necessary tables be created beforehand? I need to know what > to tell the database admins so they know what to fix. Any > suggestions? > > Thanks, > Chad Nielsen > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
