<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><P>Hi,</P>
<P> I think you try to connect<U> Oracle Database with <SPAN class=yshortcuts id=lw_1204951091_0 style="CURSOR: hand; BORDER-BOTTOM: #0066cc 1px dashed">Oracle</SPAN> Instant Client 10.2.0.3 and oracle odbc driver-win32 10.2.0.3 </U>. </P>
<P><BR>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 <U>oracle odbc driver-win32 10.2.0.3 </U>. </P>
<P> </P>
<P><BR>Max !!<BR></P>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Bob Cassarly <bob.cassarly@famis.com><BR>To: mapguide-users@lists.osgeo.org<BR>Sent: Friday, March 7, 2008 9:29:30 AM<BR>Subject: [mapguide-users] Problems with SDF/Database Joins (Oracle)<BR><BR><BR>I have been trying to establish a connection directly to an Oracle database.<BR><BR>My desired result is to use a database table and/or view as a secondary data<BR>source joined to an SDF. In the two cases (3 and 4 below) where the Oracle<BR>database test is successful the “Secondary class (table):” list does not<BR>fill out (in the SDF join properties). As such I cannot actually create the<BR>join against an Oracle table in MG Studio.<BR><BR>The only way I have been able to successfully do a join between a database<BR>and an SDF is to dump my oracle tables into an Access database. Though this<BR>does work this
is definitely not a reasonable solution, plus it seems to be<BR>verrrryyyyy slow.<BR><BR>I have also tried the King drivers against MGOS 1.2 quite a while ago and<BR>had similar issues. It's probably me so any help would be great!<BR><BR>Database connection tests…<BR><BR>1. ODBC FDO "Connect to a Database" using the Oracle (Oracle Diver) and<BR>providing credentials. Upon testing I get this error<BR><BR>An exception occurred in FDO component. RDBMS: No current open database. <BR><BR>2. ODBC FDO "Connect via a Data Source Name (DSN) set up on this server". <BR>The DSN I setup uses the “Oracle in instantclient 10_2” Upon testing I get<BR>this error.<BR><BR>An exception occurred in FDO component. RDBMS: No current open database. <BR><BR>3. ODBC FDO "Connect to a Database" using the Oracle (Microsoft Diver) and<BR>providing credentials. Upon testing I get <BR><BR>"Successful connection"<BR><BR>4. ODBC FDO "Connect via a
Data Source Name (DSN) set up on this server". <BR>The DSN I setup uses the “Oracle Microsoft ODBC for Oracle”. Upon testing I<BR>get.<BR><BR>"Successful connection"<BR><BR>Any help would be greatly appreciate<BR><BR>-- <BR>View this message in context: <A href="http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15906732.html" target=_blank>http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15906732.html</A><BR>Sent from the MapGuide Users mailing list archive at <A href="http://nabble.com/" target=_blank>Nabble.com</A>.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></DIV><BR></DIV></div><br>
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a></body></html>