The online FAQ database contains hundreds of answers to frequently asked questions, articles on using our web server applications and other related technologies, and resolutions to common problems. If you are seeing an error message, be sure to try searching on the error message or error number that you are seeing.

Question When I try searching for something in the database, I never get any results from the search. I have tried searches where I know I should get something, but it still does not return anything.

Answer This is typically a JET related problem with some web server installations. You may need to change a configuration setting in the config file. Look for the setting gsSQLWildCardChar. For most servers, this setting will be set to:

  gsSQLWildCardChar = "%"

However, you may need to change the setting to the following alternate value:

  gsSQLWildCardChar = "*"