SEO

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

I suggest you go to 'www.progresstalk.com' (http://www.progresstalk.com
and post to the SQL-92 forum. You also need to provide the Progres
info i.e O/S, version. You might also check ou
http://forums.datadirect.co

--
cecsn
-----------------------------------------------------------------------
cecsno's Profile: http://www.progresstalk.com/member.p...nfo&userid=423
View this thread: http://www.progresstalk.com/showthre...?threadid=7195

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

cecsno wrote:

> I suggest you go to 'www.progresstalk.com' (http://www.progresstalk.com)
> and post to the SQL-92 forum. You also need to provide the Progress
> info i.e O/S, version. You might also check out
> http://forums.datadirect.com


I didn't know there was site like this. I'll do that right away.

Thanks,

Tom.