SQL Anywhere database - .NET event handler

Author

.NET event handler

Jim

2005-04-20, 8:23 pm

I have ASA 9.0.2.2451

Mobilink events can call .NET classes. Will a similar feature ever be
created in ASA? so that the event handler is an external .NET assembly? Is
there any way to launch an external process from ASA?

Greg Fenton

2005-04-20, 8:23 pm

Jim wrote:
>
> Mobilink events can call .NET classes. Will a similar feature ever be
> created in ASA? so that the event handler is an external .NET assembly? Is
> there any way to launch an external process from ASA?
>

I can't speak for calling .NET from within ASA. Neat idea, you might
consider posting this as a request to the newsgroup
sybase.public.sqlanywhere. product_futures_disc
ussion

You can launch an external process using the xp_cmdshell stored
procedure. Alternatively, you can create your own external procedure
calling into a DLL and do whatever you would like in that library.

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/

Jim

2005-04-21, 11:23 am

> Alternatively, you can create your own external procedure
> calling into a DLL and do whatever you would like in that library.

This sounds interesting. What would I look up in the documentation to find
info on this?

Thanks for your responses, Greg
--Jim

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:4266ebc6$1@foru
ms-2-dub...
> Jim wrote:
Is[color=darkred]
>
> I can't speak for calling .NET from within ASA. Neat idea, you might
> consider posting this as a request to the newsgroup
> sybase.public.sqlanywhere. product_futures_disc
ussion
>
> You can launch an external process using the xp_cmdshell stored
> procedure. Alternatively, you can create your own external procedure
> calling into a DLL and do whatever you would like in that library.
>
> 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/

Reg Domaratzki $iAnywhere Solutions$

2005-04-21, 11:23 am

ASA SQL User's Guide
Using Procedures, Triggers, and Batches
Calling external libraries from procedures

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Jim" <jimsjbox@yahoo.com> wrote in message news:4267cc75$1@foru
ms-1-dub...
>
> This sounds interesting. What would I look up in the documentation to
find
> info on this?
>
> Thanks for your responses, Greg
> --Jim
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
> news:4266ebc6$1@foru
ms-2-dub...
assembly?[color=darkred]
> Is
>
>

Greg Fenton

2005-04-21, 11:23 am

Jim wrote:
>
>
> This sounds interesting.

I should have also mentioned that you can create Java stored procedures
(I probably had a mental block on the Java front since you mentioned
..NET :-) )

In the ASA 9.x online docs, see:

ASA Programming Guide
- Using Java in the Database

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

Sponsored Links