The linked server setup is fine.
The only problem is trying the Progress Arrays decoded into a SQL Server select.
I have select only access onto the Progress DB so I cant change anything on that end, it all has to be done through the linked server.
It a strange twist of fate, SSIS ( DTS...
It works on an ODBC connection ( without the 4 part table prefix ), but when used in SQL SERVER I get error..
Msg 195, Level 15, State 10, Line 2
'PRO_ELEMENT' is not a recognized built-in function name.
Hi,
I'm a first timer on progress and need some help getting array data into SQL Server 2005.
I've got it all connected up as a linked server but need to know the syntax to get the PRO_ELEMENT call out to the Progress DB.
I've tried :
SELECT
{ fn PRO_ELEMENT ( "FLD",1,1) } AS col_val
from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.