revOpenDatabase Oracle

Hartmut Eich hartmut.eich at univie.ac.at
Fri Oct 15 02:38:19 EDT 2004




I have this Database 

Database name = test.at

TNSNAMES.ORA:

Test_db =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host =
        xxx.test_serv.at)(Port = 1111))
    )
    (CONNECT_DATA = (SID = TEST)
    )
  )

I do this

get revOpenDatabase("Oracle","xxx.test_serv.at","test.at",user,pw) 

get revOpenDatabase("Oracle","xxx.test_serv.at","TEST",user,pw)
 

The result is this 


ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor


The revolution documentation says:
"The port is the port number you want to connect to, and is used only
for PostgreSQL and MySQL databases. If no port is specified, MySQL
database connections use port 3306 and PostgreSQL database connections
use port 5432."

Which port does Oracle use?

Can somebody give me a hint, how to connect correct to the database

 

 

Thanks and advance 

 

Hartmut 

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution



More information about the use-livecode mailing list