AnsweredAssumed Answered

fetch data via python and ODBC

Question asked by ccban on Oct 14, 2013
Latest reply on Oct 29, 2013 by JonJ

Title

fetch data via python and ODBC

Your post

     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.

      

     pyodbc.connect('DRIVER={FileMaker ODBC};SERVER=192.168.1.100;DATABASE=database.fp7;UID=username;PWD=password')

     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.

Outcomes