ESS with SQL SERVER

[Emmanuel N. Batzakas]

Hello everybody.

I have FMPRO 9 ADVANCED and SQL SERVER 2000 which is running on a WIN2003 Server.

I've setup the DSN for a specific DB in SQL SERVER, but when I try to bring the Shadow table to filemaker relationships graph I can see the Tables of SQL SERVER but not the fields inside the table.

Pls Help

Edited August 1, 2008 by Guest

[mr_vodka]

When you first set it up it should have asked for to select field(s) for a unique record key. Did it do that at least?

Have you double checked your settings on the SQl Server side?

[Emmanuel N. Batzakas]

Dear John.

I've checked the SQL server side setting, I gave all the needed permissions for "fmusr", and also I test this with windows authentication, but still the same problem.

Note that I can import records from the same DSN.

Thank you