Cannot select from Temp table

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET, Transactions, Locking & Isolation

Thomas Lee — Tue, 24 Oct 2000 05:49:12 GMT — source: Informix-list mailing list archive (1991-1998)

The problem i encountered is that my VisualBasic client via ODBC can create a temp table but could not select from the temp table. It gives following error: S0002: [INTERSOLV][ODBC Informix driver][Informix]The specified table (table) is not in the database. The problem started when we turned ON the transaction logging. thanks in advance for any help, thomas Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Thomas Lee

Sergey E. Volkov — Tue, 24 Oct 2000 10:25:28 +0400 — source: Informix-list mailing list archive (1991-1998)

Hi Thomas. This possible in two case only - 1)VB uses different sessions for create temporary table and for select data from it, or 2) VB closed current session after creating temporary table. Good luck. Sergey. Thomas Lee <sungjit@tp.edu.sg> ''''' ' ''''''''':8t37sn$do0$1@nnrp1.deja.com... > The problem i encountered is that my VisualBasic client via ODBC can > create a temp table but could not select from the temp table. > It gives following error: > > S0002: [INTERSOLV][ODBC Informix driver][Informix]The specified table > (table) is not in the database. > > The problem started when we turned ON the transaction logging. > > thanks in advance for any help, > thomas > > > Sent via Deja.com http://www.deja.com/ > Before you buy.