Interbase and events (alerts)

[caf]

I need to write an application (In .NET (C# or VB.NET) to access an Interbase gdb among other things. It also needs to catch post_event calls made within triggers.
I was wondering if anyone ever used the IB API (seems like the only solution) from within C# or VB. I know Interbase is a Borland product but surely someone can help me out here. Im ina situation where I could tell these people to port their data to their newly acquired SQL Server2000 but I'd prefer to have their data stay in Interbase.
I searched the inet and could only find components for Delphi. I urgently need some guidance other than the recommendation to switch to Delphi or C++.

Thanks Again.
caf

PS: I've got two workarounds in mind.
1) External File declared as table and using dotNET functions to scan for changes in the file. I then write a record from the trigger instead of post_event.
2)Check the table every specified interval for changes (URghh!!~ Both options are MESSY! although one more than the other)

 

[MartijnTonies]

Perhaps I may suggest another suggestion? (is that a sentence?)

Would it be possible to write a DLL in Delphi (with the TIBEventAlerter component) and use that from C#?



Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com

 

[caf]

Thanks for the reply
Yes, it would be possible. The only problem is I don't have Delphi.
I was thinking of doing the ame in VC.NET or C# using the API but I the examples are all for Borland C++ & Delphi in the documentation.

 

[MartijnTonies]

Well, if you can use the native (Win32) API in C#, then it should be possible - you could start with the C++ examples, I guess.

Another try would the to download the Trial version of IB7 - I believe it includes a .NET driver - perhaps it also includes event alerters and the like.


Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com

 

[caf]

Thanx, I'll give it a try (IB7)
I was hoping I wouldn't have to resort to using the APi but I figure it's going to be my best bet.
C# for .NET doesn't have an #include preprocessor directive command so it makes it a bit difficult if I can't use header files. (ibase.h)

Thanx anyway.