<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"><DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">Hi,</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 Dave,Yestersday i figured it out about Driver Name Change and i changed it to Oracle in instantclient10_2 in the connection string but without any success.</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">I have around 30,000 Records in a Oracle table with Lat ,Lon and other pertinent readings in the table and the readings use to get updated every 2 hours or upon some event fired.Can you tell me what will be the better idea keeping in mind performance to go with -</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">1. Create DSN using Oracle ODBC Driver</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">2. Try to connect using Oracle Microsoft Driver after installing Oracle Client on the Server.</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">Or do u have any other suggestions or ideas !!</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: Dave Wilson <dave.wilson@autodesk.com><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Friday, February 29, 2008 9:19:10 AM<BR>Subject: RE: [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure odbc connection)<BR><BR>
<STYLE>
<!--
_filtered {font-family:"MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;}
_filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered {panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle18
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</STYLE>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">The connection string option does not work. A defect internal to Autodesk has already been logged regarding this. As well when using the instant client your Driver name must change to reflect the instant client you are using “Oracle in instantclient10_2” would be the correct name, however even with that change it still doesn’t work. Resolution of the TNSNAMES is not likely the issue based on testing we have done.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">The only option that works is to create a DSN wherever your server is installed.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Regards,</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'">Dave</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri', 'sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma', 'sans-serif'"> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Rahul<BR><B>Sent:</B> Friday, February 29, 2008 4:14 AM<BR><B>To:</B> MapGuide Users Mail List<BR><B>Subject:</B> [mapguide-users] Connection Problem-ORACLE ODBC Driver(configure odbc connection)</SPAN></P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV>
<DIV>
<P class=MsoNormal>Hi All,</P></DIV>
<DIV>
<P class=MsoNormal> I am using <STRONG>MGOS 1.2 and Map Guide Studio2008</STRONG>, I am trying to connect to <STRONG>Oracle Database 10.1.0 </STRONG>and i installed <STRONG>Oracle instant client-10.2.0.2</STRONG> on my machine i.e. MapGuide Server, I also succesully installed <STRONG>oracle odbc driver-win32 10.2.0.3</STRONG> in order to configure ODBC connection using Oracle(Oracle Driver) in the MapGuide Studio.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>I also set the PATH variable to oracle instant client directory as well as also defined ORACLE_HOME and TNS_ADMIN as system variable.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>I tried the connection string in th studio as follows -</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal><STRONG>Driver={Oracle ODBC Driver};Dbq=Database Name;Uid=xxx;Pwd=yyyy;</STRONG></P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>I also tried to use the another connection setting if it unable to get the values from tnsnames.ora hence i tried </P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<DIV>
<P class=MsoNormal><STRONG>Driver={Oracle ODBC Driver};Dbq=10.X.X.X:1521/abcd;Uid=xxx;Pwd=yyyy;</STRONG></P></DIV>
<P class=MsoNormal><BR>but i unable to connect to oracle and getting the FDO Error-An Exception Occured in FDO component.RDBMS:No Current open Database but the same database i can connect using the Fdo2Fdo Tools,Any kind of help will be really helpfull for me.</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal>Thks</P></DIV>
<DIV>
<P class=MsoNormal>Max !!</P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV>
<DIV>
<P class=MsoNormal> </P></DIV></DIV>
<P class=MsoNormal> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=1>
</DIV>
<P class=MsoNormal>Never miss a thing. <A href="http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs" target=_blank rel=nofollow>Make Yahoo your homepage.</A> </P></DIV><!-- kill -->
<DIV><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></DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR></DIV></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>
</body></html>