AnsweredAssumed Answered

How to link DxDatabook to SAP R/3 Database for SQL ODBC queries

Question asked by stephen.faghy@commagility.com on Dec 20, 2017
Latest reply on Jan 3, 2018 by stephen.faghy@commagility.com

I'm trying to get DxDatabook to view existing data fields store on SAP, by setting up an ODBC connection to use SQL queries. I'm using the 32 bit version of the ODBC Data Source Administrator as both the Mentor and SAP software are 32 bit.

I'm also trying to login with as specific username and password that has been created to get read-only access.

But when I attempt to make the connection I get this message from the Microsoft SQL Server Login

"Connection failed:     SQLState: '28000'     SQL Server Error:18456     [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '****'

 

However, if I try a similar set-up from an Excel spreadsheet (Get External Data) the username and password work, and I can then query SAP.

 

Has anyone had this problem, and is there a solution?

Outcomes