AnsweredAssumed Answered

Import ODBC Data Source - user/password

Question asked by tomn on Feb 11, 2011
Latest reply on Jan 30, 2012 by msawyer

Title

Import ODBC Data Source - user/password

Post

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.".

Any ideas?

---

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.

Outcomes