Get session id for OLEDB connection?

Posted in 2005

Summary

Richard Spitz asked how a Visual Basic application using the Informix OLEDB driver can get its own session id. Art S. Kagel gave SELECT DBINFO('sessionid') FROM systables WHERE tabid = 1, documented in the Guide to SQL Syntax. Richard confirmed it and admitted tunnel vision on ADO properties. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Connectivity: ODBC / JDBC / .NET

Richard Spitz — Thu, 23 Jun 2005 18:40:34 +0200 — source: Usenet: comp.databases.informix

Hi Informixers, is it possible for a Visual Basic application connecting to IDS via OLEDB to somehow get its own session id for the active connection? If so, how do I do this? I couldn't find anything in the Informix OLEDB programmer's guide or in the Visual Basic (6.0) docs. I find the Informix OLEDB and ODBC driver documentation a bit lacking, and threads in this newsgroup about such topics tend to be rather short. Any hints for resources where such questions might be more on topic or get more and better attention? Regards, Richard

↪ replying to Richard Spitz

Art S. Kagel — Thu, 23 Jun 2005 16:16:18 -0400 — source: Usenet: comp.databases.informix

Richard Spitz wrote: > Hi Informixers, SELECT DBINFO( 'sessionid' ) FROM systables WHERE tabid = 1; It's in the Guide to SQL Syntax manual. Art S. Kagel > is it possible for a Visual Basic application connecting to IDS > via OLEDB to somehow get its own session id for the active connection? > If so, how do I do this? > > I couldn't find anything in the Informix OLEDB programmer's guide > or in the Visual Basic (6.0) docs. > > I find the Informix OLEDB and ODBC driver documentation a bit lacking, > and threads in this newsgroup about such topics tend to be rather > short. Any hints for resources where such questions might be more > on topic or get more and better attention? > > Regards, Richard >

↪ replying to Art S. Kagel

Richard Spitz — Fri, 24 Jun 2005 10:40:23 +0200 — source: Usenet: comp.databases.informix

"Art S. Kagel" <kagel@bloomberg.net> schrieb: >SELECT DBINFO( 'sessionid' ) FROM systables WHERE tabid = 1; > >It's in the Guide to SQL Syntax manual. Oops, how embarrassing. I was so caught up in the ADO connection properties that I didn't even think of the good old Informix mechanisms. Thanks for pointing that out to me. Regards, Richard

↪ replying to Richard Spitz

Art S. Kagel — Fri, 24 Jun 2005 12:24:37 -0400 — source: Usenet: comp.databases.informix

Richard Spitz wrote: > "Art S. Kagel" <kagel@bloomberg.net> schrieb: > > >>SELECT DBINFO( 'sessionid' ) FROM systables WHERE tabid = 1; >> >>It's in the Guide to SQL Syntax manual. > > > Oops, how embarrassing. I was so caught up in the ADO connection > properties that I didn't even think of the good old Informix > mechanisms. Thanks for pointing that out to me. Ahh, tunnel vision! No worries, we all succumb from time to time. Art S. Kagel > Regards, Richard