Parameter <name> specified where a database name is required. (Error 3217)

  • Article

You created a parameter query that specifies an invalid parameter type. The following example produces this error:

  PARAMETERS Param1 Text;

  SELECT CustomerID

  FROM Customers IN Param1;

  Param1

is a text parameter, but the FROM clause requires a database parameter.

Change the parameter type from Text to Database, and then try the operation again.