FileMaker DSN Configuration
Here's the goal: Connect an Excel 2007 worksheet to a FM Pro 7 database that is accessed remotely from a FM Server 11 Advanced.
MS Excel 2007
FM Server 11 Advanced
FM ODBC driver 11.3.81
I am brand new to ODBC and still green when it comes to FileMaker. I believe I am doing everything correctly, but it is not working.
I go through the DSN configuration, entering the IP address, Database, etc. At the end, I test it and it is successful.
However, when I click "Done" and enter the same username and password, I get this error.
If anyone can shine some light on this, or point me in the right direction, I'd greatly appreciate it. I've spent the last few days scouring the FM forums, Google, Yahoo, Excel forums, and everything I could think of, but found nothing related to this specific occurrence. Maybe it is a user error, but I'm dumbfounded. Please help.