Filemaker Pro Advanced 11 asking for user/pass when trying to open ODBC Data Source File Type
I have Quickbooks 8 on one machine, and using FMP 11 to access the database from another machine. A plugin for QB POS is installed on the computer. From my computer I select open, then file type as ODBC Data Source. Another dialog box appears and I select the QODBC Driver for QuickBooks POS, and then for some reason it asks me for a username and password. The data base file has neither. I tried admin, Admin, leaving it blank, and nothing works. Anyone got a solution?
Computer with QB POS, XP Pro
Computer with FM Pro 11, Windows 7 32bit
Thanks for posting.
It looks like Quickbooks requires that an ODBC user be created for ODBC connections. Here's a Quickbooks article that I found on this: