8 Replies Latest reply on Jan 30, 2012 10:31 PM by msawyer

    Import ODBC Data Source - user/password

    tomn

      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.