Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Interbase and events (alerts)

Interbase and events (alerts)

Interbase and events (alerts)

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.

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)

RE: Interbase and events (alerts)

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

RE: Interbase and events (alerts)

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.

RE: Interbase and events (alerts)

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

RE: Interbase and events (alerts)

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close