Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

calling external DLL functions

2 posts in General Discussion Last posting was on 2005-05-11 00:10:33.0Z
Madhu Sangam Posted on 2005-05-09 20:20:44.0Z
Reply-To: "Madhu Sangam" <madhu.sangam.NOSPAM@mobiledataforce.com>
From: "Madhu Sangam" <madhu.sangam.NOSPAM@mobiledataforce.com>
Newsgroups: ianywhere.public.general
Subject: calling external DLL functions
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 67.41.255.144
X-Original-NNTP-Posting-Host: 67.41.255.144
Message-ID: <427fc61c$1@forums-1-dub>
Date: 9 May 2005 13:20:44 -0700
X-Trace: forums-1-dub 1115670044 67.41.255.144 (9 May 2005 13:20:44 -0700)
X-Original-Trace: 9 May 2005 13:20:44 -0700, 67.41.255.144
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4459
Article PK: 8268

Hi to All.

This is my first post to the group.

I am trying to call a external function in a dll which sets the key in the
registry whenever the following procedure is run.

--------------
ALTER PROCEDURE "DBA"."fff"() /* [IN | OUT | INOUT] parameter_name
parameter_type [DEFAULT default_value], ... */

/* RESULT( column_name column_type, ... ) */
begin
create procedure DBA.dll_p() external name
'SetEventChangeFlag@C:\\TriggerDll\\Debug\TriggerDll.dll'
end
---------

when I execute the procedure, it runs fine but no value is written in the
registry
I cannot see what's going on? Any help would be appreciated.


Thanks
Madhu


Greg Fenton Posted on 2005-05-11 00:10:33.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: calling external DLL functions
References: <427fc61c$1@forums-1-dub>
In-Reply-To: <427fc61c$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <42814d79@forums-1-dub>
Date: 10 May 2005 17:10:33 -0700
X-Trace: forums-1-dub 1115770233 69.198.107.137 (10 May 2005 17:10:33 -0700)
X-Original-Trace: 10 May 2005 17:10:33 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 18
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4461
Article PK: 8270


Madhu Sangam wrote:
> when I execute the procedure, it runs fine but no value is written in the
> registry
> I cannot see what's going on? Any help would be appreciated.

Personally, I'd be using fopen() and fprintf() within the DLL to log the
progress of the run. Make sure the function is being called, and check
the return code from any and all win32 calls.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/