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/
