Import ODBC Data Source - user/password
I'm trying to import from an AccountEdge for Windows database (as well as MYOB Premier - uses the same driver) via ODBC. I've created a data source with their ODBC driver and can successfully connect to it and read data via Excel and Access as a test. The datasource has my user and password of my AccountEdge database. I can read with this setup using other apps but with Filemaker, I'm prompted for my user/pw which is odd since that's stored in the DSN datasource and other apps don't ask me to do this.
After entering in my correct login, I get the error... "The account and password you entered cannot be used to access this file. Please try again.".
Forgot to mention, that I have done this years ago with Filemaker and MYOB Premier successfully and I believe it accepted the User/PW back then.