Oracle,ODBC and truncated SQL 
Author Message
 Oracle,ODBC and truncated SQL

We're accessing Oracle from a VB front-end. Occasionally, a session will hang.
The buffer in SQLAREA shows a truncated SQL statement (exactly 20 bytes worth
in the cases we've been able to capture to date). There is no apparent pattern
(naturally) to this; it has cropped up in more than one transaction or query.

Has anyone else seen this problem? Any advice on where to begin tracking this
one down?

The particulars:
Oracle - v7.0.16, running under HP-Unix
SQL*Net - v2.0
ODBC driver - Oracle's own
VB - v3.0, using Intersolv's Q+E library to get to ODBC.
TCP/IP stack -- a mix of users running Novell LAN workplace and Netmanag
                Chameleon. I believe the error has cropped up in both stacks.

Many, many thanks in advance for your help.
Bruce Douglas -- BellSouth Telecommunications


Sun, 17 May 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Truncated Error messages using MS-ODBC for Oracle?

2. Oracle ODBC driver / Microsoft ODBC driver for Oracle

3. Oracle 7, ODBC, SQL*Net, VB4 and WANs

4. VB 4.0/SQL Retriever ODBC/AIX Platform/Oracle Database

5. Oracle 7, ODBC, SQL*Net, VB4 and WANs

6. VB3 and Oracle ODBC SQL Pass-through - speed quirk

7. 32-bit ODBC driver for Oracle via SQL*Net on Windows 95

8. Calling stored PL/SQL package in Oracle DB using ODBC

9. Transactions using VB 3.0/ODBC Q+E/Sql*NET TCP-IP/Oracle 7

10. Puzzling SQL Problem - ODBC to Oracle

11. Pass Data VB>SQL>ODBC>Oracle Database

12. Case Sensitivity - Oracle 7/ODBC Sql calls


Powered by phpBB® Forum Software