FoxPro OLEDB Driver - pass parameters

Hi,

Does anyone know if the VisualFoxPro 9.0 OLEDB driver supports parameters Trying to pass parameterised queries from SSIS results in the error reported below, which implies it does support parameters, but that SSIS is not calling the driver properly somehow.

Regards,

Richard

-----------------------------------------------

Error MsgBox:

TITLE: Microsoft Visual Studio
------------------------------

Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.

------------------------------
ADDITIONAL INFORMATION:

Provider cannot derive parameter information and SetParameterInfo has not been called. (Microsoft OLE DB Provider for Visual FoxPro)




Answer this question

FoxPro OLEDB Driver - pass parameters

  • nickc

    This conversation is taking place on the newsgroup "microsoft.public.fox.vfp.dbc", thread "Passing parameterised SQL statements to FoxPro OLEDB"

    There is nothing wrong with the FoxPro driver, you can pass parameters OK from a native VB project

    So it looks at the moment like this may be a BUG in SSIS.

    Comments

    Will keep you posted,

    Rich


  • FoxPro OLEDB Driver - pass parameters