This topic is locked

Error number -2147217904

11/9/2006 9:21:17 PM
ASPRunnerPro General questions
B
bdegnan author

I am running into the below error when running 4.1. The same project in 4.0 works like a champ! I want to use 4.1 because of the screen design feature. DB is MS Access.
The application table structure is:
Company

>Contact Problem occurs here. As a result, cannot test Contact History to see if the error occurs.

>>Contact History
Any ideas what the problem might be? Thank you!
Technical information

Error number -2147217904

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

URL /sales prospect database/Contact_list.asp

SQL query select top 20 [Company ID], [Contact ID], [Salutation], [First Name], [Last Name], [Title], [Address 1], [Address 2], [City], [State], [Zipcode], [Phone], [Email] From [Contact] where ([Contact].[Company ID]=3)

Solution 1. your query contains parameters. Don't use query with parameters in ASPRunnerPro.

Alexey admin 11/10/2006

Hi,
please zip and send to support@xlinesoft.com a full set of generated ASP files along with your database file.

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