Accessing data through MSSQL linked server from progress install

Yahoo Archive
1
Benoit



Try adjusting the SQL width of the column from progress Data Dictionary
to a value of 28 or below.

That should then interpret the data type correctly



Regards,

Stephen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of NigelK
Sent: 11 February 2010 11:38
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Accessing data through MSSQL linked server from
progress installation






I tried your command and got the same error - and I know my Linked
Server setup is working as I have a job running each night to pull
Progress data into SQL.

I don't have that field included in the job, though, so I'd never
spotted the problem.

The command below works but, to use it, you may be stuck with specifying
each individual field that you want to pull over:

SELECT * FROM OPENQUERY(PROGRESS, 'select cast(reprate1 as decimal) from
pub.orderdtl)

HTH,

Nigel.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"benoit.marquez" <benoit.desjardins@...> wrote:
>
> I am trying to read data from a Progress installation of Vantage using
MSSQL linked server. However I keep getting the following type of
errors.
>
> Here is my query statement:
> SELECT *
> FROM OPENQUERY(lk_traindb, 'select * from pub.orderdtl') AS
derivedtbl_1
>
> Here is the error message I get:
> Msg 7354, Level 16, State 1, Line 1
> The OLE DB provider "MSDASQL" for linked server "lk_traindb" supplied
invalid metadata for column "RepRate1". The precision exceeded the
allowable maximum.
>
> Many thanks
>
> Benoit
>





[Non-text portions of this message have been removed]
2
I am trying to read data from a Progress installation of Vantage using MSSQL linked server. However I keep getting the following type of errors.

Here is my query statement:
SELECT *
FROM OPENQUERY(lk_traindb, 'select * from pub.orderdtl') AS derivedtbl_1

Here is the error message I get:
Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "lk_traindb" supplied invalid metadata for column "RepRate1". The precision exceeded the allowable maximum.

Many thanks

Benoit
3
I tried your command and got the same error - and I know my Linked Server setup is working as I have a job running each night to pull Progress data into SQL.

I don't have that field included in the job, though, so I'd never spotted the problem.

The command below works but, to use it, you may be stuck with specifying each individual field that you want to pull over:

SELECT * FROM OPENQUERY(PROGRESS, 'select cast(reprate1 as decimal) from pub.orderdtl)


HTH,

Nigel.


--- In vantage@yahoogroups.com, "benoit.marquez" <benoit.desjardins@...> wrote:
>
> I am trying to read data from a Progress installation of Vantage using MSSQL linked server. However I keep getting the following type of errors.
>
> Here is my query statement:
> SELECT *
> FROM OPENQUERY(lk_traindb, 'select * from pub.orderdtl') AS derivedtbl_1
>
> Here is the error message I get:
> Msg 7354, Level 16, State 1, Line 1
> The OLE DB provider "MSDASQL" for linked server "lk_traindb" supplied invalid metadata for column "RepRate1". The precision exceeded the allowable maximum.
>
> Many thanks
>
> Benoit
>