Dundas Charts for RS 2000

Hi all,

maybe this is the wrong forum or company to post, but I'm looking for an answer, which I can't find at Dundas' Website.

Is there a Version of Dundas Charts for Reporting Services 2000? All I find is the Version for 2005...

And if there is such a version, are there differences concerning the possibility of usinig 2 Y-axis?

One more thing. What would be the arguments for using 2005 instead of 2000?

Replies are very much appreciated! Thanks in advance!

ME

This link should provide an overview on a few the new features in RS 2005 compared to the previous version: http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

The integration of third party components (e.g. as used by the Dundas controls in RS 2005) requires the new CustomReportItem feature specifically added in RS 2005.

-- Robert

|||

Have you looked into Chart FX at http://www.softwarefx.com/SfxSqlProducts/cfxReportingServices/

From their website:
"Chart FX for Reporting Services leverages the charting features from the award winning Chart FX charting engine. Plus it's just as easy to add this powerful technology to your reporting projects.
Here are some features.

Ease of Use & Integration

? Chart Wizard

? Data Wizard

? Property Grid

? Resource Center

? Comprehensive Support

Advanced Features

? Multiple Gallery Types

? Gauge Chart Types

? 2D/3D Rendering

? Per Series Attributes

? Axis Sections

? Multiple Axes

? Logarithmic Axes

? Smart DateTime Axes

? Multiple Panes

? Grid Lines

? Conditional Attributes

? Data Compacting

? Artistic Borders

? Background Images

? Gradients

? Color Palettes

? Titles

? Rich Text Titles

? Point Labels

? Collision Detection

? Data Grid

? Legends "

Good luck.

dts2000 migration, activex script and odbc connections help needed

Apologies if this has been covered before or if i am in the wrong place.

I am migrating some DTS2000 packages to SSIS via the migration wizard. However there is an activex script in each DTS package that connects to an AS400 to retrieve teh record count of a table for integrity checking. Under SQL server 2000 this worked fine but in SSIS it errors with "The OLE DB provider "MSADSQL" has not been registered" how do i get this to work i suspect its because this is a 32 bit dll and my new system is a 64bit sql server 05 on windows 2003. The odbc driver for the as400 has been installed also.

The activex script is as follows:

dim cn 'sql connection
dim rs 'sql recordset for the insertion of new as400 records
dim insertstr 'sql insert string
dim rs1 'sql recordset for the insertion of new as400 records
dim insertstr1 'sql insert string

set cn = createobject("ADODB.Connection")
set rs = createobject("ADODB.Recordset")

Function Main()
'set up connection for sql
cn.provider="sqloledb"
cn.commandtimeout = 3600 'timeout in seconds
cn.open %sqlserver05%, %user%, %password%

'populate temporary table in sql with recordset from as400 odbc
insertstr1 = "Insert into db.dbo.%table% select 'table name',a.* from openrowset ('MSDASQL','DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=%system name%;UID=%username%;PWD=%password%','SELECT count(*) from %table%') as a"

set rs1 = cn.execute (insertstr1)

'close all objects
cn.close
Main = DTSTaskExecResult_Success
End Function

I have since changed MSDASQL to SQLNCLI but (after errors re ad hoc distributed queries which i have enabled) i now get errors re linked servers:

ole db provider "sqlncli" for linked server "(null)" returned message "invalid connection string attrbute"

Does anyone know how i change this to work under sql server 2005. i need to resolve this quickly in order to deliver a project on time. Many thanks

Chris

I am contacting the SSIS team but I suspect that you need to run the 32-bit version of SSIS since - as you pointed out - the ODBC driver is a 32-bit DLL, somehwat similar to the case discussed at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167907&SiteID=1.

|||

I confirmed: if there is only 32-bit ODBC driver, you need to run the package using 32-bit runtime.