Oracle Connection in 2008

[Anonymous]

Hi,

I am having some trouble connecting to an Oracle
9.2 database with MGE 2008 via Studio 2008.  I have created a system DSN on
Windows Server 2003.  I know this DSN works fine with ColdFusion.  If
I try to use that DSN to create a MGE data connection, I enter the username and
password and test connection is succesful.  However, pressing the Show
Tables button displays nothing and the error log file yields:

<2007-07-17T11:09:05>
   Administrator
 Error: An exception occurred in FDO
component.
        Datastore
'mydatastorename' does not exist, case may be incorrect or is inaccessible from
current connection.
 StackTrace:
  -
MgFeatureServiceHandler.ProcessOperation line 83 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\FeatureServiceHandler.cpp
 
- MgOpDescribeSchemaAsXml.Execute line 107 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\OpDescribeSchemaAsXml.cpp
 
- MgServerDescribeSchema.DescribeSchema line 500 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerDescribeSchema.cpp
 
- MgServerDescribeSchema.ExecuteDescribeSchema line 173 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerDescribeSchema.cpp
 
- MgFdoConnectionManager.Open line 979 file
c:\build_bond_area\Bond_Nightly\BUILD_41.3\Ent\OS\Server\src\Common\Manager\FdoConnectionManager.cpp An
exception occurred in FDO component.
Datastore 'mydatastorename' does not
exist, case may be incorrect or is inaccessible from current
connection.

I've checked with the case
upper and lower and it doesn't matter.  I've also tried using the Connect
to a Database option with the Oracle, Microsoft Oracle and Other types with
correct information in the connection strings.  In all cases I get a "An
exception occurred in FDO component RDBMS: No current open database".  This
particular user in Oracle has connect, DBA and resource
roles.

Any help would be
appreciated.  Thank you.

--
Andy Morsell,
P.E.
Spatial Integrators, Inc.

href="http://www.SpatialGIS.com">http://www.SpatialGIS.com

[dswilson]

Hey Andy.

What Oracle client are they using?
What ODBC Driver are they using?
In your DSN did you specify an uppercase UserId for the schema you plan to access?

You might want to try the current InstantClient_10_2 which should be backwards compatible. I believe you have to download the ODBC driver separately and add it to the folder.

Dave

[Anonymous]

I got a little further on this.  The problem
described below is due to specifying the username in the DSN connection. 
By not specifying it, pressing the Show Tables button now caused the
mgserver.exe process to max the CPU.  This appears to be it enumerating all
of the tables in all database schemas, and there are MANY in this
database.  Even though this particuler user has only been granted object
priveleges on one table, it looks like it is reading many more.  In the
end, after more than 5 minutes of 100% CPU activity, no tables are
displayed in the dialog.

Andy

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Andy Morsell" <
href="mailto:amorsell@spatial*nospam*gis.com">amorsell@spatial*nospam*gis.com>
wrote in message
href="news:5660621@discussion.autodesk.com">news:5660621@discussion.autodesk.com...

Hi,

I am having some trouble connecting to an Oracle
9.2 database with MGE 2008 via Studio 2008.  I have created a system DSN
on Windows Server 2003.  I know this DSN works fine with
ColdFusion.  If I try to use that DSN to create a MGE data connection, I
enter the username and password and test connection is succesful. 
However, pressing the Show Tables button displays nothing and the error log
file yields:

<2007-07-17T11:09:05>
   Administrator
 Error: An exception occurred in FDO
component.
        Datastore
'mydatastorename' does not exist, case may be incorrect or is inaccessible
from current connection.
 StackTrace:
  -
MgFeatureServiceHandler.ProcessOperation line 83 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\FeatureServiceHandler.cpp
 
- MgOpDescribeSchemaAsXml.Execute line 107 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\OpDescribeSchemaAsXml.cpp
 
- MgServerDescribeSchema.DescribeSchema line 500 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerDescribeSchema.cpp
 
- MgServerDescribeSchema.ExecuteDescribeSchema line 173 file
c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerDescribeSchema.cpp
 
- MgFdoConnectionManager.Open line 979 file
c:\build_bond_area\Bond_Nightly\BUILD_41.3\Ent\OS\Server\src\Common\Manager\FdoConnectionManager.cpp An
exception occurred in FDO component.
Datastore 'mydatastorename' does not
exist, case may be incorrect or is inaccessible from current
connection.

I've checked with the case
upper and lower and it doesn't matter.  I've also tried using the Connect
to a Database option with the Oracle, Microsoft Oracle and Other types with
correct information in the connection strings.  In all cases I get a "An
exception occurred in FDO component RDBMS: No current open database". 
This particular user in Oracle has connect, DBA and resource
roles.

Any help would be
appreciated.  Thank you.

--
Andy Morsell,
P.E.
Spatial Integrators, Inc.

href="http://www.SpatialGIS.com">http://www.SpatialGIS.com

[Anonymous]

Dave,
Thanks. The fact that the my UserId in the DSN was initially the wrong case
was causing problems. I was not looking at that and was instead focusing on
the user name and password (the user name is the same as the schema name in
this case).

By the way, omitting the UserId from the DSN is apparently not a good idea
(see my other post) as the FDO provider will try to enumerate everything in
the database.

Thanks again for your help.

Andy

wrote in message news:5660639@discussion.autodesk.com...
Hey Andy.

What Oracle client are they using?
What ODBC Driver are they using?
In your DSN did you specify an uppercase UserId for the schema you plan to
access?

You might want to try the current InstantClient_10_2 which should be
backwards compatible. I believe you have to download the ODBC driver
separately and add it to the folder.

Dave