HOW TO Call a Parameterized Query to a FoxPro Database using a DTS Package

• becpow

  SSC Rookie

  Points: 35

  More actions

  August 16, 2004 at 2:17 pm

  #59720

  Hello everyone.

  I'm trying to query a FoxPro db (5.0) using SQL Server 2000 dts package.  My query has parameters set up in the where clause.  I keep getting this error:

  Error Source : Microsoft OLE DB Provider for ODBC Drivers

  Error Description : Provider cannot derive parameter information and SetParameterInfo has not been called.

  I've tried using both VFPODBC.DLL (6.0) & VfpOleDB.dll (8.0) as the data source and neither one of them work.  Will I not be able to use a parameter in my query?  If I can't, what else should I use? 

• Tom Hamilton-126456

  Mr or Mrs. 500

  Points: 527

  More actions

  August 17, 2004 at 10:57 am

  #519402

  Have you used Global Variables set from a Configuration table or prompted from the DTS package/ActiveX and declare the parameters