PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD18]- Oracle native access
[WD18]- Oracle native access
Iniciado por guest, 20,oct. 2016 13:09 - 1 respuesta
Publicado el 20,octubre 2016 - 13:09
When i run my program as a service i always have the error bellow when i try to connect to the DB, if i run the same code in the same server to connect to the DB but using a normal program it works without problems.

Any clues are welcome.

Details of the error:

native ORACLE access error.
Error Number = 22

The following error was returned by the database:
Error number = <0>.
Error message:
The following error was returned by the database:
Error number = <0>.
Error message:
WL call:
Process of 'Global Procedure Rotina_connect' (Global Procedures of GESVENGRH_SRV.Rotina_connect), line 63, thread 0
'HOpenConnection' function, syntax 0

What happened?
native ORACLE access error.
Error Number = 22

The following error was returned by the database:
Error number = <0>.
Error message:
The following error was returned by the database:
Error number = <0>.
Error message:

Error code: 73001
Level: non-fatal error (EL_ONRETURN)
WD55 error code: 3001

Dump of the error of 'WD180HF.DLL' module (18.0.106.0).
Identifier of detailed information (.err): 72801
Debugging information:
Client layer: D:\oracle\product\12.1.0\client_2\in\OCI.DLL
Provider: WinDevOracle
User: *******
Data source: xxxxxxxx
Database: xxxxxxxx
Connection time-out: 300
Command time-out: 300
Unicode supported: 1
Page code of WL: 1252
Page code of the connection: UTF-16
ANSI charset ID = 178
OCI_NLS_CHARACTER_SET =
IEWDORA=100.17
Module=
Version=<18.0.8.2>
Status = FFFFFFFF (OCI_ERROR)
Fonction (7,210)
Additional Information:
EIT_INFOCLIENT : <12.1.0.2.0>
EIT_NATIVECODE : <22>
EIT_PILEWL :
Global Procedure Rotina_connect (Global Procedures of GESVENGRH_SRV.Rotina_connect), line 63
Global Procedure servico (Global Procedures of GESVENGRH_SRV.servico), line 44
Running the service of GESVENGRH_SRV (called in loop) (), line 2
EIT_DATEHEURE : 19/10/2016 11:31:40

----- Sub-error #1 -----

What happened?
The following error was returned by the database:
Error number = <0>.
Error message:

Error code: 22
Level: fatal error (EL_FATAL)

Dump of the error of 'wd180ora.dll' module (18.0.8.2).
Identifier of detailed information (.err): 22
Debugging information:
IEWDORA=100.28
Module=
Version=<18.0.8.2>
Status = FFFFFFFF (OCI_ERROR)


----- Sub-error #2 -----

What happened?
Unable to create Oracle environment.
The following error was returned by the database:
Error number = <0>.
Error message:

Error code: 22
Level: fatal error (EL_FATAL)

Dump of the error of 'wd180ora.dll' module (18.0.8.2).
Identifier of detailed information (.err): 22
Debugging information:
IEWDORA=100.7
Module=
Version=<18.0.8.2>
Status = FFFFFFFF (OCI_ERROR)
Publicado el 20,octubre 2016 - 17:08
The problem was 2 oracle clients installed in the same server, one for 32 bits and another for 64 bits.

After the uninstall of the 64 bits client everything is working as expected.