Kbase P122471: Cannot insert CLOB/BLOB greater than 2MB into database using ODBC connection.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/6/2010 |
|
Status: Verified
SYMPTOM(s):
Cannot insert CLOB/BLOB greater than 2MB into database using ODBC connection.
C# Program using ODBC driver to insert BLOB into the database
Object Not Set error is received
Size of BLOB is greater than 2MB
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1B
Progress OpenEdge 10.1A driver
Progress OpenEdge 10.1B driver
All Supported Operating Systems
CAUSE:
Although the maximum size of a CLOB/BLOB is 1GB the ODBC driver, by default, limits the size to 2MB. This is adjustable by the user either through the registry or by sending a parameter to the connection string.
FIX:
To increase the default value of 2MB you need to modify the DefaultLongDataBuffLen value from its default of 2048 (2MB) up to whatever you need.
This can be done by modifying the value of the DefaultLongDataBuffLen key for the DSN in the registry from its default value of 2048 (2MB) to whatever you need.
If modifying the registry will not work for you, you can simply add "DefaultLongDataBuffLen=<n>" to your connection string in 10.1A and higher to override the default value of 2048 (2MB).