I'm trying to create an MFD from a SQL Server instance (for a test database instance) and getting this error. It sounds like a DBMS permissions issue with my ID. DBA is a little perplexed. He's set the ID up in this test system the same as the production system (which works fine). Still errors. Any idea?

(FOC1400) SQLCODE IS 8624 (HEX: 000021B0) XOPEN: 42000
: Microsoft OLE DB Provider for SQL Server: [42000] Internal Query Process
: or Error: The query processor could not produce a query plan. For more i
: nformation, contact Customer Support Services.
(FOC1406) SQL OPEN CURSOR ERROR.

BTW, it's using a Named Instance in SQL Server. We have other data providers set to use named instances with no problems.