I'm moving from Windows 2000 Server with IIS 5.0 to Windows 2003 Server with IIS 6.0, I just copy al the website to the new server, all the files etc. i give permission for executing asp.net 2.0 scripting on the server etc.  But when i try to go tothe page with a chart (any),  the chart in the page have no data. I got in the same page a small grid and the grid is fully filled. but appear that the dataset generated within the page has no data or the xml is not recognized. i don't know. But is the same file... that works fine in Windows 2000 server.

This is the code for the dataset and xml within the .aspx file

Dim strFCdataXML As String

Dim Cliente As String

Dim Anio As String

Dim Mes As String

Dim MesFin As String

Public Function getFCXMLData() As String

Dim strFCXMLData As String

'Establish a connection

Dim DS As DataSet

Dim MyConnection As sqlConnection

Dim MyCommand As sqlDataAdapter

Cliente = Me.cbCliente.SelectedValue

Anio = Me.cbAnio.SelectedValue

Mes = Me.cbMes.SelectedValue

MesFin = Me.cbMesFin.SelectedValue

MyConnection = New sqlConnection(ConfigurationManager.ConnectionStrings("TW_SQL_7").ConnectionString)

MyCommand = New sqlDataAdapter("Select Tipo = 'Polvo', Total = sum(PVenta), Orden = 3 from graficoCliente Where Cliente ='" & Cliente & "' and Anio ='" & Anio & "' and Mes between '" & Mes & "' and '" & MesFin & "' Group by Cliente, Anio Union " _

& " Select Tipo = 'Líquido', Total = sum(QVenta), Orden = 2 from graficoCliente Where Cliente ='" & Cliente & "' and Anio ='" & Anio & "' and Mes between '" & Mes & "' and '" & MesFin & "' Group by Cliente, Anio Union " _

& " Select Tipo = 'Total', Total = sum(TVenta), Orden = 1 from graficoCliente Where Cliente ='" & Cliente & "' and Anio ='" & Anio & "' and Mes between '" & Mes & "' and '" & MesFin & "' Group by Cliente, Anio order by Orden ", MyConnection)

'Fill the dataset

DS = New DataSet()

MyCommand.Fill(DS, "Ventas")

'Define a list of Colors

Dim strColor(10) As String

strColor(0) = "AFD8F8"

strColor(1) = "F6BD0F" 'Bright Red

strColor(2) = "8BBA00" 'Dark Green

strColor(3) = "A66EDD" 'Dark Pink

strColor(4) = "F984A1" 'Variant of brown

strColor(5) = "CCCC00" 'Orange

strColor(6) = "999999" 'Violet

strColor(7) = "0099CC" 'Grey

strColor(8) = "CCCC00" 'Chrome Yellow+Green

strColor(9) = "0372AB" 'Dark Blue

'Initialize the XML String

strFCXMLData = "<graph caption='Cliente - " & Cliente & "' shownames='1' showvalues='0' decimalPrecision='0' numberPrefix=''>" & vbCrLf

'Now iterate through each data row

Dim i As Integer

For i = 0 To DS.Tables("Ventas").Rows.Count - 1

strFCXMLData = strFCXMLData & "<set name='" & DS.Tables("Ventas").Rows(i).Item("Tipo") & "' value='" & DS.Tables("Ventas").Rows(i).Item("Total") & "' color='" & strColor(i Mod 9) & "'/>" & vbCrLf

Next

strFCXMLData = strFCXMLData & "</graph>"

Return strFCXMLData

End Function

YOu can also have the XML in a textarea like this ..

<textarea rows='50' cols='50'><%=getFCXMLData() %></textarea>

and check whether the XML is rendered fine.

Moreover you need to see if the flash player 6 or above is installed and have permission to run.

Regards,

Sudipto Choudhury
FusionCharts Team

May be you can try removing the '& vbCrLf' that you have appended after each concatinating line...as in ...

strFCXMLData = "<graph caption='Cliente - " & Cliente & "' shownames='1' showvalues='0' decimalPrecision='0' numberPrefix=''>" & vbCrLf

strFCXMLData = strFCXMLData & "<set name='" & DS.Tables("Ventas").Rows(i).Item("Tipo") & "' value='" & DS.Tables("Ventas").Rows(i).Item("Total") & "' color='" & strColor(i Mod 9) & "'/>" & vbCrLf

 

Regards,

Sudipto Choudhury
FusionCharts Team

Hi, in debug mode this is the error:

ERROR: Invalid number 25640,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.
ERROR: Invalid number 3305,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.
ERROR: Invalid number 22335,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.
ERROR: Invalid number 28492,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.
ERROR: Invalid number 4425,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.
ERROR: Invalid number 24067,00000 specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers.

Thanx in advance

Mario Joel Moran Loza
Creando un mundo mejor... (Building a better world...)

The problem was solved!

The code was ok, the charts was ok.

Seem that IIS 6.0 have new stuff about security and configuration, and the directive

<%@ Page Language="VB" %>

must to be changed for