2. ASPRunnerPro General questions
  3. Error number -2147217900 on search query
This topic is locked

Error number -2147217900 on search query

 		6/30/2007 12:05:11 PM
ASPRunnerPro General questions
M
 minnydiva author

Hi There,
When I do a search query, standard or advanced I get the following error.
Does anybody know how I can correct it. I have taken some of the info out from the error which is not relevant.
Many thanks

Sharron
Error number -2147217900

Error description [Microsoft][ODBC Excel Driver] Undefined function 'upper' in expression.

URL myurl/sharron__list.asp

SQL query (I have taken some of this error out) From [sharron$] where (upper([sharron$].[Surname]) like upper('%Hoag%'))
Sergey Kornilov admin 7/1/2007

Sharron,
Excel is not a real database and many features simply won't work.

Import your database into MS Access and run ASPRunnerPro against it.
Contact me personally if need help importing Excel into MS Access.
M
 		minnydiva author 7/1/2007

Hi Sergey,
Ah right ok, that's fine. I am just using excel to setup a dummy database for my client. We shall be using MS Access eventually so then there shouldn't be any problems.
Many thanks

Sharron