I have been unable to get a Joiner working with a SQL Server table or view when a prefetch query is used. Here is my prefetch query:
select * from base_picklist where pfeature = 'all_base_features' and pcolumn = 'feature_status'
Checking the log, whenever I use the prefetch query, I see the following message:
MS SQL Server Reader: Opening `GDI_Temp' for read operation.
MS SQL Server Reader: Closing `GDI_Temp' . Read operation complete.
Opened table `JOINER-base_parcel:dbo.vw_base_picklist' for input with server type `MSSQL_ADO', server name `ESG-SQL', user name `fme', database name = `GDI_Temp';
Started SQL cache prefetch for table 'dbo.vw_base_picklist' with SQL statement 'select * from vw_base_picklist where pfeature = 'all_base_features' and pcolumn = 'feature_status''.
Module `MSSQL_ADO' API version matches current core version (3.1 20031010).
ADO-based Reader: Opening `ESG-SQL' for read operation.
ADO-based Reader: Connection failed. Connection string `[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'. Provider error `%2'.
Failed to open reader.
Finished SQL cache prefetch for table 'dbo.vw_base_picklist', which added 0 rows to the cache.
MS SQL Server Reader: Opening `GDI_Temp' for read operation.
Using Dynamic Reader $Revision: 17.1 $ ( $Date: 2006/01/06 17:33:15 $ ) with module MSSQL_ADO to read data from dataset `GDI_Temp'
However, if I remove the prefetch query, I get the following in the log:
MS SQL Server Reader: Opening `GDI_Temp' for read operation.
MS SQL Server Reader: Closing `GDI_Temp' . Read operation complete.
Opened table `JOINER-base_parcel:dbo.vw_base_picklist' for input with server type `MSSQL_ADO', server name `ESG-SQL', user name `fme', database name = `GDI_Temp';
MS SQL Server Reader: Opening `GDI_Temp' for read operation.
Using Dynamic Reader $Revision: 17.1 $ ( $Date: 2006/01/06 17:33:15 $ ) with module MSSQL_ADO to read data from dataset `GDI_Temp'
Is there something wrong with the format of my prefetch query?
Thanks
__._,_.___For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com.
Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
