Using where condition in Linked server with ms access in sql server.
-
Hi How to write a where condition in the OPENQUERY to get data from ms access using linked server. select * from openquery(AccessDB,'select * from TblEmp where EmpPK=1'). This query show the following error message " OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB" returned message "No value given for one or more required parameters.". Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "select * from TblEmp where EmpPK=1" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB". " With out where condition its working fine Thankyou YPKI
-
Hi How to write a where condition in the OPENQUERY to get data from ms access using linked server. select * from openquery(AccessDB,'select * from TblEmp where EmpPK=1'). This query show the following error message " OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB" returned message "No value given for one or more required parameters.". Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "select * from TblEmp where EmpPK=1" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB". " With out where condition its working fine Thankyou YPKI
-
Hi How to write a where condition in the OPENQUERY to get data from ms access using linked server. select * from openquery(AccessDB,'select * from TblEmp where EmpPK=1'). This query show the following error message " OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB" returned message "No value given for one or more required parameters.". Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "select * from TblEmp where EmpPK=1" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AccessDB". " With out where condition its working fine Thankyou YPKI
Access gives you the error message "No value given for one or more required parameters." when you specify a non-existent column name. It assumes that it is a query parameter and complains that its value has not been supplied. Check if the TblEmp table in the Access database contains an EmpPK column. Most probably, it does not. You might have misspelled the column name.