Hi there,

I am trying to use ExecReader to retrieve records, works fine when there is no input parameters but once I call a stored procedure with input parameters I get following message Line 1: Incorrect syntax near '_Search_Provider_ZipCode'.

Dim DR As IDataReader = Me.ExecReader("_Search_Provider_ZipCode ", Me.DatabaseKey, Conn, Me.CreateParameter("@ZipCode", zipCode))

         at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at OakLeaf.MM.Main.Data.mmDataAccessBase.ExecReader(String command, IDbConnection& connection, IDbDataParameter[] dataParams)
   at OakLeaf.MM.Main.Business.mmBusinessObject.ExecReader(String command, String databaseKey, IDbConnection& connection, IDbDataParameter[] dataParams)
   at ITFDC.Business.Locations.GetProvidersInfobyZipcode(String zipCode) in C:\ITFDCWCF\ITFDCBusiness\ITFDCBusiness\Locations.vb:line 118
   at ITFDC.Windows.BusinessForm1.Button1_Click(Object sender, EventArgs e) in C:\ITFDCWCF\ITFDCWindows\BusinessForm1.vb:line 52