Hello, I have a client that is currently using the latest version of Business Works 2013, fully patched. The server OS is SBS2011, client workstations run Win7x64. They do not have a current support contract (against our recommendation). I have knowledge base access and have found my issue, but the 'resolution' is to call support, who will not help me without a valid support contract. Basically, they know how to fix the issue, but do not list the how to in the knowledge base.
I have an Access database that pulls data from the Business Works database through the ODBC connection / DSN connection. I have verified that the user name (Manager) that I am using can log in with the password. When I go to test the connection, I received "Invalid User ID Specified". I have tried other users, but it is my understanding that I have to use the Manager account.
Things That I Have Tried:
- Disabling firewall and AV (client and server, same results)
- I have deleted and recreated the DNS/ODBC connection (client and server, same results)
* Client and server, mean that I tried this on the server itself and from a client workstation
Sage Knowledge base article ID: 32007
Description: Error: "Invalid user ID specified" when trying to create an ODBC connection
Cause: Damaged or missing .DDF files
Resolution: Contact Sage Customer Support at 800-447-5700 to repair or replace the missing/damaged .DDF files.