Subject:Generating XML files accessing a MS SQL Server within a COBOL application Author:Rodolfo Vegas Date:10 Jun 2008 04:45 AM
From your response I assume that invoking the command-line utilities is not a valid solution for this task. Am I right?
You mention the Java code generation. Isn't it also possible to do a C# code generation? I mean, is this a valid solution? In fact, Stylus Studio is able to generate the code and to include it in a new or previously existing Visual Studio .NET project.
I've tried this and I've been able to compile and debug the source code, but when it performs the step where it should access the MS SQL Server database it displays the following error message: "The URI prefix is not recognized."
The URI for the relational database from the MS SQL Server where it's trying to get the data from, stored in the inputUrl constant (as generated by Stylus Studio), has the form "xquery:///jdbc:xquery:sqlserver://ServerNetname:Port;schema=dbo;table=TableName;user=Username;password=073320740D2148;xmlforest=true;DatabaseName=DBName;urltype=.xml"
Am I doing something wrong or is the C# not a valid solution?
Subject:Generating XML files accessing a MS SQL Server within a COBOL application Author:Rodolfo Vegas Date:11 Jun 2008 08:29 AM Originally Posted: 11 Jun 2008 05:18 AM
Thank you for clarifying the question. Now I realize that the only way to do the task is Java. It's a pity that the C# for .NET is not supported (nevertheless I still think Stylus Studio is the greatest XML-related software of the world). Are there any plans for adding this support in the near future?
I've tried to execute the DataDirect XQuery command-line utility and I get the message "XQException: [DataDirect][XQuery]The evaluation period for DataDirect XQuery has
expired. Please contact DataDirect Technologies to purchase a valid license. VendorCode: EX0073"
I suppose that using ANY DataDirect XQuery process from outside the Stylus Studio IDE requires a proper license. Am I right? Anyway, that would not widen the possibilities, would it?
We actually have a license for Stylus Studio Enterprise and a license for DataDirect XML Converters. If we bought a license for DataDirect XQuery, would we be able (with the three components licenses) to do just ANYTHING that we actually can do from inside the Stylus Studio IDE? Or are there any other "modules" which may require also a separate license?
Thanks for all your support, help and suggestions.