[mapguide-users] cannot connect to Oracle XE and 9.2 (using King Oracle provider)

[Haris Kurtagic]

Hi Shailesh,
 
I am out of office and not able to see .gif files but I will try to help.
 
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).
With MGOS 1.0.2 you should use 0.4.4 not 0.5.1
That could explain why you are able to connect with Fdo2Fdo but not with Map.
 
With instant client you can use connection string like //machine/sid , for xe installation it should be like: //localhost/xe
 
Haris

________________________________

From: shailesh [mailto:shailesh at simplexindia.com]
Sent: pet 12/8/2006 11:01
To: users at mapguide.osgeo.org
Subject: [mapguide-users] cannot connect to Oracle XE and 9.2 (using King Oracle provider)


Hi all,
I have been getting the error
****************************************************************
System.Net.WebException: The remote server returned an error: (559) MgFdoException.
at Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetRequestToString(Operation operation)
at Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String resourceId, String provider, String connectionString)
at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
at Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.buttonTestConnection_Click(Object sender, EventArgs e)

***************************************************
I have been getting the same error while connecting to oracle using king oracle provider on different/independent setups that i have

SETUP 1 - MY LAPTOP 

I have installed
MGOS 1.0.2 
ORACLE 9.2
Munsys - Munsys is a software which works on map3d and oracle spatial data. 
Munsys comes with a demo data which I have installed . the dataset is installed in oracle 9.2
i can open and see the spatial tables. i can pull this data in map3d 2006 , query data etc
so everything works fine on that end. now i have to pull the same spatial map in MapguideOS 
(please chk the attached screenshots, i can query and reterive parcels ) 
following Haris's FLASH Demo
I got FDO2FDO , king oracle provider instant client etc all setup as instructed in the demo by haris

now i Start Mapguide studio create a new data connection using King oracle provider
and enter the user name and password etc
and the click Test Connection . and THAT IS WHERE I GET THE ABOVE ERROR
(please chk the attached screenshots) 


SETUP 2 - MY DESKTOP 
I have installed 
MGOS 1.0.2 
ORACLE XE

I USED FDO2FDO to copy my shp to oracleXE , I could do that sucessfully,
I crosschecked and the table was there in oracle database.

Next I use Autodesk mapguide studio to try to connect to oracle xe (as shown in haris's demo) using king oracle provider
i still get the same error
Can somebody please help me on this


One thing that i could not understand in haris's demo was TNSNAMES step for Instant client
Can anyone please give me steps as to which file to edit and what to insert for TNSNAMES

I have been trying the same stuff again and again for past one week , but without any sucess
Please help


Thanks 
Shailesh





-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5975 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061208/d10c8132/attachment.bin