Unanswered: Passing datetime parameters to MS Query
I'm trying to pass a parameter of datetime format to Ms Query, but I keep getting the following error:
[INTERSOLV][ODBC SQL Server driver]Inconsistent descriptor information.
This occurs when I create a new databasequery in Ms Query and try to enter a parameter of datetime format as one of the selectioncriteria in the query. The query does actually run in Ms Query, but when I try to pass the data back to Excel, the mentioned error occurs and the query is lost.