I changed to upper..but with no luck..is it because of MGOS 1.2 itself?
zspitzer wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Problems-connecting-to-database%3A-No-current-open-database.-tp18112121p18375864.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
