<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>Thks Zac,</P>
<P> </P>
<P> I treid to connect<U> Oracle Database 10.1.0 with Oracle Instant Client 10.2.0.2 and oracle odbc driver-win32 10.2.0.3 </U>. I successfully <STRONG>able to create and connect DSN using the Oracle Odbc driver</STRONG> but when i want to connect that<STRONG> DSN in the ADSK MapGuideStudio 2008</STRONG>,I unable to connect and it shows FDO Error-An Exception Occured in FDO component.RDBMS:No Current open Database .</P>
<P><STRONG>Do i require to install Oracle Instant Client 10.2.0.3.</STRONG></P>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Regarding the King Oracle FDO Provider ,I tried it already with Oracle Spatial Database but I haven't tried with tables without any GEOMETRY,I think i have to create FDO Class Table in order to read the Point Data stored as Lat,Lon,a,b,c,d --------- etc.</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Zac Can you provide little bit more detail in this case?</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Thks</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Max<BR><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Zac Spitzer <zac.spitzer@gmail.com><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Sunday, March 2, 2008 12:31:52 AM<BR>Subject: Re: [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure odbc connection)<BR><BR>Try King Oracle which is a FDO provider for Oracle<BR><BR><A href="http://www.sl-king.com/fdooracle/fdooracle.html" target=_blank>http://www.sl-king.com/fdooracle/fdooracle.html</A><BR><BR>there is a new test version for Mapguide 2.0 here @ <A href="ftp://www.sl-king.com/simon" target=_blank>ftp://www.sl-king.com/simon</A><BR><BR>On Sun, Mar 2, 2008 at 3:21 AM, Rahul <<A href="mailto:unicorn_admirer@yahoo.com" ymailto="mailto:unicorn_admirer@yahoo.com">unicorn_admirer@yahoo.com</A>> wrote:<BR>><BR>> Hi,<BR>><BR>> Thks Dave,Yestersday i figured it out about Driver
Name Change and i changed<BR>> it to Oracle in instantclient10_2 in the connection string but without any<BR>> success.<BR>><BR>> I have around 30,000 Records in a Oracle table with Lat ,Lon and other<BR>> pertinent readings in the table and the readings use to get updated every 2<BR>> hours or upon some event fired.Can you tell me what will be the better idea<BR>> keeping in mind performance to go with -<BR>><BR>> 1. Create DSN using Oracle ODBC Driver<BR>> 2. Try to connect using Oracle Microsoft Driver after installing Oracle<BR>> Client on the Server.<BR>><BR>> Or do u have any other suggestions or ideas !!<BR>><BR>> Thks<BR>> Max<BR>><BR>><BR>><BR>> ----- Original Message ----<BR>> From: Dave Wilson <<A href="mailto:dave.wilson@autodesk.com" ymailto="mailto:dave.wilson@autodesk.com">dave.wilson@autodesk.com</A>><BR>> To: MapGuide Users Mail List <<A
href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A>><BR>> Sent: Friday, February 29, 2008 9:19:10 AM<BR>> Subject: RE: [mapguide-users] Connection Problem-ORACLE ODBC<BR>> Driver(configure odbc connection)<BR>><BR>><BR>><BR>><BR>> The connection string option does not work. A defect internal to Autodesk<BR>> has already been logged regarding this. As well when using the instant<BR>> client your Driver name must change to reflect the instant client you are<BR>> using "Oracle in instantclient10_2" would be the correct name, however even<BR>> with that change it still doesn't work. Resolution of the TNSNAMES is not<BR>> likely the issue based on testing we have done.<BR>><BR>><BR>><BR>> The only option that works is to create a DSN wherever your server is<BR>> installed.<BR>><BR>><BR>><BR>>
Regards,<BR>><BR>> Dave<BR>><BR>><BR>><BR>><BR>><BR>> From: <A href="mailto:mapguide-users-bounces@lists.osgeo.org" ymailto="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</A><BR>> [mailto:<A href="mailto:mapguide-users-bounces@lists.osgeo.org" ymailto="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</A>] On Behalf Of Rahul<BR>> Sent: Friday, February 29, 2008 4:14 AM<BR>> To: MapGuide Users Mail List<BR>> Subject: [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure<BR>> odbc connection)<BR>><BR>><BR>><BR>><BR>><BR>> Hi All,<BR>><BR>><BR>> I am using MGOS 1.2 and Map Guide Studio2008, I am trying to<BR>> connect to Oracle Database 10.1.0 and i installed Oracle instant<BR>> client-10.2.0.2 on my machine i.e. MapGuide Server, I also
succesully<BR>> installed oracle odbc driver-win32 10.2.0.3 in order to configure ODBC<BR>> connection using Oracle(Oracle Driver) in the MapGuide Studio.<BR>><BR>><BR>><BR>><BR>><BR>> I also set the PATH variable to oracle instant client directory as well as<BR>> also defined ORACLE_HOME and TNS_ADMIN as system variable.<BR>><BR>><BR>><BR>><BR>><BR>> I tried the connection string in th studio as follows -<BR>><BR>><BR>><BR>><BR>><BR>> Driver={Oracle ODBC Driver};Dbq=Database Name;Uid=xxx;Pwd=yyyy;<BR>><BR>><BR>><BR>><BR>><BR>> I also tried to use the another connection setting if it unable to get the<BR>> values from tnsnames.ora hence i tried<BR>><BR>><BR>><BR>><BR>><BR>><BR>> Driver={Oracle ODBC Driver};Dbq=10.X.X.X:1521/abcd;Uid=xxx;Pwd=yyyy;<BR>><BR>><BR>> but i unable to connect to oracle and getting the FDO Error-An Exception<BR>>
Occured in FDO component.RDBMS:No Current open Database but the same<BR>> database i can connect using the Fdo2Fdo Tools,Any kind of help will be<BR>> really helpfull for me.<BR>><BR>><BR>><BR>><BR>><BR>> Thks<BR>><BR>><BR>> Max !!<BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>> ________________________________<BR>><BR>><BR>> Never miss a thing. Make Yahoo your homepage.<BR>><BR>><BR>> -----Inline Attachment Follows-----<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>><BR>><BR>><BR>>
________________________________<BR>> Never miss a thing. Make Yahoo your homepage.<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>><BR>><BR><BR><BR><BR>-- <BR>Zac Spitzer -<BR><A href="http://zacster.blogspot.com/" target=_blank>http://zacster.blogspot.com</A> (My Blog)<BR>+61 405 847 168<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>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR></DIV></div><br>
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a></body></html>