<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<STYLE type=text/css>
<!--
.message {background: white; font-size:9pt; font-family:'Arial';}
.message p { margin-top: 0em; margin-bottom: 0em; }
-->
</STYLE>
</HEAD>
<BODY class='message' bgColor=#ffffff>
<br />I am using King Oracle provider ver 0.4.4 and NOT 0.5.1, <br />I am able to connect Oracle with Munsys which uses map 3d 2006 and FDO2FDO, eveything is fine on that end.<br /><br />I am NOT able to connect MGOS to Oracle (both my setups, one with XE and 9.2). <br /><br />On my xe-MGOS installation i used //localhost/xe <br /> ( xe as in your demo and could copy shp to xe using fdo2fdo)<br /><br />On my 9.2-MGOS installation<br /> I connect using //localhost/oracle , <br /> Username/password/schema MCITY93INT (Munsys sample schema which i can pull/query in MAP 3d 2006) <br /><br /><br /><br />Haris , If you don't mind can you please spare 5-10 mins on the chat on your site ? I think that should help me a lot. Kindly Oblige.<br />When are you usually available in the office or on chat. I had a chat with Saso last week but that did not help me much. and i am still stuck where i was 10 days back.<br /><br /><br /> <br /> <br /><blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #5167c6 2px solid; MARGIN-RIGHT: 0px"><div style="FONT: 10pt arial">----- Original Message -----</div><div style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><b>From:</b> Haris Kurtagic <a href="mailto:haris@sl-king.com"><haris@sl-king.com></a></div><div style="FONT: 10pt arial"><b>To:</b> <a href="mailto:users@mapguide.osgeo.org"><users@mapguide.osgeo.org></a></div><div style="FONT: 10pt arial"><b>Cc:</b> </div><div style="FONT: 10pt arial"><b>Date:</b> Friday, December 8 2006 09:11 PM</div><div style="FONT: 10pt arial"><b>Subject:</b> RE: [mapguide-users] cannot connect to Oracle XE and 9.2 (using King Oracle provider)</div>Hi Shailesh, <br /> <br />I am out of office and not able to see .gif files but I will try to help. <br /> <br />Which version of provider are you using with Map? Latest (0.5.1) one is not for Map just for MG OS 1.1 RC 1 (FDO 3.2). <br />With MGOS 1.0.2 you should use 0.4.4 not 0.5.1 <br />That could explain why you are able to connect with Fdo2Fdo but not with Map. <br /> <br />With instant client you can use connection string like //machine/sid , for xe installation it should be like: //localhost/xe <br /> <br />Haris <br /> <br />________________________________ <br /> <br />From: shailesh [mailto:shailesh@simplexindia.com] <br />Sent: pet 12/8/2006 11:01 <br />To: users@mapguide.osgeo.org <br />Subject: [mapguide-users] cannot connect to Oracle XE and 9.2 (using King Oracle provider) <br /> <br /> <br />Hi all, <br />I have been getting the error <br />**************************************************************** <br />System.Net.WebException: The remote server returned an error: (559) MgFdoException. <br />at Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetRequestToString(Operation operation) <br />at Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String resourceId, String provider, String connectionString) <br />at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection() <br />at Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.buttonTestConnection_Click(Object sender, EventArgs e) <br /> <br />*************************************************** <br />I have been getting the same error while connecting to oracle using king oracle provider on different/independent setups that i have <br /> <br />SETUP 1 - MY LAPTOP <br /> <br />I have installed <br />MGOS 1.0.2 <br />ORACLE 9.2 <br />Munsys - Munsys is a software which works on map3d and oracle spatial data. <br />Munsys comes with a demo data which I have installed . the dataset is installed in oracle 9.2 <br />i can open and see the spatial tables. i can pull this data in map3d 2006 , query data etc <br />so everything works fine on that end. now i have to pull the same spatial map in MapguideOS <br />(please chk the attached screenshots, i can query and reterive parcels ) <br />following Haris's FLASH Demo <br />I got FDO2FDO , king oracle provider instant client etc all setup as instructed in the demo by haris <br /> <br />now i Start Mapguide studio create a new data connection using King oracle provider <br />and enter the user name and password etc <br />and the click Test Connection . and THAT IS WHERE I GET THE ABOVE ERROR <br />(please chk the attached screenshots) <br /> <br /> <br />SETUP 2 - MY DESKTOP <br />I have installed <br />MGOS 1.0.2 <br />ORACLE XE <br /> <br />I USED FDO2FDO to copy my shp to oracleXE , I could do that sucessfully, <br />I crosschecked and the table was there in oracle database. <br /> <br />Next I use Autodesk mapguide studio to try to connect to oracle xe (as shown in haris's demo) using king oracle provider <br />i still get the same error <br />Can somebody please help me on this <br /> <br /> <br />One thing that i could not understand in haris's demo was TNSNAMES step for Instant client <br />Can anyone please give me steps as to which file to edit and what to insert for TNSNAMES <br /> <br />I have been trying the same stuff again and again for past one week , but without any sucess <br />Please help <br /> <br /> <br />Thanks <br />Shailesh <br /> <br /> <br /> <br /> <br /> <br /></blockquote>
</BODY></HTML>