[fdo-users] ArcSDE 9.2

Tue Oct 21 11:50:35 EDT 2008

George,
 I would suggest trying to first load "a" feature class into the sde
geodatabase. 
There are many tables and relationships that are created upon load. Those
relationships are so intricate that you are better off allowing sde to
create them. There is a utility in map to create an mssql store and users
but it creates an autodesk schema and is not an sde datastore type. You can
use the sde command line tools to do that.
http://support.esri.com/index.cfm?fa=knowledgebase.documentation.viewDoc&PID
=66&MetaID=1211
I did a search on the esri support website for arcsde administration" and
got the download link. There are two pdf files that should help.
it will require an esri support login which I think you can set up without a
support identifier.
Using the shp2sde command allows the creation of all the sde user tables
that would definitely be required for the provider to work. My limited
knowledge is that your sde has to be operating smoothly for FDO to have any
luck with it. The issue with map 2008 is that it is supported on 9.2 with
fdo 3.2.3 any map version earlier will require an earlier fdo version.
After loading some data you would need to assign privileges per user. 
I have not done what you are trying to accomplish. But have had success
working with existing sde features. I just know that sde manages table locks
and user locks (depending upon your versioning schema) and doesn't really
create those user tables until the data exists.
 Brad

Map2009 help file...
You can connect via ArcSDE to an underlying Oracle or SQL Server database.
You can insert, select, update, and delete feature data in existing ArcSDE
schemas. You cannot create or modify an ArcSDE schema in AutoCAD Map 3D.

AutoCAD Map 3D supports ArcSDE 9.1 and 9.2. To work with ArcSDE, you must
install ArcSDE 9.1 and a supported data source, such as Oracle 9i, in the
network. 

Install the following DLL files on the computer on which you run AutoCAD Map
3D:

For version 9.1 For version 9.2 
pe91.dll                 pe.dll 
sde91.dll                 sde.dll 
sg91.dll                    sg.dll 

For instructions on installing the DLL files and setting up your hosts and
services files for ArcSDE, see Bringing In Features from ArcSDE.

The PATH environment variable must reference the local folder containing
these. To accomplish this, you can install an ArcGIS 9.1 Desktop application
or the ArcSDE SDK. For more information about ArcGIS 9.1 Desktop
applications and the ArcSDE SDK, refer to the ESRI documentation.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of gmclean at gorge.net
Sent: Monday, October 20, 2008 5:17 PM
To: fdo-users at lists.osgeo.org
Subject: RE: [fdo-users] ArcSDE 9.2

The only table I have from the list is
dbo.SDE_state_lineages. There is one record:

lineage_name = 0
lineage_id = 0

Thanks,

George

------- Original Message -------
>From    : Jack Lee[mailto:jack.lee at autodesk.com]
Sent    : 10/20/2008 2:29:50 PM
To      : fdo-users at lists.osgeo.org
Cc      : 
Subject : RE: [fdo-users] ArcSDE 9.2

 Hi,

Does your datastore contains any of the following tables?

sde.state_lineages
sde.sde_state_lineages
sde.sde.state_lineages
sde.sde.sde_state_lineages

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [
mailto:fdo-users-bounces at lists.osgeo.org]  On Behalf
Of Romica Dascalescu
Sent: Monday, October 20, 2008 4:41 PM
To: FDO Users Mail List
Subject: RE: [fdo-users] ArcSDE 9.2

Hi George,

There is a patch for Map2008 and ArcSDE provider
using 92 server.
The fix is not under Windows SDK its under "Patches"
- Ticket #294 
http://fdo.osgeo.org/content/fdo-323-downloads 

(
http://download.osgeo.org/fdo/3.2.3/patches/ticket294/fdoarcsde-3.2.3_win32_
release_G071.tar.gz
)

Romy.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [
mailto:fdo-users-bounces at lists.osgeo.org]  On Behalf
Of George McLean
Sent: Monday, October 20, 2008 3:49 PM
To: FDO Users Mail List
Subject: [fdo-users] ArcSDE 9.2

I am working through my first attempt to use the
ArcSDE provider.

I am connecting through Autocad Map 2008 to an ArcSDE
system running SQL
Server. In the data provider, I am able to log in and
see one data
store. I get an error message when I attempt to get
the version list.
The error states

-37 DMBS table not found

then

State info list could not be retrieved

I am not sure how to determine what table is missing.
Any suggestions?

This data store was set up by the GIS Administrator
for my client and
currently has no GIS data loaded. I am hoping I can
move data and table
defmitions from a MySQL data store to the ArcSDE
datastore through
Autocad's Bulc Copy. Will this work?

Thanks

George McLean
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/fdo-users 
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/fdo-users 
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/fdo-users 

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users