D
Dawie van Niekerk
Guest
I'm importing data from a progress database.
I am getting the following error:
Progress openedge wire protocol column in table has value exeeding its max length or precision
Is there a way to specify a specific length of the select column's data in the select statement?
For example: SELECT SUBSTRING(EMAIL,15) FROM SQL92.PROGRESSTABLE
SUBSTRING does give me the substring of a valid field value, but still fails with the above error when the dataset hits the "dirty" row.
I don't have access to the Progress database, so I can't run the progress DBTool to fix data.
The same kind of question was asked here, but the solution never posted. Can I make an IDataReader ignore column length definitions?
Continue reading...
I am getting the following error:
Progress openedge wire protocol column in table has value exeeding its max length or precision
Is there a way to specify a specific length of the select column's data in the select statement?
For example: SELECT SUBSTRING(EMAIL,15) FROM SQL92.PROGRESSTABLE
SUBSTRING does give me the substring of a valid field value, but still fails with the above error when the dataset hits the "dirty" row.
I don't have access to the Progress database, so I can't run the progress DBTool to fix data.
The same kind of question was asked here, but the solution never posted. Can I make an IDataReader ignore column length definitions?
Continue reading...