| :: Bug Report :: (9) | Post a New Message | Post a Reply |
 Bug Report | Post a Reply |
since: Jun 30, 2005
from: Jamaica
After connecting to my database using my connection script, I don't see my database tables or views. I however get the same list of categorised reports (also without table or views) that I saw in the online demo.
When I try to follow any of the links to those reports (in this case the one labeled "discount orders" under the invoicing category) I recieve the following error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Order Details].[OrderID],[Order Details].[UnitPrice],[Order Details].[Quantity]' at line 1
Help!
I would appreciate anything you guys could do to help me to resolve this issue.
Thanks in advance for your usual prompt response.
Best Regards,
rawdotnet
 Re: Bug Report | Post a Reply |
from: Washington, DC
try this:
add the following statement before you initialize your connection string:
objWiz.DatabaseType = "MySQL" Also take a look at the following post:
http://aspwebsolution.com/forums/?tid=729
-------------------------
Ghost
| Re: Bug Report | Post a Reply |
since: Jun 30, 2005
from: Jamaica
That worked to a certain extent, in that, I now see my database tables (this database only had tables, no views), BUT I am also seeing the same list of categorised reports that I saw in the online demo.
When I try to follow any of the links to those reports I recieve the following error message:
ODBC driver does not support the requested properties.
Why do I keep seeing that list of categorised reports, when they bear no relationship to my actual database?
Help!.
Thanks, again, in advance for your usual prompt response.
Regards,
rawdotnet
| Re: Bug Report | Post a Reply |
from: Washington, DC
ReportsFile from the example online. Create a new
ReportsFile-------------------------
Ghost
| Re: Bug Report | Post a Reply |
since: Jun 30, 2005
from: Jamaica
What is the best way to go about doing that? I have no clue.
Help!
| Re: Bug Report | Post a Reply |
from: Laurel, MD
Just add/change the following line:
objWiz.ReportsFile = "myreports.xml" Also check out the following article: Handling Multiple Databases
-------------------------
Master of the Game
| Re: Bug Report | Post a Reply |
since: Jun 30, 2005
from: Jamaica
My database is now online. And I am able to create useful reports.
However, when paging through my created reports (by clicking on the various page numbers) I occassionally get the following error when moving from the last page to any of the previous pages:
Command text was not set for the command object.
Help!
Thanks in advance for your usual prompt response.
Regards,
rawdotnet
Additionally, I am now (04 July 2004) unable to create new reports. I get the following error messages on clicking the "finish" button on the Report Wizard Dialog window:
Errors Occured!!
Error #-2147024891
Access is denied.
Return
Errors Occured!!
Error #-2147024891
Access is denied.
Return
Errors Occured!
Could not save report
Return
I can't think of any reason why this is happening. I tried restarting the machine and iis - errors persist.
Help! again.
Regards,
rawdotnet
| Re: Bug Report | Post a Reply |
from: Washington, DC
ReportsFile. Make sure that your reports folder is registered as an application under IIS and also that your reports folder/file is not read-only
Also check out the following posts
http://aspwebsolution.com/forums/?tid=1174
http://aspwebsolution.com/forums/?tid=1323
-------------------------
Ghost
 Re: Bug Report | Post a Reply |
since: Jun 30, 2005
from: Jamaica
I am now having the same exact problem outlined at the now inactive post http://aspwebsolution.com/?tid=1525
The screen shot below shows the point at which the application freezes after clicking the Finish button to build a report:
Further, after a hanging episode I am forced to restart iis in order to do other things like view a reports etc.
The really funny thing is it has worked before and allowed me to create three reports .... suddenly this!
Thanks in advance for your usual prompt response.