Need Help in VB Script

[factian]

Hi All,

I am trying to make line graph in ASP but I got the following error

ExcelChart (0x800A000D)
Type mismatch
/sqlcharts/e/BuildAndShowChart.asp, line 97

Line 97 is here :
Set oExcelChart = Server.CreateObject( "ExcelChart.cExcelChart" )

or any other method to draw a line graph and pie chart.

waiting for help

thanks in advance.

[PeejAvery]

Well, let's start off real basic. Is Microsoft Excel installed on the server? What version of IIS are you running?

[factian]

HI

thanks for your reply. yes MS Excel and IIS 5.0 is installed on server. waiting for your reply.

Thanks again.

hope for the best.

[PeejAvery]

You are using Internet Explorer and not Firefox, right?

Have you tried changing the Privacy and Security settings? Lower them and see if your objects might be being blocked for security reasons.

[factian]

Thanks a lot for your valueable support. I am using Internet Explorer as well as Firefox

I have checked the security and privacy option by lower down them. The problem is little bit resolved. but now the error occurs as

Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/sqlcharts/e/BuildAndShowChart.asp, line 98


Line 98 is as under :

Set oExcelChart = Server.CreateObject( "ExcelChart.application" )

Thanks again for ur support.

waiting for your kind response.

Regards,

[PeejAvery]

VBScript will not run in Firefox. It is a Microsoft thing and therefore will work on IE based browsers only.

The error Server object, ASP 0177 (0x800401F3) is on the server. Your server is configured to not allow FileSystemObject use.

[factian]

HI

Thanks a lot for ur help. The problem is solved and it is running on both IE and Mozilla FireFox.

I just replaced the line

Set oExcelChart = Server.CreateObject( "ExcelChart.application" )

with

Set oExcelChart = Server.CreateObject( "ExcelChart.cExcelChart" )

and it runs fine

now I am trying to make line graph. please provide some help in this regards.

thanks again.

[factian]

How to configure IIS to allow FileSystemObject ???????????

[PeejAvery]

How to configure IIS to allow FileSystemObject ???????????

If it's working, then FileSystemObject is enabled.

What version of Firefox are you running so that it is able to have Microsoft objects run?

[factian]

If it's working, then FileSystemObject is enabled.

What version of Firefox are you running so that it is able to have Microsoft objects run?

FireFox version is 5.0

Pls guide me in line graph. how can i draw it ??

[PeejAvery]

FireFox version is 5.0

They have only released beta 2.

Pls guide me in line graph. how can i draw it ??

That would be using some sort of control. How do you want to do it?

[factian]

That would be using some sort of control. How do you want to do it?

What type of control ??? Is it possible to draw dynamic line graph in ASP ??

[PeejAvery]

What type of control ??? Is it possible to draw dynamic line graph in ASP ??

I meant ActiveX control. Concerning it being ASP, do you want it moved to that forum? This is a client-side forum and ASP is not.

[factian]

I meant ActiveX control. Concerning it being ASP, do you want it moved to that forum? This is a client-side forum and ASP is not.

yes sure pls guide me how to register activeX control and to use it in ASP ??

[PeejAvery]

yes sure pls guide me how to register activeX control and to use it in ASP ??

No. I don't think you understand. ActiveX and ASP have nothing in common. ActiveX is a control component that can be embedded into HTML. It is a Microsoft component and only compatible with Internet Explorer.

Take a look at this page. It explains how to draw a graph using VBScript. Once again, it is limited to Internet Explorer.

You could draw a graph using JavaScript and HTML, but it would not be so "dynamic" as you say. How do you get the values for your graph?