Re: ESQL/C

The other thing to remember is that the 16 bit client i-net does not allow multiple applications to access the database at the same time. You can only be connected to one database. i-connect solves this problem Jason On Wed, 05 Nov 1997 10:44:32 -0500, "Art S. Kagel" <kagel@bloomberg.com> wrote: >Alexey Poukhovsky wrote: >> >> Hello, All >> >> HELP!!!!! >> Can anyone tell me, what to do with this situation: >> I have to place some functions, which are working with Informix in DLL. >> And make calls to them from different applications. For example, I create >> DLL with only function: >> long opendb(char *name) >> { >> $database name; >> return sqlca.sqlcode; >> } >> The first application, called it got error=0 - it is Ok. >> But, if the second app calls the same function (the first have not >> finished), it has got error = -457. >> After that both of applications become unusable - any of informix function >> call got error -457. > >I do not think that you can put ESQL/C calls into a DLL. You will >either have to link the functions directly into your executables or >create a separate server task to handle database accesses and >communicate with it using some other Win32 (I assume you are using >WinNT or Win95 since you mention DLLs) IPC mechanism. I do this for >some of my UNIX applications to isolate database accesses from the >applications. On UNIX we would choose between shared memory, pipes, >named-pipes, UNIX or network domain sockets or STREAMS (depending on >UNIX variant) for IPC. Considering how "well" Win32 OS's multi-task and >communicate you may be best off biting the memory bullet and link in the >Informix interface functions (like your opendb()) directly into each >application. > >Art S. Kagel Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net root@localhost postmaster@localhost