Hi there, This looks like a fairly serious problem with FME - it's been filed with our developers with a P1 (top) priority and I'll let you know when a fix is available.
In the meantime, I don't see much of a workaround I'm afraid. Can you set up a database view with the where clause in? Perhaps then FME would let you prefetch "select * from view" - because it seems to be the where clause we are stumbling over. Regards, Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "cmvonner" <[EMAIL PROTECTED]> wrote: > > > 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. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
