1. Setup a DSN on the remote server
2. Then, In Your Application pane, go to Databases (which you probably already knew)
2. Click on the OLE DB Connection
3. For the Connection String box (see box below), type in your dsn, with the syntax of . . .
4. Click OK and it should work