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, 200817 yr by Guest

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?

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