• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 808
  • Last Modified:

Connect to filemaker from MS access with ODBC driver

Trying to link FileMaker table with ODBC driver using MDAC 2.6, but get error [DataDirect][ODBC SequeLink driver][SequeLink Client]TCP/IP connection refused.  When setting up the connection i entered the IP for the host machine, port 2399, and the filename for the server data source.
0
ADS_TECHMAN
Asked:
ADS_TECHMAN
  • 4
  • 3
1 Solution
 
lesouefCommented:
you also need a user/passwd whihc is valid in the filemaker database. when you test the ODBC DSN is it OK?
0
 
ADS_TECHMANAuthor Commented:
I don't see where to enter the user name and password.

Please advise, thanks!
0
 
ADS_TECHMANAuthor Commented:
To show you what I mean by not being able to add a user name and password, this is what I see (see attached file):
Picture-1.png
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
lesouefCommented:
when you click test connect, it should prompt for it.
Did you enable file/sharing/odbc in the filemaker database? and also a set of users if not all?
Lasf bit: is the Filemaker file open?
0
 
lesouefCommented:
forgot to mention the XP firewall if you use it, but that prompt a msg for port 2399 access...
0
 
lesouefCommented:
so, what was wrong?
0
 
ADS_TECHMANAuthor Commented:
The file needed sharing turned on
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now