You need only DSN name. Did you select provider "Microsoft OLE DB Provider for ODBC Drivers" ?
I use security setting simply always use "Admin" for remote login(FM), not use login mapping for test.
Anyway, FM SQL don't support "complex querying"
when creating the linked server (via sql manager) there is another option called "security", its in here that you enter the FM username & password.