AspWebSolution Forums » Products » ASP Report Wizard v2 » Using ASP Report Wizard with DB2 for Iseries

index | search | no replies | posting guidelines | help

login | register

» »

:: Using ASP Report Wizard with DB2 for Iseries :: (7)

Post a New Message | Post a Reply

Jul 5 2007, 2:11 PM

Using ASP Report Wizard with DB2 for Iseries

EricMayrand

since: Jul 5, 2007
from: Quebec, Canada I'm evaluating ASP Report Wizard for use with our DB2 for Iseries (AS/400) database.

I use the following script :

<%
Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

objWiz.UseTables = "CMXORP,RECLGP"
objWiz.Init("DSN=ASPReport;UID=NSO_U906;PWD=NSO_USER;")
objWiz.DisplayReports

Set objWiz = Nothing
%>

This is working, the wizard connect to my Iseries database, the tables are display.

But when I click on a table or on build report, I received error that telling me that my ODBC doesn't support that properties or error from ODBC Drivers.

I install an SQL DB2 Monitor and this is what I found that seems to doesn't work.

When I click on the table link : Report WIzard try to do a "Select * from [table]"
This is not supported on Iseries DB2. but "Select * from table" will work perfectly.

Is ASP Report WIzard suppose to work with any ODBC database?

Thanks

Jul 6 2007, 5:33 AM

Re: Using ASP Report Wizard with DB2 for Iseries

ghost

from: Washington, DC will have an answer for you by monday

-------------------------
Ghost

Jul 10 2007, 7:11 AM

Re: Using ASP Report Wizard with DB2 for Iseries

ghost

from: Washington, DC What are the name qualifiers for DB2 (or is there none)?
e.g. for SQL Server & Sybase it is '[' and ']' while for MySql it is '`'

SQL Server: SELECT [Field] FROM [Table Name]
MySQL: SELECT `Field` FROM `Table Name`

-------------------------
Ghost

Jul 10 2007, 8:21 AM

Re: Using ASP Report Wizard with DB2 for Iseries

EricMayrand

since: Jul 5, 2007
from: Quebec, Canada It's none

Select field from table

Jul 11 2007, 6:41 AM

Re: Using ASP Report Wizard with DB2 for Iseries

ghost

from: Washington, DC Should have an update by the end of this week.

-------------------------
Ghost

Jul 13 2007, 5:54 AM

Re: Using ASP Report Wizard with DB2 for Iseries

ghost

from: Washington, DC Check out this new build v2.6.37 and if you still get the same errors, try setting the SqlNamePrefix and SqlNameSuffix properties to blank as follows:

objWiz.SqlNamePrefix = "" 'default is [ objWiz.SqlNameSuffix = "" 'default is ]

-------------------------
Ghost

Jul 13 2007, 8:32 AM

Re: Using ASP Report Wizard with DB2 for Iseries

EricMayrand

since: Jul 5, 2007
from: Quebec, Canada It's working. Now I connect to the database and succeed to create report with the build report.

I wasn't able to save report on my Windows XP but it work perfectly on a windows server 2003.

We will continue to evaluate the product. If the project is accepted, we will buy the licence.

Thanks for your help and your quick answers.

Pages: (1) [1]