Filemaker Adv Server does not see SQL Views but Pro Adv does
Operating system version
Server 2008 32 bit
Description of the issue
I have an external ODBC connection running on my filemaker pro adv client running on windows 7 64 bit. it connects to an sql 2008 database. it connects to two tables on the sql machine that are views of other databases.
Tried the same thing on server adv and I do not even see the two tables, it shows me the system tables under the sql 2008 views, system tables folder???
makes no sense to me how it works fine on one and not the other ??
Steps to reproduce the problem
create a view of a sql 2008 table
connect it with the native ms windows 7 64bit odbc driver
validate the view in a local database running on filemaker pro adv
set up the same odbc drive on the server 2008 machine 32 bit with filemaker server adv
the same views do not appear for the external odbc connection in filemaker