I am trying to connect from MSSQL to OE 11.3 using the DataDirect ODBC connector. I tried following the Progress KB article for creating an "Implicit SQL user that does not need a password" (P125338) and "How to configure a SQL connection without maintaining a user list" (P69145). Neither solution seemed to work and I'm trying to find out what I did wrong.
Steps I've taken:
I've created a user in _user and verified I can connect via ODBC and query the MFGPRO database from sqlexp. This tells me my ODBC connection is working.
I've created a testdb from empty and followed the steps from the KB (add sysprogress - connect via SQL - grant privileges to "implicit user" user1 - remove sysprogress) and tried to attach to the database as user1. Authentication failed.
The OE databases are running on RHEL6 (if that matters) and I'm testing my connections from the same server and from a Windows Server 2012 box.
Steps I've taken:
I've created a user in _user and verified I can connect via ODBC and query the MFGPRO database from sqlexp. This tells me my ODBC connection is working.
I've created a testdb from empty and followed the steps from the KB (add sysprogress - connect via SQL - grant privileges to "implicit user" user1 - remove sysprogress) and tried to attach to the database as user1. Authentication failed.
The OE databases are running on RHEL6 (if that matters) and I'm testing my connections from the same server and from a Windows Server 2012 box.