How to get ASP.NET using C# to transform Access Reports

Peter Petrillo

The Access development group here at this company has exported its reports in xml format from Access 2003. I have no influence on how they have created them. I received the following files

xm
xs
xsl
asp or html (my option

Using a simple ASP.NET form with only a System.Web.UI.W ebControls.Xml on it, I receive an error (below) that the scripting language 'vbscript' is not supported. The xslt file has in it vbscript scripting to generally calculate cerain amounts in the report. I have not been able to find any help info on working around this. Running the supplied asp or html file the report is displayed however that means a web page outside of my C# .NET code. Can anyone help me on this

*************** *************
The scripting language 'vbscript' is not supported.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.Xsl. XsltException: The scripting language 'vbscript' is not supported

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[XsltException: The scripting language 'vbscript' is not supported.
System.Xml.Xsl. ContainerAction .AddScript(Comp iler compiler) +29
System.Xml.Xsl. ContainerAction .CompileTopLeve lElements(Compi ler compiler) +85
System.Xml.Xsl. ContainerAction .CompileDocumen t(Compiler compiler, Boolean inInclude) +17
System.Xml.Xsl. RootAction.Comp ile(Compiler compiler) +
System.Xml.Xsl. Compiler.Create RootAction() +12
System.Xml.Xsl. Compiler.Compil e(NavigatorInpu t input, XmlResolver xmlResolver, Evidence evidence) +20

[XsltCompileExce ption: file:///c:/inetpub/wwwroot/DEDWebACA/DEDxml/rptRecentActivi ty.xsl(157,3)

System.Xml.Xsl. Compiler.Compil e(NavigatorInpu t input, XmlResolver xmlResolver, Evidence evidence) +29
System.Xml.Xsl. XslTransform.Co mpile(XPathNavi gator stylesheet, XmlResolver resolver, Evidence evidence) +21
System.Xml.Xsl. XslTransform.Lo ad(String url, XmlResolver resolver) +19
System.Xml.Xsl. XslTransform.Lo ad(String url) +2
System.Web.UI.W ebControls.Xml. LoadTransformFr omSource() +22
System.Web.UI.W ebControls.Xml. Render(HtmlText Writer output) +2
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +24
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +7
System.Web.UI.H tmlControls.Htm lForm.RenderChi ldren(HtmlTextW riter writer) +4
System.Web.UI.H tmlControls.Htm lForm.Render(Ht mlTextWriter output) +26
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +24
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +7
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +24
System.Web.UI.P age.ProcessRequ estMain() +192

-------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET Version:1.1.432 2.573

Nov 12 '05 #1

Subscribe Reply

6894

Dare Obasanjo [MSFT]

The System.Xml.Xsl. XslTransform class does not support VBScript as a
scripting language in script blocks. Only C#, VB and Jscript are supported.
From the MSDN documentation at
http://msdn.microsoft.com/library/en...sxslscript.asp

"The language attribute is not mandatory, but if specified, its value must
be one of the following: C#, VB, JScript, JavaScript, VisualBasic, or
CSharp. If not specified, the language defaults to JScript. The
language-name is not case-sensitive so 'JavaScript' and 'javascript' are
equivalent."

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Peter Petrillo" <an*******@disc ussions.microso ft.com> wrote in message
news:80******** *************** ***********@mic rosoft.com...

The Access development group here at this company has exported its reports in xml format from Access 2003. I have no influence on how they have
created them. I received the following files:
xml
xsd
xslt
asp or html (my option)

Using a simple ASP.NET form with only a System.Web.UI.W ebControls.Xml on it, I receive an error (below) that the scripting language 'vbscript' is not
supported. The xslt file has in it vbscript scripting to generally
calculate cerain amounts in the report. I have not been able to find any
help info on working around this. Running the supplied asp or html file the
report is displayed however that means a web page outside of my C# .NET
code. Can anyone help me on this?

*************** **************
The scripting language 'vbscript' is not supported.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Xml.Xsl. XsltException: The scripting language 'vbscript' is not supported.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception
can be identified using the exception stack trace below.
Stack Trace:
[XsltException: The scripting language 'vbscript' is not supported.]
System.Xml.Xsl. ContainerAction .AddScript(Comp iler compiler) +298
System.Xml.Xsl. ContainerAction .CompileTopLeve lElements(Compi ler compiler) +858 System.Xml.Xsl. ContainerAction .CompileDocumen t(Compiler compiler, Boolean inInclude) +175 System.Xml.Xsl. RootAction.Comp ile(Compiler compiler) +7
System.Xml.Xsl. Compiler.Create RootAction() +128
System.Xml.Xsl. Compiler.Compil e(NavigatorInpu t input, XmlResolver xmlResolver, Evidence evidence) +204
[XsltCompileExce ption: file:///c:/inetpub/wwwroot/DEDWebACA/DEDxml/rptRecentActivi ty.xsl(157,3) : ]
System.Xml.Xsl. Compiler.Compil e(NavigatorInpu t input, XmlResolver xmlResolver, Evidence evidence) +296 System.Xml.Xsl. XslTransform.Co mpile(XPathNavi gator stylesheet, XmlResolver resolver, Evidence evidence) +215 System.Xml.Xsl. XslTransform.Lo ad(String url, XmlResolver resolver) +194
System.Xml.Xsl. XslTransform.Lo ad(String url) +26
System.Web.UI.W ebControls.Xml. LoadTransformFr omSource() +221
System.Web.UI.W ebControls.Xml. Render(HtmlText Writer output) +28
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +72
System.Web.UI.H tmlControls.Htm lForm.RenderChi ldren(HtmlTextW riter writer) +44 System.Web.UI.H tmlControls.Htm lForm.Render(Ht mlTextWriter output) +260
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +72
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1929

-------------------------------------------------------------------------- ------ Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET Version:1.1.432 2.573

Nov 12 '05 #2

Similar topics

2941

Access Reports using ASP

by: Joris Kempen | last post by:

Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David Cline: http://www.15seconds.com/issue/981216.htm

ASP / Active Server Pages

8118

Saving DataSet as XML in ADO format using VB.NET

by: Shaileen Patel | last post by:

Hi, I am trying to convert a lot of web reports from ASP/VB to ASP.NET/VB.NET. I would like to save my dataset in XML and then use XSLT to transform the XML. The catch is I would like to have the XML in the format that ADO uses versus the default format in which ADO.NET uses. Currently, I am using ADO within .NET, but I am concerned about the performance and it might improve if I used the native data providers for .NET. I am not sure if...

.NET Framework

1974

How to transform XML by using XSLT

by: Daniel Walzenbach | last post by:

Hi I need to know how to transform a XML file by using a XSLT file. Consider the following XML file <?xml version="1.0" encoding="UTF-8" standalone="yes"?><LogFile><Dog TimeStamp="16.02.2004 10:04:48" ModifiedBy="Smith, Geoff"><NameOfDog>Fido</NameOfDog><Weight>10</Weight></Dog><Dog TimeStamp="16.02.2004 10:05:24" ModifiedBy="Scott, Al"><Color>Black</Color><Weight>12</Weight></Dog></LogFile By the magic of some XSLT file I want the...

.NET Framework

2850

Limits of Access 2003 using ADP on SQL Server Express BE?

by: Matt Alanzo | last post by:

On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing you >won't be able to do is access any of the design surfaces for SQLS >objects in the ADP. I checked with the Access team on this :-) > I appealed for clarification but without reply. Maybe somone on this newsgroup can provide insight.

Microsoft Access / VBA

6593

Access expoert reports to PDF using PDF writer 6.0 issues

by: Grasshopper | last post by:

Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...

Microsoft Access / VBA

7784

Using accumulate algorithm with a set of pairs

by: cesco | last post by:

I have a set of pairs defined as follow: set< pair<UserEquipment*, double> > numberOfFreqSlotsToAdd; and I need to iterate through all the elements of the set in order accumulate the second field of the pair (that is double). Is there any way I can use the algorithm accumulate to accomplish this? The following line of code double unit = accumulate( numberOfFreqSlotsToAdd.begin(),

C / C++

5257

JUnit Report using ANT. I NEED HELP!!!!

by: knightsmastergeneral | last post by:

Hi, I'm currently working on getting junit and junireport to take some java files, convert it to xml and then display error messages / success rates etc in html which is one of the features of junitreport. I created a simple Math.java class which contains: package test; public class Math { public int add(int a, int b) { return a + b; }

Java

1438

asp.net out of memory on transform why? Is there thread limit?

by: Donald Adams | last post by:

I'm creating Word 2007 reports in asp.net 1.1 via xml transform. I get data from the SQL server in .5 sec., first transform takes less than a sec. and uses 10MB. I have 900MB free memory of the 2GB memory. On following reports generations, I get out of memory on the transform command and only half the file is written before it breaks. The asp.net memory limit isn't at 60%, I even set it to 100% but still get the same error. Is there a...

ASP.NET

2319

How To Create Customizable Reports(Dynamic Reports) using CrossTab Query

by: Peter Herath | last post by:

I want to create a custormizable report . For an example, there's a form with four combo boxes and two of them having database tables columns/field names as values in the combo box(one for select row filed and other one for select column filed in the report) when u select items in that combo boxes and press a Button then selected items should go to the crosstab query as parameters and execute the query. upto that i have done my coding part but...

Microsoft Access / VBA

9157

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9026

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8893

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6518

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5860

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4366

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4619

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3045

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2001

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General