This topic is locked

ASP Error -2147217904

3/16/2006 1:43:24 PM
ASPRunnerPro General questions
T
tanya_ray author

One of our departments had a working ASP interface for their database, but now they're getting the following error:
Error number -2147217904

Error description [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

SQL query select [Book ID#], [Author/Editor], [Title], [Publisher/Year], [Location], [Category], [Key Words], [Status], [code] From [Library] where (1=1 and [Author/Editor] like 'th%')
I checked the database and all the fields are still there and have the same names. The database name has not changed. Where else should I look??? What could have happened?

Admin 3/17/2006

Hi,
Please zip and send generated ASP files to support@xlinesoft.com along with project file and your sample database for investigation.

I'll find what's wrong with your project running it on my test box.

Admin 3/19/2006

Answered to your email.