Lookups with Visual FoxPro

Published Mar 25 2019 02:03 PM 218 Views
Not applicable
First published on MSDN on Mar 04, 2008

Here's a quick tip from a couple other members of the SSIS team, Da Lin and David Noor.

If you have a lookup component using partial cache mode using a Visual FoxPro oledb provider to connect to your reference table, be sure to change the OLE DB Services setting in the connection manager to something other than "default" or "enable all".

If you don't change this setting, you'll get the following error at runtime:

An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Visual FoxPro"  Hresult: 0x80040E46  Description: "One or more accessor flags were invalid."

%3CLINGO-SUB%20id%3D%22lingo-sub-387392%22%20slang%3D%22en-US%22%3ELookups%20with%20Visual%20FoxPro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-387392%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Mar%2004%2C%202008%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EHere's%20a%20quick%20tip%20from%20a%20couple%20other%20members%20of%20the%20SSIS%20team%2C%20Da%20Lin%20and%20David%20Noor.%3C%2FP%3E%0A%20%20%3CP%3EIf%20you%20have%20a%20lookup%20component%20using%20partial%20cache%20mode%20using%20a%20Visual%20FoxPro%20oledb%20provider%20to%20connect%20to%20your%20reference%20table%2C%20be%20sure%20to%20change%20the%20OLE%20DB%20Services%20setting%20in%20the%20connection%20manager%20to%20something%20other%20than%20%22default%22%20or%20%22enable%20all%22.%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99365iF29E75593B75F1AE%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EIf%20you%20don't%20change%20this%20setting%2C%20you'll%20get%20the%20following%20error%20at%20runtime%3A%3C%2FP%3E%0A%20%20%3CP%3EAn%20OLE%20DB%20record%20is%20available.%26nbsp%3B%20Source%3A%20%22Microsoft%20OLE%20DB%20Provider%20for%20Visual%20FoxPro%22%26nbsp%3B%20Hresult%3A%200x80040E46%26nbsp%3B%20Description%3A%20%22One%20or%20more%20accessor%20flags%20were%20invalid.%22%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-387392%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2004%2C%202008%20Here's%20a%20quick%20tip%20from%20a%20couple%20other%20members%20of%20the%20SSIS%20team%2C%20Da%20Lin%20and%20David%20Noor.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-387392%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 25 2019 02:03 PM
Updated by: