I have been trying to establish a connection directly to an Oracle database.
My desired result is to use a database table and/or view as a secondary data source joined to an SDF. In the two cases (3 and 4 below) where the Oracle database test is successful the “Secondary class (table):” list does not fill out (in the SDF join properties). As such I cannot actually create the join against an Oracle table in MG Studio. The only way I have been able to successfully do a join between a database and an SDF is to dump my oracle tables into an Access database. Though this does work this is definitely not a reasonable solution, plus it seems to be verrrryyyyy slow. I have also tried the King drivers against MGOS 1.2 quite a while ago and had similar issues. It's probably me so any help would be great! Database connection tests… 1. ODBC FDO "Connect to a Database" using the Oracle (Oracle Diver) and providing credentials. Upon testing I get this error An exception occurred in FDO component. RDBMS: No current open database. 2. ODBC FDO "Connect via a Data Source Name (DSN) set up on this server". The DSN I setup uses the “Oracle in instantclient 10_2” Upon testing I get this error. An exception occurred in FDO component. RDBMS: No current open database. 3. ODBC FDO "Connect to a Database" using the Oracle (Microsoft Diver) and providing credentials. Upon testing I get "Successful connection" 4. ODBC FDO "Connect via a Data Source Name (DSN) set up on this server". The DSN I setup uses the “Oracle Microsoft ODBC for Oracle”. Upon testing I get. "Successful connection" Any help would be greatly appreciate -- View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15906732.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
