[mapguide-users] Problems connecting to database: No current open database.

[Zac Spitzer]

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 <azzam_wahab at hotmail.com> 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 <azzam_wahab at hotmail.com> 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
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>
>>
>>
>> --
>> Zac Spitzer -
>> http://zacster.blogspot.com (My Blog)
>> +61 405 847 168
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168