Export (0) Print
Expand All

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

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.



Community Additions

Show:
© 2015 Microsoft