Help! I'm trying to set up ODBC on FMP 7. Heres what I did: Installed MDAC 2.8, the database is on the local machine, the odbc sharing is enable for All users, I'm using port 2399, Network sharing is also enable but I dont think it has anythign to do with ODBC.

I get error 2306 "[datadirect][ODBC Sequelink driver][sqequelink] TCP/IP error, connection refused" when I use 127.0.0.1, localhost or the ip address of the machine in the "SequeLink Server Host:" field.

Additional note: I used MySQL to create the same database and was able succesfully do a test connection and prcoess queries via ODBC, so I don't think is my machine.

Please point me at the right direction.

Joe

OOPS I feel like a dummy my database wasn't up, thats why I was getting the TCP/IP error. I am able to connect to my database using either localhost or 127.0.0.1 but not with the machines ip address(150.198.131.45) I get a 3061 error "[DataDirect][ODBC SequeLink Driver][sequeLink Server]Authorisation failure." (Yes, they did spell authorization with an "s")

Can someone please point me at the right direction? Again I'm able to do this on an MySQL setup on the same machine so the ip address is correct and is not an issue.

Thank you

Joe

sigh... i am having the exact same problem. i setup everything according to the documents included in the xDBC folder, and i can only connect to localhost... not remote with an IP address..

it gives me the same error u mentioned above!!

can someone help?

p.s. windows 2003 enterprise server

I have the same problem and from what I found out, it appears that the Filemaker Server 7 doesnt work with ODBC, and that we have to use Filemaker Server Advanced. I too can take a database from my server put it onto the desktop and it works fine. But I cannot link to any databases on Filemaker server.

If someone can tell me a better way .. go ahead

I am having the same SequeLink Error when attempting to connect to FileMaker Pro 7 via ODBC. ODBC seems to work when using localhost, but not when you use the IP of the server.

Does anyone have any solutions for this? It seems no-one has responded yet...

Brad

See page 8 of 'ODBC and JDBC Developer's Guide'.

--

You can use FileMaker Pro to host a FileMaker database file as a data source, sharing your data with client applications using ODBC and JDBC. FileMaker Pro allows up to five connections and supports local access (same computer) only.