Hi, I haven't used soci + orocle yet but I think you have to configure a
service name in your oracle installation to use in the connection string.
It seems to be the same way with JDBC:
http://w2.syronex.com/jmr/edu/db/oracle-and-java. I hope someone with
oracle+soci expertise read this and correct me in case I'm wrong.
Best regards,
Francisco.
2009/4/9 Pitaev, Anna <[email protected]>
> Hello,
>
> I am sorry, I am new to soci-library and can not find out, where
> can I configure the IP of the oracle database,
>
>
>
> if I create the db-connection using sosi example:
>
> session sql(oracle, "service=orcl user=scott password=tiger");
>
>
>
> I get the Error: ORA-12154: TNS:could not resolve the connect identifier
> specified
>
>
>
>
>
> If I put the ip to my connection String like:
>
>
>
> session sql(oracle, "servi...@myhost:1521:orcl user=scott password=tiger");
>
> I get the same error message the Error: ORA-12154: TNS:could not resolve
> the connect identifier specified
>
>
>
> If I replace @ with \\ in the connection string:
>
>
>
> I get the Error: Error: ORA-12545: Connect failed because target host or
> object does not exist
>
>
>
>
>
> Many thanks in advance!!!
>
>
>
> Kind regards,
>
>
>
>
>
>
>
>
>
>
>
> Anna Pitaev
> _________________________________________
> Logica - Releasing your potential
>
> Logica Deutschland GmbH & Co. KG
> Rheinstrasse 95
> 64295 Darmstadt
> Germany
> Tel.: +49 6151 36860-121
> E-Mail: [email protected]
> www.logica.com
>
> Logica Deutschland GmbH & Co. KG
> Zettachring 4, 70567 Stuttgart; Amtsgericht Stuttgart HRA 722072
> Persönlich haftender Gesellschafter: Logica Verwaltungs GmbH
>
> Geschäftsführer: Torsten Straß (Vors.) / Dr. Thomas Elsner / Eric Guyot /
> Andreas Manganaro / Olaf Scholz / Oliver Starzonek; Handelsregister AG
> Stuttgart HRB 724084
>
>
>
> Please help Logica to respect the environment by not printing this email /
> Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
> imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen
> Sie so Logica dabei die Umwelt zu schuetzen / Por favor ajude a Logica a
> respeitar o ambiente não imprimindo este correio electrónico. This e-mail
> and any attachment is for authorised use by the intended recipient(s) only.
> It may contain proprietary material, confidential information and/or be
> subject to legal privilege. It should not be copied, disclosed to, retained
> or used by, any other party. If you are not an intended recipient then
> please promptly delete this e-mail and any attachment and all copies and
> inform the sender. Thank you.
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> High Quality Requirements in a Collaborative Environment.
> Download a free trial of Rational Requirements Composer Now!
> http://p.sf.net/sfu/www-ibm-com
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
>
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
