SQL String of 922-926 characters fails using ADO and ODBC 
Author Message
 SQL String of 922-926 characters fails using ADO and ODBC

I have a SQL command that is going to a DB2 databse on a VM system via
ADO and ODBC(think I can get more acronyms in here?)in a VB6 program.
All SQL commands work fine unless the length of the command is 922-926
characters. This seems impossibly odd to me, but it's so unique that if
it is a problem someone else must have seen it before...anyone?
Now, some interesting tidbits. If I link the DB2 tables to an access
database(using ODBC) and pass the SQL to the access database via ADO
instead of directly to VM and DB2 the error does not occur. This might
eliminate ADO and ODBC as problems, but just in case, I'm posting to
this group in the hopes that one of you has seen this oddity before.
 In addition, if I go directly to VM and execute the same query(not from
code but from the VM interface) the error does not occur and the command
excutes with no problems.
One last bit, the DB2 connections are TCP/IP.

Thanks In advance...

Jonathan Herr
Jonathan.R.Herr AT lmco.com

Wed, 19 Feb 2003 00:25:12 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL Server (ADO) Can't Insert Strings Longer Then 30 characters

2. ADO fails to find string from SQL

3. ADO control works while ADO Connection String fails

4. Why ISAM error using Access and unbound ADO controls with sql string connection

5. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

6. ODBC--call failed \ SQL Server

7. sql statement fail with ODBC dBase

8. ODBC Call Failed / SQL server

9. SQL String limited to 256 characters

10. SQL Strings appear to truncate to 255 characters

11. Maximum Length of characters for SQL statement (or string)

12. How to exceed 255 characters in adodb SQL string


Powered by phpBB® Forum Software