<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 All,</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"> 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.</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 also set the PATH variable to oracle instant client directory as well as also defined ORACLE_HOME and TNS_ADMIN as system variable.</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 tried the connection string in th studio as follows -</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"><STRONG>Driver={Oracle ODBC Driver};Dbq=Database Name;Uid=xxx;Pwd=yyyy;</STRONG></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 also tried to use the another connection setting if it unable to get the values from tnsnames.ora hence i tried </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">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><STRONG>Driver={Oracle ODBC Driver};Dbq=10.X.X.X:1521/abcd;Uid=xxx;Pwd=yyyy;</STRONG></DIV><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.</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 !!</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"> </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>