| :: Help. Trouble getting started :: (16) | Post a New Message | Post a Reply |
 Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
This report wizard looks great and I'd like to try it out but I'm having difficulties getting started. I read all the other postings and saw that others have had the same problems.
I installed and ignored the error message as indicated.
I have a folder in the IIS that has read/write permissions.
I created the default.asp in that folder with the code from the tutorial.
I created the reports.xml and saved in the same folder.
When I try the page I get the following error message:
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/im_central/TMP1qatdstyir.asp, line 4
Here is the code to the page:
<%
Dim objReport, strConnectionString
Set objReport = Server.CreateObject("AspWebSolution.ReportWizard")
'TODO: Change the following connection string to reflect your 'database location
strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE = " & _
"C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb;"
'NOTE:
'You must call the Init procedure before adding any HTML Tags/Text into your page
objReport.Init(strConnectionString)
objReport.DisplayReports
Set objReport = Nothing
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
this is my report
<%
objReport.DisplayReports
Set objReport = Nothing
%>
</body>
</html>
Any help would be greatly appreciated!
Jerry
| Re: Help. Trouble getting started | Post a Reply |
from: Laurel, MD
We just put up a new installer package about an hour ago at the download site. Please try this new package.
-------------------------
Master of the Game
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
Here is my error message:
Error Type:
AspWebSolution (0x800A005B)
Object variable or With block variable not set
/im_central/TMP82i3su19k.asp, line 19
Jerry
 Re: Help. Trouble getting started | Post a Reply |
from: Laurel, MD
Please make sure that the folder (im_central) in which the test file is has write permissions
If this problem persists try one of the following two solutions from Microsoft:
1) Using IIS4 or IIS5, modify the virtual directory security settings so that the user account running yourfile.asp belongs to a user that has execution privileges on MSJET35.DLL and VBAJET32.DLL.
or
2) Modify the permissions of MSJET35.DLL and VBAJET32.DLL so that they can be executed by Everyone. Modify the permissions on all files in folder \Program Files\Common Files\Microsoft Shared\DAO so that Everyone has access.
-------------------------
Master of the Game
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
Do the upline directories also need "write" permission as well?
I'm not familiar with changing these privileges on .dll files, and actually I ultimately want to connect to a MySQL database anyway (was just using the Access DB since that was the example).
Could you tell me what the connection should be like to get to a MySQL database. Here is the code on my current page set up for Access, how would it be different for MySQL? (I've tried a couple different ways be no success. Perhaps this would eliminate my need to make changes to the .dll files)
<%
Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Make sure you initialize before adding any HTML text
objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb;")
%>
<html>
<head>
<title>Untitled Document</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>
| Re: Help. Trouble getting started | Post a Reply |
from: Washington, DC
The code below is how I connected successfully to MySQL database
<% Dim objWiz Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") 'Make sure you initialize before adding any HTML text objWiz.Init(
"DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=northwind;SERVER=THETMAN;UID=sa;PASSWORD=sa;PORT=;OPTION=0;STMT=;") %> <html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset = iso-8859-1">
</head>
<body>
<head>
<title>Untitled Document</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>
</html>
P/S: Do not forget to start your MySQL server.
-------------------------
Ghost
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
Error Type:
AspWebSolution (0x800A005B)
Object variable or With block variable not set
/im_central/TMP247nqsvgxs.asp, line 24
I have not changed any permissions on any .dll files. I'm not sure exactly where to go or how to make those changes. I went to the Microsoft site but was unable to find info that would explain how to do that.
Do I still need to make changes to any .dll files if I'm going to use a MySQL database? If so, could I bother you to give me a little more detailed expanation of how to do it?
Getting close but no cigar yet...
| Re: Help. Trouble getting started | Post a Reply |
from: Laurel, MD
I just want to let you know that I am still working on this problem
and will let you know as soon as posible
-------------------------
Master of the Game
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
Just let me know if there is any additional info I could give you to help solve the problem and I'd be happy to provide. If it can be done in the forum that's great, if you need to grill me over the phone to verify some things that would be ok as well. Just let me know and I could email you my #. As I mentioned above, I've not made changes to .dll files or virtual directories because I'm not sure of what to do.
Once again, thanks for the effort. I'd really like to see this work.
Jerry
| Re: Help. Trouble getting started | Post a Reply |
since: Sep 30, 2003
from: somewhere
I'm still getting the same problem as Jerry's even though I logged in as an administrator.
This just an FYI.
reysan
 Re: Help. Trouble getting started | Post a Reply |
from: Washington, DC
Try installing this one and let me know if you are still having any more problems
-------------------------
Ghost
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
I uninstalled before trying the new install file. When installing I got a message saying that it couldn't update the "vbscript.dll" file.
The report wizard came up as before but still the same error message when trying to create the report.
Jerry
| Re: Help. Trouble getting started | Post a Reply |
from: Washington, DC
I belive this problem has been fixed.
-------------------------
Ghost
| Re: Help. Trouble getting started | Post a Reply |
since: Dec 16, 2003
from: Indianapolis
Error Type:
AspWebSolution (0x800A005B)
Object variable or With block variable not set
When I was installing I got a different error message than the last time, this message was " Error 1931. The Windows Installer service cannot update the system file C:\\WINNT\System32\comsvcs.dll because the file is protected by Windows. You may need to update your operating system for this program to work correctly."
The last time it indicated the "vbscript.dll" file couldn't be updated.
Still hoping,
Jerry
| Re: Help. Trouble getting started | Post a Reply |
from: Mumbai, India
I am still stuck on the first error posted here. Cant even progress to the other errors.
Have followed this particular discussion and have tried all suggested methods. But still stuck on first error message
---------------------------------
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/chart/default.asp, line 4
---------------------------------
HELP!!
| Re: Help. Trouble getting started | Post a Reply |
from: Laurel, MD
Option 1
Make sure the file AWSReportWizard2.dll is registered on your server. If necessary, re-register it using the command
regsvr32 c:\your_path\AWSReportWizard.dll This error may also mean that the ProgID you are passing to
Server.CreateObject is mis-spelled. It should be "AspWebSolution.ReportWizard2". I this doesn't work, try the next option.....
Option 2
There are chances that the install did not work. Go to "[installdir]" and look for AWSReportWizard2.dll. If it is not there, then re-install. However if it is there then re-register it using
REGSVR32 I this doesn't work, try the next option.....
Option 3
This method I found on devX - I don't know if it works but its worth a try:
First try:
1. Find all instances of scrrun.dll on your hard drive.
2. Un-register all of them with
regsvr32 -u [path]\scrrun.dll 3. Register all of them with
regsvr32 [path]\scrrun.dll 4. Re boot
If that doesn't work, tr reinstalling Visual Basic and/or Visual Interdev.
Also, you might want to ensure you've installed the latest version of the MSDAC. Download at: http://www.microsoft.com/data/download.htm
-------------------------
Master of the Game