Mark,
I am going to try loading data using Geomedia Pro. If this gives us
problems that we can't figure out then we will contact Intergraph. If we
can load using Geomedia, but still not FME, then I will contact Safe
Support.
Thanks,
Chad Nielsen
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of mark2atsafe
Sent: Thursday, December 14, 2006 9:27 AM
To: [email protected]
Subject: [fme] Re: GeoMedia SQL Server Writer
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] <mailto:support%40safe.com> 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] <mailto:support%40safe.com>
http://www.safe.com <http://www.safe.com>
Solutions for Spatial Data Translation, Distribution and Access
--- In [email protected] <mailto:fme%40yahoogroups.com> ,
"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
>
