fetch data via python and ODBC
we have filemaker server 11 advanced running on a windows 7 pro box. i'm writing a program that needs to access databases VIA python and ODBC. i cant seem to get it to connect, i think i may have the name of the driver wrong.
this hangs for a while and then gives me the following error:
Error: ('08S01', '[08S01] [FileMaker][FileMaker] Failed to connect to listener (2) (65535) (SQLDriverConnect)')
i have double/triple checked the login info, and even tried using a different account. ive also completely turned off the firewall on the hosting computer to no avail.
the pyodbc library basically just passes SQL commands to whatever database. im not incredibly familiar with SQL so maybe the problem is in my syntax there?
Any help would be greatly appreciated.