Hi Guys,

I'm just new, so i hope its ok to post asking for support.

Our lead IT Guy is off on his holidays and i have a support problem.

This is the error showing below.

Kind Regards,
Joey

quote:

---

Server Error in '/' Application. Data type mismatch in criteria expression.

Description: An unhandled exception occurred during the execution of the current web request.

Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.

Source Error: Line 66: Catch ex As Exception Line 67: End Try Line 68: q.Fill(ds, tablename) Line 69: Return ds.Tables(tablename) Line 70: Source File: D:\HostingSpaces\ciaranmg\ckcarsales.com\wwwroot\App_Code\DAL.vb Line: 68 Stack Trace: [OleDbException (0x80040e07): Data type mismatch in criteria expression.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1003520 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +116 System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92 DAL.getDatatable(String query, String tablename) in D:\HostingSpaces\ciaranmg\ckcarsales.com\wwwroot\App_Code\DAL.vb:68 Default2.Page_Load(Object sender, EventArgs e) in D:\HostingSpaces\ciaranmg\ckcarsales.com\wwwroot\Showroom.aspx.vb:33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3614

---

Got into the ftp and into the file and changed it.

Thanks,

Joey