index | search | no replies | posting guidelines | help | login | register |
Index » Products » ASP Report Wizard v2 |
| |||||||
Apr 22 2004, 3:23 PM |
| ||||||
ha from: Houston, TX | I am testing ASP Report Wizard for a MS Access database web application we are developing, but am having a startup problem. (The product looks like it will be a perfect fit for this and other customer projects.) I used the .zipped Windows installer download to install the files, and followed the instructions in the online manual and the forums to set up a test web page (default.asp). Unfortunately I am getting the following error: Microsoft VBScript runtime (0x800A01A8) Object required /MPD/default.asp, line 27 Following is the default.asp code: <% Dim objwiz, strConnectionString Set objwiz = Server.CreateObject("AspWebSolution.ReportWizard2") strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "DATA SOURCE=C:\MEPSystemProjects\MPDSystemDesign.mdb;" objwiz.Init(strConnectionString) objwiz.DisplayReports Set objwiz = Nothing %> <html> <head> <title>Test Report Page</title> <meta http-equiv="Content-Type" content="text/html; charset = iso-8859-1"> </head> <body> <% 'put this where you want your reports objWiz.DisplayReports '(This is line 27 in default.asp) Set objWiz = Nothing %> </body> </html> My development system is running Windows 2000 Professional and IIS, and my user account has Administrative rights. I have reviewed and searched the forums and tried the suggestions put forward, such as manually registering the AWSReportWizard2.dll, verifying the directory and file permissions, restarting the computer, with no success. Thank you for your assistance. | ||||||
Apr 23 2004, 5:30 AM |
| ||||||
whichman from: Laurel, MD | It seems you killed the object before you called the displayReports Set objWiz = Nothing is the last line of the objects existence in memory. Try the following page below: <% Dim objwiz, strConnectionString Set objwiz = Server .CreateObject("AspWebSolution.ReportWizard2" ) strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "DATA SOURCE=C:\MEPSystemProjects\MPDSystemDesign.mdb;" objwiz.Init(strConnectionString) %> <html> <head> <title>Test Report Page</title> <meta http-equiv="Content-Type" content="text/html;charset = iso-8859-1"> </head> <body> <% 'put this where you want your reports objWiz.DisplayReports Set objWiz = Nothing %> </body> </html> ------------------------- Master of the Game | ||||||
Apr 23 2004, 7:03 AM |
| ||||||
ha from: Houston, TX | Thank you. I corrected the default.asp code and ASP Report Wizard ran perfectly with our test database :smile:. So far the product looks like it will be a great fit for the customer's requirements (the 'join' query displayed as a View exactly as I had hoped it would). After I finish some more testing, I will contact you regarding purchasing the product for implementation at the customer's site. | ||||||
Apr 23 2004, 7:08 AM |
| ||||||
whichman from: Laurel, MD | Cool..! we forward to working with you. ------------------------- Master of the Game | ||||||
Pages: (1) [1] |