Vsem privet!

Est' nekii' DLL napisannyi na C.

Applikatsiya napisannaya na PowerBuilder (8.0.2) ispol'zuet etot DLL. Applikatziya zapuskaetsya pod Windows 2000.
Pri zapuske apllikatzii vyzyvaetstysya desyatok funktcij etogo DLL-ya.

Programma zapuskaetsya bez problem.
Teper' user s pomoshchyu programy delaet zapros v bazu dannyx (Oracle 8.1.7), poluchaet zaproshennye dannye v okne, najimaet knopku chtoby otrpavit' eti dannye po-email.

Esli neskol'ko raz povtorit' eti deistviya to pri popytke ocherednogo zaprosa k baze dannyx poluchaem
soobshenie ob oshibke "Select error ORA-12571, TNS packet writer failure".

Export of DLL function sdelan v sootvetstvii s trebovanyami postroeniya DLL-ei dlya PowerBuilder.

http://www.sybase.com/detail?id=47626

// function prototype in *.h file
int __declspec( dllexport ) _stdcall myFunction1 (char *pStr);

// *.DEF file
EXPORTS myFunction1 =_myFunction1 @4

"Project Settings" for Win32 Debug ->C/C++ tab->Category "Code generation"->Struct Member Alignment
changed
from 8 bytes * (default)
to 1 byte

Esli PoweBuilder application zapuskaetsya bez vyzova functions of the DLL, to net nikakix problem pri tex je dejstviyax polzovatelya.
Napominayu, chto vse DLL function vyzyvaetstysya tolko pri zapuske apllikatzii, kotoryi proxodit gladko.

Problemy voznikayut pri vypolnenii kakix libo operatsii voobsche ne svyazannyx s vyzovom function of the DLL.

Budu rad esli kto libo smojet pomoch'
Zaranee blagodaren,
Arkady

Of course, I have read it.

Unfortunately the real problem does not relate to Oracle.
Sometimes the error arise like the broken connection to the DB or to the mail server. It is only symptom of the real problem.

Actually PowerBuilder application uses the DLL in order to get some data from the Mainframe. The communication with MF is done using the MQ Series.

If another software (CPE) is used instead of MQ Series for this purpose the problem does not arise at all.

It seems that the diifferent memory layout in CPE & MQ Series influents by some way on the PowerBuilder application, which uses the DLL.

I have no idea where is the solution lay.

Regards,
Arkady

NewOne, I have placed my question to the ORA's forum too.
No reply there :-(.

Filipp,
Dumayu chto problema ne v syntaxe PowerScripta.
Esli by tam byli oshibki, to applikatsiya prosto ne podnimalas' by.

Pri zapuske apllikatsii vyzyvayutsya neskol'ko funktsii DLL-lya i oni otrabatyvayut normal'no i vozrashayut trebuemye znachenia.

Problemy voznikayu pozje, kogda funkcii DLL0a bol'she ne vyzyvayutsya.

Razrabotchik applikatzii probowal zakommentirovat' vse vyzovy funktcii DLL-lya.
Togda net nikakix problem. Delali my i takoi eksperiment. Vyzyvali odny function of DLL, kotorya nicheno ne delala (with empty body). Pri etom problema vosproizvodilas'.

Regards,
Arkady

Filipp,

Vot 2 kusochak PowerScrpit-a:

//========================================
// My DLL function declaration (to import it)
//========================================
function int GetUserId(int index, REF string userId) Library "mylib55.dll"

//========================================
// body of the functon that calls GetUserId()
//========================================
String ls_userid
integer li_index = 0

ls_userid = space(13)
GetUserId( li_index, ls_userid)
Return( ls_userid )
//========================================

Regards,
Arkady

>А space(13) хватает?

Xvataet.

Ну не важно, начнём сначала.

1) DLL с Ораклом разговаривает?

Net.

2) Есть ли какие нибудь попытки передавать DBHandle из РВ в DLL ?

Net.

Nashel istochnik nepriyatnostei.
Bug byl v drugom DLLe , funkstii kotorogo vyzyvalis' iz "podozrevaemogo" DLLya.

Tot vtoroj DLL ispol'zuet funktziona'nost'' Winsock2.
Nekorrektnya initzializtiya Winsock2 privodila k probleme.

Spasibo vsem za pomosch'!
U vas prekrasno organizovannyi' forum!!!

S uvajeniem,
Arkady