Thomas Scheiderich <tfs@deltanet.com> wrote in
news:40A20D3E.1070904@deltanet.com:

> I am trying to import some of the data in our vantage database to our
> Sql Server system to run reports and allow our other offices access to
> the data without letting them have access to the actual data. I have
> been using DTS to do the move.
>
> The problem is that as we were copying the tables, some of the tables
> were giving us errors from the Merant ODBC driver that said something
> to the effect of:
>
> "Column Description in JobAsmbl has value exceeding it max length or
> precision"
>
> We are getting this from the Progress side that we are trying to read.
> How can that be? I would understand if we were moving data to
> Progress, but not from Progress.
>
> I tried to solve the problem by doing the following:
>
> select "BuyIt", substring(PurComment from 1 for 4) , "Ordered"
> ,"BackFlush" ,"EstScrap" ,"EstScrapType", "FixedQty" from
> "PUB"."JobMtl"
>
> but was getting an error:
>
> Syntax Error (7587) from ODBC Driver
>
> I also found that I would pick the Merant ODBC driver for the
> connection object, but it would change to "Other(ODBC Driver)". Not
> sure why.
>
> We need to find out how to solve this problem as we are behind on this
> project and have some deadline to reach.
>
> Thanks,
>
> Thomas Scheiderich
>

The issue here is that the Progress database (4GL side) allows fo r
fields that are variable in length. There is a tool called SQLWidth
which will run against the database and report (and fix if required) any
fields that contain data that is longer than the SQL width defined for
that field. The executable is called dbtool, and the command is: dbtool
db-name which will give you a menu..

Head to http://esupport.progress.com for more information.

Kevin