Here's my query. I'd like to give the description field an alias to something like "uomdesc".
select * from openquery(linkedservername, 'select termcode, description as "uomdesc" from terms')
Here's the error I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]** Invalid statement. (254)]
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare:
repare returned 0x80004005: ].
I'm using Progress 9.1C, SQLServer2000, and Merant 3.6 Progress Driver.
Any help would be greatly appreciated.
select * from openquery(linkedservername, 'select termcode, description as "uomdesc" from terms')
Here's the error I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]** Invalid statement. (254)]
[OLE/DB provider returned message: [MERANT][ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare:
repare returned 0x80004005: ].I'm using Progress 9.1C, SQLServer2000, and Merant 3.6 Progress Driver.
Any help would be greatly appreciated.