Can't access an ODBC database
I'm trying to access SQL server with FileMaker Pro 10, using an ODBC driver. I've tried both OpenLink and Actual Technologies drivers. The drivers themselves seem to work fine, since while I'm creating a user or system DSN within their interface, I have no problems logging in and seeing the databases on the SQL server.
But when I try to access the database within Filemaker, it keeps asking for a login and rejecting any credentials I give.
I'm running Filemaker 10 on Mac OS X 10.5.6. I also am trying this with Filemaker Pro 7 and am getting the same problem. This happens whether I try to connect via opening a file or importing records.