setting up an odbc dsn to access filemaker 10 file

[TASC]

Hi all,

I am trying to figure out how to setup a dsn to give other applications access to the data in my filemaker 10 database (all on the same machine, local workstation). I have already setup the filemaker file to give specific users access through odbc (file, sharing, odbc/jdbc, and extended privileges)

When I go to the Microsoft ODBC data source setup utility, I have the following Filemaker odbc drivers:

Filemaker oracle 8 driver

filemaker pro

filemaker sql server driver

filemaker text driver

I have tried all but the text driver and I get an error accessing. Which is the correct one to use, or am I totally missing something?

Thanks for your help in this matter.

Constance

[mr_vodka]

I would start by reading through this.

http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf

[TASC]

Thanks, that is exactly what I needed.

I tried to setup a linked table in access but I get the error ODBC CALL FAILED and in the table I get all the colunms with #NAME?. Does anyone know why this would be?

many thanks again for your help

Constance