AspWebSolution Forums » Products » ASP Report Wizard v2 » Unable to load table fields (to create a report)

index | search | no replies | posting guidelines | help

» »

:: Unable to load table fields (to create a report) :: (3)

Feb 27 2007, 10:08 AM

Unable to load table fields (to create a report)

radlinkreports

since: Feb 26, 2007
from: Dallas I currently looking for a report writer. I've installed the free version of ASP Report Wizard to evaluate your product. I'm running it against MYSQL. When I load the default page I get a list of tables in the database but when I select a table and attempt to build a report I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt-log]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 '[reports] WHERE 1=0' at line 1

/aspreports/default.asp, line 10

I get no list of columns(fields) to select.

Any suggestions

Feb 27 2007, 12:38 PM

Re: Unable to load table fields (to create a re...

Post a Reply

ghost

from: Washington, DC It seems the report wizard cannot recognize database type from your connection string.
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

Feb 27 2007, 2:14 PM

Re: Unable to load table fields (to create a re...

Post a Reply

radlinkreports

since: Feb 26, 2007
from: Dallas Thanks for the help the post you pointed me to really helpful.

My problem was I had put

objWiz.DatabaseType = "MySQL"

AFTER

objWiz.Init

Thanks again for prompt help

Pages: (1) [1]