<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.message, li.message, div.message
{mso-style-name:message;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
background:white;
font-size:9.0pt;
font-family:"Arial","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Shailesh,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Which
version of King.Oracle provider Instant client or standard client are you using
?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Do
you have Oracle client installed also ?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>It
looks to me that “oracle” as you wrote is TNS name and not SID and that will
not work for instant client.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>If
oracle is your tns name than you use standard King.Oracle (if you have Oracle
client installed) than for Property “Service” you enter just oracle.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>We
can connect on chat.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Haris</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> shailesh
[mailto:shailesh@simplexindia.com] <br>
<b>Sent:</b> 9. december 2006 6:41<br>
<b>To:</b> users@mapguide.osgeo.org<br>
<b>Subject:</b> RE: [mapguide-users] cannot connect to Oracle XE and 9.2 (using
King Oracle provider)<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:9.0pt;
font-family:"Arial","sans-serif"'><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>
<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>-----
Original Message -----<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='background:#E4E4E4'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'> Haris Kurtagic <a
href="mailto:haris@sl-king.com"><haris@sl-king.com></a><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>To:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> <a
href="mailto:users@mapguide.osgeo.org"><users@mapguide.osgeo.org></a><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Cc:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Date:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> Friday, December 8
2006 09:11 PM<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Subject:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> RE: [mapguide-users]
cannot connect to Oracle XE and 9.2 (using King Oracle provider)<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:9.0pt;
font-family:"Arial","sans-serif"'>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>
<o:p></o:p></span></p>
<p class=MsoNormal>---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org For additional
commands, e-mail: users-help@mapguide.osgeo.org <o:p></o:p></p>
</div>
</body>
</html>