revOpenDatabase Oracle

Pierre Sahores psahores at easynet.fr
Fri Oct 15 04:49:39 EDT 2004


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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

psahores+ at +easynet.fr
sahoresp+ at +mac.com

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é"



More information about the use-livecode mailing list