Try using upper case, oracle is case sensitive which means it can't find any tables because the FDO ODBC will look in the system tables for owner='username' when it should be owner='USERNAME' as all system tables are in upper case in oracle
z On Thu, Jul 10, 2008 at 1:35 PM, lolob <[EMAIL PROTECTED]> wrote: > > No, both username and password are lower case..anyone?? > > > > > zspitzer wrote: >> >> did you have your username in upper case? >> >> On Thu, Jul 10, 2008 at 11:53 AM, lolob <[EMAIL PROTECTED]> wrote: >>> >>> Hello list, >>> >>> I'm having some trouble connecting to Oracle here. I have Oracle9i >>> database,MGOS 1.2 and MG Studio 2008. >>> I created a system DSN (via ODBC) on Windows Server 2003 to the oracle >>> database. Hit the test button and success. Now I know my machine can >>> connect >>> to the oracle database(other machine) via ODBC. I open the MG Studio >>> 2008, >>> use the data connection via a Data Source Name (DSN), hit the test >>> connection and got this "An exception occurred in FDO component.RDBMS: No >>> current open database" The oracle client and the odbc driver is 10g. Help >>> please... >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Problems-connecting-to-database%3A-No-current-open-database.-tp18112121p18374419.html >>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> mapguide-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- > View this message in context: > http://www.nabble.com/Problems-connecting-to-database%3A-No-current-open-database.-tp18112121p18375230.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
