This topic is locked

-2147467259 Error

11/28/2004 9:46:52 AM
ASPRunnerPro General questions
author

Hi Admin,
I am using the eval product because I am new to ASP development and wanted to see if this product could help me. Your product is a great way to save alot of time coding.
My problem is using MS Access querys as data sources. I receive the following error with all of the queries;

"Data provider or other service returned an E_FAIL status."
This is one of the queries;

select [MACiD], [Premises_Number], [Complex], [Building], [Level], [Service Center #], [Service Center Task #], [Status], [Project_Type], [Scheduled_Start_Date], [Actual_End_Date], [Technician], [TaskTypeID], [Hours], [Minutes], [Comment_Issues], [prob_Tkt] From [Prblm_Tkts Query]
Can you tell me what is wrong with my queries?

Sergey Kornilov admin 12/1/2004

Joe,
sometimes MS Access has problems executing complex queries that built on the top of another query.
You can zip and send me the whole content of ASPRunner output

folder ( ASP files, include files, database etc.) along with the

project file to support@xlinesoft.com for investigation.

501110 12/3/2004

Thanks for the reply. I was traveling for past 4 days and just got back in. Turns out when I started up my pc and tested the queries everything worked. Must have needed to reboot somewhere in the process and didn't.
Great product and will be purchasing it.
Thanks Again