Recent content by pxbaker

  1. P

    Using PRO_ELEMENT in a SQL Server linked server

    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...
  2. P

    Using PRO_ELEMENT in a SQL Server linked server

    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.
  3. P

    Using PRO_ELEMENT in a SQL Server linked server

    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...
See more
Top