I'm having a problem accessing an SDE database. I know I am connecting because I can enumerat the list of databases. However, when I connect to the appropriate db, I cannot enumerate the list of tables. When I used the same login parameters in ArcView 3.x or ArcGIS 9, I am able to attach to the db. I believe the version of SDE is 9.0.
Am I leaving out a step?
I'm using FME Suite 2005 (20050607 - Build 1696).
Below is the output of the table enumeration dialog (PW has been obswcured, but was correct)
INFORM | Making connection to server 'marinmappdc' for dataset 'sde' using instance 'port:5151' userId = 'bvoigt'.
INFORM | Connection made to server 'marinmappdc' for dataset 'sde' using instance 'port:5151' userId = 'bvoigt'.
INFORM | ArcSDE Reader: Connecting to version 'SDE.DEFAULT'.
WARN | UniversalReader -- readSchema resulted in 0 schema features being returned
WARN | Reader Parameter(0) = >sde<
WARN | Reader Parameter(1) = >_IN_SDE3Server<
WARN | Reader Parameter(2) = >marinmappdc<
WARN | Reader Parameter(3) = >_IN_SDE3UserName<
WARN | Reader Parameter(4) = >bvoigt<
WARN | Reader Parameter(5) = >_IN_SDE3Password<
WARN | Reader Parameter(6) = >**********<
WARN | Reader Parameter(7) = >_IN_SDE3Instance<
WARN | Reader Parameter(8) = >port:5151<
WARN | Reader Parameter(9) = >_IN_SDE3Version<
WARN | Reader Parameter(10) = >SDE.DEFAULT<
WARN | Reader Parameter(11) = >_IN_SDE3WhereClause<
WARN | Reader Parameter(12) = ><
WARN | Reader Parameter(13) = >_IN_SDE3LayerList<
WARN | Reader Parameter(14) = ><
WARN | Reader Parameter(15) = >_IN_SDE3MINX<
WARN | Reader Parameter(16) = ><
WARN | Reader Parameter(17) = >_IN_SDE3MINY<
WARN | Reader Parameter(18) = ><
WARN | Reader Parameter(19) = >_IN_SDE3MAXX<
WARN | Reader Parameter(20) = ><
WARN | Reader Parameter(21) = >_IN_SDE3MAXY<
WARN | Reader Parameter(22) = ><
WARN | Reader Parameter(23) = >_IN_SDE3CLIP<
WARN | Reader Parameter(24) = >no<
WARN | Reader Parameter(25) = >_IN_SDE3RemoveTableQualifier<
WARN | Reader Parameter(26) = >NO<
WARN | Reader Parameter(27) = >RETRIEVE_ALL_SCHEMAS<
WARN | Reader Parameter(28) = >YES<
WARN | Reader Parameter(29) = >_REMOVE_TABLE_QUALIFIER<
WARN | Reader Parameter(30) = >NO<
WARN | Reader Directive(0) = >RUNTIME_MACROS<
WARN | Reader Directive(1) = >_IN_SDE3Server,marinmappdc,_IN_SDE3UserName,bvoigt,_IN_SDE3Password,sanrafGIS,_IN_SDE3Instance,port:5151,_IN_SDE3Version,SDE.DEFAULT,_IN_SDE3WhereClause,,_IN_SDE3LayerList,,_IN_SDE3MINX,,_IN_SDE3MINY,,_IN_SDE3MAXX,,_IN_SDE3MAXY,,_IN_SDE3CLIP,no,_IN_SDE3RemoveTableQualifier,NO<
WARN | Configuration object contents:
INFORM | FME Temporary Directory: C:\DOCUME~1\billv\LOCALS~1\Temp
INFORM | mapping file Line 0: APPLICATION FME_WORKBENCH
INFORM | mapping file Line 1: AUTOREG YES
INFORM | mapping file Line 2: LOG_MAX_FEATURES -1
INFORM | mapping file Line 3: LOG_APPEND NO
INFORM | mapping file Line 4: FME_HOME C:\Program Files\FME Suite\
INFORM | mapping file Line 5: FME_SESSION_USED TRUE
INFORM | mapping file Line 6: READER_TYPE sde30
INFORM | mapping file Line 7: R_8_METAFILE sde30
INFORM | mapping file Line 8: R_8_DATASET sde
INFORM | mapping file Line 9: R_8__IN_SDE3Server marinmappdc
INFORM | mapping file Line 10: R_8__IN_SDE3UserName bvoigt
INFORM | mapping file Line 11: R_8__IN_SDE3Password sanrafGIS
INFORM | mapping file Line 12: R_8__IN_SDE3Instance port:5151
INFORM | mapping file Line 13: R_8__IN_SDE3Version SDE.DEFAULT
INFORM | mapping file Line 14: R_8__IN_SDE3WhereClause
INFORM | mapping file Line 15: R_8__IN_SDE3LayerList
INFORM | mapping file Line 16: R_8__IN_SDE3MINX
INFORM | mapping file Line 17: R_8__IN_SDE3MINY
INFORM | mapping file Line 18: R_8__IN_SDE3MAXX
INFORM | mapping file Line 19: R_8__IN_SDE3MAXY
INFORM | mapping file Line 20: R_8__IN_SDE3CLIP no
INFORM | mapping file Line 21: R_8__IN_SDE3RemoveTableQualifier NO
INFORM | mapping file Line 22: R_8_RETRIEVE_ALL_SCHEMAS YES
INFORM | mapping file Line 23: R_8__SDE3Server marinmappdc
INFORM | mapping file Line 24: R_8_SDE3Server marinmappdc
INFORM | mapping file Line 25: R_8__SDE3UserName bvoigt
INFORM | mapping file Line 26: R_8_SDE3UserName bvoigt
INFORM | mapping file Line 27: R_8__SDE3Password sanrafGIS
INFORM | mapping file Line 28: R_8_SDE3Password sanrafGIS
INFORM | mapping file Line 29: R_8__SDE3Instance port:5151
INFORM | mapping file Line 30: R_8_SDE3Instance port:5151
INFORM | mapping file Line 31: R_8__SDE3Version SDE.DEFAULT
INFORM | mapping file Line 32: R_8_SDE3Version SDE.DEFAULT
INFORM | mapping file Line 33: R_8__SDE3WhereClause
INFORM | mapping file Line 34: R_8_SDE3WhereClause
INFORM | mapping file Line 35: R_8__SDE3LayerList
INFORM | mapping file Line 36: R_8_SDE3LayerList
INFORM | mapping file Line 37: R_8__SDE3MINX
INFORM | mapping file Line 38: R_8_SDE3MINX
INFORM | mapping file Line 39: R_8__SDE3MINY
INFORM | mapping file Line 40: R_8_SDE3MINY
INFORM | mapping file Line 41: R_8__SDE3MAXX
INFORM | mapping file Line 42: R_8_SDE3MAXX
INFORM | mapping file Line 43: R_8__SDE3MAXY
INFORM | mapping file Line 44: R_8_SDE3MAXY
INFORM | mapping file Line 45: R_8__SDE3CLIP no
INFORM | mapping file Line 46: R_8_SDE3CLIP no
INFORM | mapping file Line 47: R_8__SDE3RemoveTableQualifier NO
INFORM | mapping file Line 48: R_8_SDE3RemoveTableQualifier NO
INFORM | mapping file Line 49: R_8_INSTANCE port:5151
INFORM | mapping file Line 50: R_8_PASSWORD ********* [PW Deleted, but correct]
INFORM | mapping file Line 51: R_8_SERVER marinmappdc
INFORM | mapping file Line 52: R_8_REMOVE_TABLE_QUALIFIER NO
INFORM | mapping file Line 53: R_8_USERID bvoigt
INFORM | mapping file Line 54: R_8_VERSION_NAME SDE.DEFAULT
INFORM | mapping file Line 55: R_8_CLIP_TO_ENVELOPE no
INFORM | mapping file Line 56: READER_TYPE SDE30
INFORM | mapping file Line 57: R_8_PIPELINE C:\Program Files\FME Suite\pipeline\sde30_read.fmi
INFORM | mapping file Keyword: `READER_TYPE' occurs 2 time(s)
INFORM | mapping file Keyword: `R_8_PIPELINE' occurs 1 time(s)
INFORM | mapping file Keyword: `AUTOREG' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_USERID' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3Password' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3CLIP' occurs 1 time(s)
INFORM | mapping file Keyword: `LOG_MAX_FEATURES' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3MAXY' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3WhereClause' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3MAXY' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3Password' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3RemoveTableQualifier' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_CLIP_TO_ENVELOPE' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_RETRIEVE_ALL_SCHEMAS' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3CLIP' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3Server' occurs 1 time(s)
INFORM | mapping file Keyword: `APPLICATION' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_METAFILE' occurs 1 time(s)
INFORM | mapping file Keyword: `FME_SESSION_USED' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_DATASET' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_REMOVE_TABLE_QUALIFIER' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3RemoveTableQualifier' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3WhereClause' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3MINY' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3MINX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3Server' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3MINY' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3MAXX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3UserName' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3MAXY' occurs 1 time(s)
INFORM | mapping file Keyword: `LOG_APPEND' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_PASSWORD' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3CLIP' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3LayerList' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3Server' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3MINX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3LayerList' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3LayerList' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3Version' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SERVER' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3Instance' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3MAXX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3MAXX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3WhereClause' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3Version' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3Instance' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3UserName' occurs 1 time(s)
INFORM | mapping file Keyword: `FME_HOME' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3Password' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_INSTANCE' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3Version' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_VERSION_NAME' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__SDE3Instance' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8_SDE3MINY' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3MINX' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3UserName' occurs 1 time(s)
INFORM | mapping file Keyword: `R_8__IN_SDE3RemoveTableQualifier' occurs 1 time(s)
WARN | UniversalReader -- readSchema resulted in 0 schema features being returned
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
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
