Newbie Question

[racingcow]

Hello:

I am familar with SQL Server, but very new to progress. I am writing an ASP.Net application for a customer that uses an existing OpenEdge 9.1 database as its data store. I am using the MERANT ODBC driver as an interface to the database.

The database currently has a table that was created for me called "PageInfo". PageInfo contains a character field that is supposed to contain Html that will be rendered to the page.

Whenever I attempt to update the character field with more than 80 characters, I receive an error message that reads, "Character string is too long (8184)."

Can a character field be made to store an unlimited amount (or a very large amount) of text in Progress? Is a character field even the correct field type to use?

Any help would be greatly appreciated.

Thanks,
Dave

 

[MDaanje]

Hi Dave,

I've Looked up the message for you in Progress:

Character string is too long (8184)

An unexpected system error has occurred. Please do the following:
1. If the error occurred while running an existing application or
during database admin functions, the error may be due to a
hardware/system problem, r-code corruption, or data corruption.
Note what was processing during the time the error occurred.
Check your system error logs and Progress database log file for
any additional errors.
2. If the error occurred while running a new application or procedure,
try to reproduce and isolate the code that results in the error.
3. Search the on-line Progress knowledgebase for information on the
error. The kbase can be accessed via the Progress web site at:
http://www.progress.com or
http://www.progress.com/services/techsupport/online.html
4. If the above does not lead to resolution, please contact your
dealer (VAR) who sold you PROGRESS, or the Progress Technical
Support center for your region.

Hope you'll find what your looking for...
By the way Openedge is the name for Progress 10 so this can't be Openedge 9.1 dbase.

 

[Casper]

OR:

KB P7640:
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error (8184) when inserting records from an ODBC client
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Character
string is too long (8184) (-20152)
Using third-party application to add records to a Progress Database
via the INSERT statement.
CAUSE:
The data contained in the field is greater than the SQL_WIDTH.
FIX:
Increase the SQL_WIDTH of this field via the Data Dictionary:
Options > SQL Properties > Adjust Field Width.
Since 9.1D06, DBTool can be used to identify and fix SQL Width
problems.

Next time you better post question in SQL92 forum....

Regards,

Casper.

 

[mpowell_esq]

I am familar with SQL Server, but very new to progress. I am writing an ASP.Net application for a customer that uses an existing OpenEdge 9.1 database as its data store.

>>Indeed you are very new to Progress. Progress did not join the eclipse foundation until Version 10. Therefore OpenEdge was NOT released until v10.0, when the product was Progress OpenEdge. Once version 10.1 became realized the PSC product became OpenEdge 10.1