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
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to