Hello, Pitaev, Anna wrote:
> The only thing I don’t yet understand: > > The oracle local configuration (tnsnames.ora) is installed on my oracle > machine and my c++ client application as well soci installation on the > client side. I do not fully understand the above. Does it mean that the file tnsnames.ora does not exist on the client side? It should be somewhere there, because this file defines the physical connection parameters for each known service. Please note that the Oracle Client installation does not only provide the client-side libraries (the ones which are also required by SOCI), but also a set of useful programs - the most important is sqlplus. This program allows to do a lot of thing with the database (real admins can do everything with this program alone) and in particular to check whether everything is installed properly. For example, if you plan to use the following SOCI properties: service=orcl user=scott password=tiger then you should be able to start the sqlplus program like this: sqlplus sc...@orcl (and then provide the password when asked for it) After connecting, you should be able execute SQL command directly in the command line, please try it. There is also a tnsping command, please try it at the client side like this: tnsping orcl (where mydatabase is the service name you are interested in) The interesting thing about sqlplus is that it will either work or fail together with SOCI (usually for the same reason), so if you cannot use sqlplus, you will not be able to use SOCI either. This also means that you can ask your local Oracle admin for help even if he is not aware of SOCI. BTW - please note that orcl, scott and tiger are settings which are used in Oracle tutorials and in some default and example installations. They might not be appropriate in your case - this depends on how the database was installed. Please let us know if you managed to get it working, it might be a useful case for others. Regards, -- Maciej Sobczak * www.msobczak.com * www.inspirel.com ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
