Last post Jan 29, 2019 07:32 AM by Brando ZWZ
Jan 18, 2019 03:54 PM|KeystoneKid|LINK
I am trying to retrieve data using a datasource that is a Query in an Access database. The query includes several Access tables and one table from a SQL database that is linked into the Access database using ODBC. It runs successfully in testing on my machine,
but fails when deployed to the production environment with an error "No value given for one or more required parameters". To avoid confusion, I am not passing any parameters nor does the query require any. The error goes away as soon as I remove the SQL table
from the query, proving it relates to the SQL connection, however I need to reference data from that table.
Any ideas would be appreciated. If there is another way to join Access and SQL tables in a single query/view I am open to other approaches.
Jan 19, 2019 01:53 AM|oned_gk|LINK
Seem like you pass empty data in the parameters, try changing this two parameter properties :
DefaultValue to set to spesific value such as 0 for empty value
Enable/Disable converting empty value to null option
Jan 19, 2019 04:19 PM|KeystoneKid|LINK
As I mentioned, there are no parameters in the query. I believe that error message is misleading, the problem has to do with the fact that I am querying an Access database which in turn has linked SQL tables.
Jan 29, 2019 07:32 AM|Brando ZWZ|LINK
It runs successfully in testing on my machine, but fails when deployed to the production environment with an error "No value given for one or more required parameters".
Could you please share the details codes and connection string you have used in your application on production environment?
I guess there are something wrong with your connection string or config setting.