XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> - Cannot connect to SQL server (7)
-> ->Cannot connect to SQL ser...
-> ->Cannot connect to SQL ser...
-> ->Cannot connect to SQL ser...
-> ->Cannot connect to SQL ser...
-> ->Cannot connect to SQL ser...
-> ->Cannot connect to SQL ser...
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Igor IkonnikovSubject: Cannot connect to SQL server
Author: Igor Ikonnikov
Date: 10 Nov 2006 11:42 AM
Originally Posted: 10 Nov 2006 11:13 AM
The connection asks me for user name and password, however we are using trusted connection (no username or password required). TCP/IP protocol is enabled on the SQL server. The server is not on my PC. I have no problems connecting to this server using XML Spy. In both cases, I have Enterprise editions.
Could you help?
Igor.

Postnext
Ivan PedruzziSubject: Cannot connect to SQL server
Author: Ivan Pedruzzi
Date: 10 Nov 2006 11:47 AM

Hi Igor,

The DataDirect driver used by Stylus Studio requires SQL Server mixed authentication.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Igor IkonnikovSubject: Cannot connect to SQL server
Author: Igor Ikonnikov
Date: 10 Nov 2006 11:52 AM
Unfortunately, it does not, Ivan.
But I'm really impressed with the response time (not so much with the product).
Can I put "support for trusted SQL connection" to the Feature Requests?
Thank you Ivan.
Igor.

Postnext
Ivan PedruzziSubject: Cannot connect to SQL server
Author: Ivan Pedruzzi
Date: 10 Nov 2006 01:55 PM

We are sorry you don't like Stylus Studio.

Is it only for the SQL Server authentication requirements or something else?

Thank You for your feedback
Ivan Pedruzzi
Stylus Studio Team

Postnext
Igor IkonnikovSubject: Cannot connect to SQL server
Author: Igor Ikonnikov
Date: 10 Nov 2006 04:59 PM
Originally Posted: 10 Nov 2006 03:54 PM
Connectivity to SQL is not "just" a feature to me - this is a critical one. Without that I'm ready to return the product for refund. Why would I need the Enterprise edition without data mapping functionality?
I find the UI for XML Schema editing extremely cumbersome to use: the Diagram view is overloaded with useless graphics, the Tree view forces you into too many clicks to get the picture you want to see, settings readily available in Spy (e.g. configuration of sample XML file) are hidden in the Options. Etc., etc., etc.
XSLT editor is not bad, but the built-in engine fails to understand heavily recursive calls, and so does the much praised Saxon. Even when they do, it takes them from 20 to 40 minutes to run transformation on a 5MB XML file, whereas the much cursed MSXML does the same in 4 to 8 seconds (not minutes). The only real advantage over the Spy I have found so far: better handling of large XML files (have not seen "out of memory" message yet).
And I greatly miss "Save to URL" option (available in Spy).
I kept hearing praises from people I respect (Priscilla Walmsley, Norman Walsh) and finally decided to give it a try, but what I found definitely did not meet my expectations. I've been working with XML technologies since 2001 and have been using Spy since 2003, that is to say: I'm not new to XML editing. Yet, with SS I am experiencing quite a steep "learning" curve.
Sorry for these pessimistic notes, but it took me a while to persuade my management to give Stylus a try and I'm having hard time finding practical advantages of the Stylus over the Spy (at the Enterprise Suite level).

Postnext
Ivan PedruzziSubject: Cannot connect to SQL server
Author: Ivan Pedruzzi
Date: 10 Nov 2006 07:02 PM

Hi Igor,


> I find the UI for XML Schema editing extremely cumbersome to use: the Diagram view is overloaded
> with useless graphics,

This is clearly subjective, even if I am very surprise. XMLSpy schema editor force you to continuously switch between the list of global element and graphical part and yet the text view.

While Stylus Studio Schema editor let you work in the same window.

It would be useful to understand what do you mean with "useless graphics" and
"the Tree view forces you into too many clicks to get the picture"

>XSLT editor is not bad, but the built-in engine fails to understand heavily recursive calls, and so >does the much praised Saxon.

Which XSLT processor are you currently using to run your stylesheets?
Are you asserting that spy processor is better the Saxon? It would useful to see use cases to support such theory.

>Even when they do, it takes them from 20 to 40 minutes to run transformation on a 5MB XML file,

Running Saxon through Stylus Studio has a price in term of performance because of the heavy wiring for debugging, backmapping, and profiling, etc. We are working on that in our next release.
But it takes just one click to generate a Java application and set Saxon free :)

>And I greatly miss "Save to URL" option (available in Spy).

In Stylus Studio you don’t need to use a different command. File -> Save -> then you can pick FTP, HTTP, ect

>Sorry for these pessimistic notes, but it took me a while to persuade my management to give Stylus a >try and I'm having hard time finding practical advantages of the Stylus over the Spy (at the >Enterprise Suite level).

We have been working on XML tools for the last seven years and we don't get discourage by criticisms, on the contrary Stylus Studio evolved thanks to the feedback we have received.

Thank You
Ivan Pedruzzi
Stylus Studio Team

Posttop
Igor IkonnikovSubject: Cannot connect to SQL server
Author: Igor Ikonnikov
Date: 13 Nov 2006 09:12 AM
Hello, Ivan.

OK, let's start from the very beginning: how can I connect to the MS SQL server using trusted connection? Am I the first person in the previous seven years to ask this question?

Igor.

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.