Simon, does king oracle work with 11g client, or just 10g?
z On Fri, Nov 13, 2009 at 6:25 PM, Simon Pelicon <si...@sl-king.com> wrote: > Hi! > for SERVICE NAME enter: > 1. if you use Oracle instant client use (as Zac answered) oracle easy > connect syntax: //servername/orcl > 2. if you use Oracle client than enter your oracle Service name specified > in client > > SCHEMA (optional parameter) > "OracleSchema" determines if all raws from ALL_SDO_GEOM_METADATA will be > used or just rows with Owner equal to "OracleSchema" > > KINGFDOCLASS (optional parameter) > if you want that provider uses additional Oracle Table to describe FDO > classes. > > To connect you need username,password and valid service name. > > > > On Fri, Nov 13, 2009 at 5:06 AM, manav dayal <manav_daya...@yahoo.co.in>wrote: > >> When i opt for new dataconnection using oracle provider in maestro, a new >> source window opens. On this window I opt for specified credentials and pass >> the username and password. >> >> when i use sql prompt, it works fine with username/passw...@orcl. >> >> I need to know what should be written inside the text boxes for service, >> schema and king FDO class or do i need to make any other connection >> settings. >> >> >> --- On *Thu, 12/11/09, Zac Spitzer <zac.spit...@gmail.com>* wrote: >> >> >> From: Zac Spitzer <zac.spit...@gmail.com> >> Subject: Re: [mapguide-users] connection with oracle >> To: "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org> >> Date: Thursday, 12 November, 2009, 6:04 PM >> >> it is purely a error with the service name >> >> ORA-12154: TNS:could not resolve the connect identifier specified >> >> is a native error code from oracle >> >> what are your connection settings? >> >> z >> >> >> >> On Thu, Nov 12, 2009 at 11:01 PM, Dejan Gregor >> <dejan.gre...@gmail.com<http://in.mc941.mail.yahoo.com/mc/compose?to=dejan.gre...@gmail.com>> >> wrote: >> > >> > Do you have an Oracle client installed from where you are connecting? >> > Dejan >> > >> > On Thu, Nov 12, 2009 at 12:58, manav dayal >> > <manav_daya...@yahoo.co.in<http://in.mc941.mail.yahoo.com/mc/compose?to=manav_daya...@yahoo.co.in>> >> wrote: >> >> >> >> >> >> I am using maestro1.0 and trying to connect to the remote database >> server. >> >> When I choose to make a new data connection with >> OSGeo.KingOracle.3.3 as the >> >> provider for oracle. >> >> >> >> Following error is being thrown when I try to test the connection. >> >> >> >> >> >> The remote server returned an error: (559) MgFdoException.: >> >> An exception occurred in FDO component. >> >> ORA-12154: TNS:could not resolve the connect identifier specified >> >> Exception occurred in method MgFdoConnectionManager.Open at line 858 in >> file >> d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp >> >> >> >> kindly help asap. >> >> Regards. >> >> >> >> ________________________________ >> >> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >> >> _______________________________________________ >> >> mapguide-users mailing list >> >> mapguide-users@lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-us...@lists.osgeo.org> >> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> >> > >> > >> > _______________________________________________ >> > mapguide-users mailing list >> > mapguide-users@lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-us...@lists.osgeo.org> >> > http://lists.osgeo.org/mailman/listinfo/mapguide-users >> > >> >> >> >> -- >> Zac Spitzer >> Solution Architect / Director >> Ennoble Consultancy Australia >> http://www.ennoble.com.au >> http://zacster.blogspot.com >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-us...@lists.osgeo.org> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> >> ------------------------------ >> The INTERNET now has a personality. YOURS! See your Yahoo! >> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >> . >> >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168
_______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users