TSQL Openrowset error with Timberline ODBC Sage 300 CRE

We are trying to Connect to Sage 300 CRE.

The Timberline Driver ODBC has been installed.

When we try to execute an SQL statement:

SELECT a.* 

FROM OPENROWSET('MSDASQL','Driver=Timberline Data;
DSN=Timberline Test;
DBQ=
UID=x;
PWD=abc;
CODEPAGE=1252','SELECT
*
FROM [APM_MASTER__VENDOR]
')
AS a

We receive the following message:

ERROR:

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Sage][SQLEngine] (31740) Table or view not found: \server\Timberline Office\Data\TSDATA..APM_MASTER__VENDOR".
Msg 7321, Level 16, State 2, Line 25
An error occurred while preparing the query "SELECT
*
FROM [ARM_MASTER_CUSTOMER]
" for execution against OLE DB provider "MSDASQL" for linked server "(null)".

0 answers