connecting to ODBC

[yehonatan]

I am trying to use php on one system to connect to another system that has ODBC sharing enabled. It seems that either the parameters I pass into odbc_connect (a php function) is incorrect or I don't have ODBC correctly enabled (can u just go to Edit->Sharing to enable ODBC? ... or do I need to install an additional ODBC driver?).

I use the following in my php script uses:

$DSN = "Driver=FileMaker Pro;Server=server.name;Database=the database.fp7";

$connection = odbc_connect($DSN, "username", "password")

or die("Couldn't connect to database");

(where server,database name, etc has been changed)

Please help me figure out what is wrong. Thanks!