Receiving events using ODBC

[heye]

Hi,

Is there any way of receiving events that my VB6/C# applications wish to
subscribe to? AFAICT you can only receive notifications using embedded
SQL, which in turn only appears to be available for C.

Archived post - originally posted at 2004-09-17 17:32:01

[heye]

I'm positive we'll be using .Net

Archived post - originally posted at 2004-09-03 03:37:09

[heye]

Any which way that gets these events into my VB6/C# application is
absolutely fine -- ODBC just happens to be the most common way to access
the DB at my place of work.

So yes, this driver extension would be massively beneficial to me.
Embedded C is an option for parts of our project, which is writen in C,
but some parts will definately remain in VB6, and newer parts will be
written in C# where possible. Is the Ingres API accessible in those
environments? I guess if the API is disclosed by COM+ it would.

Archived post - originally posted at 2004-08-25 16:35:16

[loera01]

I checked around. Neither .Net or JDBC are an option because the DAS
server doesn't allow it.

Unless you can call the Ingres API from your C# or VB program, you will
have to rely on a plain C environment to do this.

The Ingres API and embedded languages such as Embedded C and Embedded
Basic allow you to catch db events.

Regards,
Ralph Loen

Archived post - originally posted at 2004-09-15 15:46:31

[loera01]

The Windows release of r3 will include a native .Net provider for Ingres.
I'm not familiar enough with .Net to know if it allows db events to be
caught. I can check with the .Net author, Dave Thole, if you are sure
you'd be going with .Net. Otherwise, embedded C is your best bet in the
near future.

Regards,
Ralph Loen

Archived post - originally posted at 2004-09-02 14:55:18

[joe]

DAS stands for Data Access Server and it supports JDBC and .Net Data
Provider (check the Connectivity Guide, Chapters 9, 10 and 12 for more
info).

OpenAPI does support dbevents. See page 1-15 in the OpenAPI User Guide.

I don't think there are docs on the DLL exports.

Embedded (ESQL) BASIC is supported on VMS, i.e., it supports what used to
be called VAX BASIC. I don't know how that compares to Visual Basic, but
you can find out about it in the Embedded SQL Companion Guide, Chapter 6.

The r3 port to Alpha OpenVMS is being worked on and when it's posted
you'll be able to see the ESQL/BASIC sources under front/embed/basic and
basicsq. We could perhaps post them earlier if you're interested.

Archived post - originally posted at 2004-09-17 17:32:01

[heye]

A plain DLL ought to work too, BTW, even if COM+ or a native .Net
interface (in the case of c#) would work nicer. There's loads of dlls that
are installed with Ingres, where can I find what DLL does what, and what
routines are contained within it? Or are these DLLs not part of the API?

Archived post - originally posted at 2004-08-26 10:11:30

[loera01]

Unfortunately, the ODBC 3.x spec does not include support for database
events, and thus neither does the Ingres driver. However, the Ingres ODBC
driver is built on top of the Ingres API, which does support them, so it
would be possible to extend the driver to handle db events with some new
kind of call such as, say, SQLGetEvent().

Is this something that would be beneficial to you? Is it an acceptable
alternative to go with embedded C or the Ingres API?

Regards,

Ralph Loen

Archived post - originally posted at 2004-08-25 12:30:29

[heye]

What is a DAS server?

The openAPI does allow access to events?

Is there documentation on which DLLs export which functions, and their
signatures?

I didn't even know there was an Embedded/Basic, I only saw C, Fortran &
COBOL. Maybe Embedded/basic could be made to work with VB.

Archived post - originally posted at 2004-09-17 14:49:00