I don't remember anymore since i use Postgres instead of Oracle but you
should find this info in watching to your SQL*Plus documentation. Have
an eye too about the login/password needed to access your Oracle
backend (was by default "tiger/tiger" time before).
Best, Pierre
Le 15 oct. 04, à 08:38, Hartmut Eich a écrit :
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
--
Bien cordialement, Pierre Sahores
100, rue de Paris
F - 77140 Nemours
[EMAIL PROTECTED]
[EMAIL PROTECTED]
GSM: +33 6 03 95 77 70
Pro: +33 1 64 45 05 33
Fax: +33 1 64 45 05 33
<http://www.sahores-conseil.com/>
WEB/EAI services & ACID DB over IP
"Mutualiser les deltas de productivité"
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution