Query Driven Doc Gen fails

[philchudley]

Not sure if this is a general issue but:

I have a master /model document model where the model document is driven by a SQL query to get a set of elements in a specific sequence. The query works just fine and it returns the classguid and classtype

If I generate the document using an ODBC connection it works just fine. BUT if i connect via PCS the query simply does not run and I end up with an empty document!

If this is an issue it really needs to be sorted, there appears to be quite a few things that work with ODBC connections but not with PCS connections.

Phil

[OpenIT Solutions]

Hi Phil,

I have lots of SQL fragments in my docs and build docs using scripts/sql - all seems fine via PCS (and direct OLE DB connection). Only difference by the sounds of things is that we are using OLE DB with the PCS database connection not ODBC. But if PCS is working - ie you can view content in WebEA etc... then this is unlickly to be the issue...