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

[Rahul]

Hi,
        I think you try to connect Oracle Database  with Oracle Instant Client 10.2.0.3 and  oracle odbc driver-win32 10.2.0.3 . 

Try ODBC FDO "Connect via a Data Source Name (DSN) set up on this server" and use the above DSN which you created using the oracle odbc driver-win32 10.2.0.3 . 


Max !!

----- Original Message ----
From: Bob Cassarly <bob.cassarly at famis.com>
To: mapguide-users at lists.osgeo.org
Sent: Friday, March 7, 2008 9:29:30 AM
Subject: [mapguide-users] Problems with SDF/Database Joins (Oracle)


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
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080307/3aa28bb6/attachment.html