Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
2
Erster Beitrag:
vor 10 Monaten
Letzter Beitrag:
vor 10 Monaten
Beteiligte Autoren:
Paulo Oliveira

[WD18]- Oracle native access

Startbeitrag von Paulo Oliveira am 20.10.2016 11: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 = .
Error message:
The following error was returned by the database:
Error number = .
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 = .
Error message:
The following error was returned by the database:
Error number = .
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\bin\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=
Status = FFFFFFFF (OCI_ERROR)
Fonction (7,210)
Additional Information:
EIT_INFOCLIENT :
EIT_NATIVECODE :
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 = .
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=
Status = FFFFFFFF (OCI_ERROR)


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

What happened?
Unable to create Oracle environment.
The following error was returned by the database:
Error number = .
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=
Status = FFFFFFFF (OCI_ERROR)

Antworten:

Re: [WD18]- Oracle native access [SOLVED]

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.

von Paulo Oliveira - am 20.10.2016 15:08
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.