[mapguide-users] Import Views from Oracle Spatial

[Dragan Podvezanec]

A. Fischer wrote:
> 
> I tried all. First I used SqlSheet for giving the views a primary key
> and/or
> a spatial index but both is not allowed to a View.
> Also I downloaded fdo2fdo but I didn't get a connection to my database
> with
> this although it works with MapGuide Maestro and I used the same settings.
> But fdo2fdo gives the error "ORA-12154: TNS: could not resolve the connect
> identifier specified"
> 

It seems like you don't have Oracle Instant client installed: you can get it
here: 

www.oracle.com/technology/tech/oci/instantclient/instantclient.html

After installing it, edit NETOWRK/ADMIN/tnsnames.ora file which will be in
Oracle installation directory, with something  like this:

MYSERVER =
  (DESCRIPTION = MYSERVER
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
    )
  )

After editing, try

tnsping MYSERVER 

from command line. If it works, you'll be able to use king.oracle.


-- 
View this message in context: http://www.nabble.com/Import-Views-from-Oracle-Spatial-tp18689745p18769269.html
Sent from the MapGuide Users mailing list archive at Nabble.com.