Home » RDBMS Server » Server Administration » OCILogon problems
OCILogon problems [message #369406] Thu, 14 September 2000 11:53
Dimitri Voronin
Messages: 1
Registered: September 2000
Junior Member
I've try to establish single user connection. AFAIK i should use OCILogon call to complete this. I have allocated all handlers and all should be fine, but...
At this step i've a couple of problems:
1: If i call this function in accordance with documentation and examples and set parametres of (text*)username etc to strlen((char*)username) (similar actions i do with password and databasename...) OCILogon do nothing but exited application with exit code 6. By debugging source code of OCILogon i find that this function fails on memset call. This get me idea that i should use strlen((char*)username)+1 (last byte to \0 symbol...). Then i do this, all seens okey but i've got new problem.
2. I've shell with configured enviroment TNS_ADMIN=/usr/nas/config etc(AIX 4.2.3 ksh) To test TNS i start 'sqlplus myname/mypassword@mydatabase' and all ok. Then i start my application, OCILogon retuns error ORA-12154: TNS:could not resolve service name. I try everything i can but can't do enything. Can anybody help me with something, pls?!!
Previous Topic: what datatype to choose
Next Topic: How do I execute this package
Goto Forum:
  


Current Time: Fri Mar 29 07:23:02 CDT 2024