[mapguide-users] Problems with SDF/Database Joins (Oracle)

[Bob Cassarly]

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.