Mark, Thanks for the reply. I'm downloading build 4167 right now.
Carl --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Just to let you all know - this issue was fixed yesterday and appears > in today's beta build #4165, now on our web and ftp sites > > ftp.safe.com/fme/beta/fme4165.exe > > ...and remember, details of all new features and fixes can be found in > the "What's New" file: ftp://ftp.safe.com/fme/beta/whatsnew.txt > > Mark > > > --- In [email protected], "mark2atsafe" <mark.ireland@> wrote: > > > > 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 > > support@ http://www.safe.com > > Solutions for Spatial Data Translation, Distribution and Access > > > > --- In [email protected], "cmvonner" <cmvonner@> 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/
