rleinen

Specify ODBC Data Source Error with Execute SQL Step

Discussion created by rleinen on Oct 30, 2017
Latest reply on Oct 31, 2017 by beverly

On a Mac using FM Pro Adv 16, I am connecting to SQL Server database using the Actual Technologies ODBC driver. I can connect to SQL tables and views via the manage databases screen. But when I try to run sql via the "Execute SQL" script step I get the following error after specifying the ODBC data source and entering in the username and password.

 

"The account and password you entered cannot be used to access this file. Please try again."

 

When I do this same thing on a windows machine running FMPA16 it works just fine. Any help here would be much appreciated.

Outcomes