Using "set session with description" via ODBC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve McElhinney - 21 Oct 2005 16:27 GMT

I've have set the following on my PC to try and identify the ODBC
client sessions from IPM on the server:

ingsetenv ING_SET "set lockmode session where readlock=nolock; set
session with description='Steve McElhinney'"

This works when I do a basic sql connection from my PC to the server
e.g.
c:\> sql live_vnode::livedb (the descr is visible in IPM)

But the description is not shown in IPM when I connect using Crystal
reports, using ODBC and the same vnode.
Has anyone managed to get "set session with description=' '" working
via ODBC?

Env.
Client: Windows XP prof, Ingres 2.6, CA ODBC Driver 3.5 (patch 9885),
Crystal v9.
Server: AIX 5.2,Ing 2.6

Thanks
Steve

Reply to this Message

Gerhard Hofmann - 23 Oct 2005 09:40 GMT

> I've have set the following on my PC to try and identify the ODBC
> client sessions from IPM on the server:
[quoted text clipped - 15 lines]
> Crystal v9.
> Server: AIX 5.2,Ing 2.6

Maybe you could identify the client host name by running this against imadb:
select client_name from ima_server_sessions

Regards
Gerhard

Reply to this Message

Laurence Breeze - 25 Oct 2005 12:13 GMT

Hi Steve,

We've managed to get this working via ODBC using a VB client. However,
the "set session .." statement is executed.

Laurence

> I've have set the following on my PC to try and identify the ODBC
> client sessions from IPM on the server:
[quoted text clipped - 18 lines]
> Thanks
> Steve

Reply to this Message

Mike Lay - 25 Oct 2005 14:12 GMT

> We've managed to get this working via ODBC using a VB client. However,
> the "set session .." statement is executed.
[quoted text clipped - 18 lines]
>> Crystal v9.
>> Server: AIX 5.2,Ing 2.6

Seems to work OK for me. In fact its a nice trick! That's with

CLient: XP SP2, Ingres 2.6, Application written with C++ Builder. Also
works with ACCESS
Server: Ingres 2.6 Linux on RedHat

Reply to this Message