XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » DB to XML Data Source: Can't connect to SQL Server DB
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Error in Stylus Studio - canno... (2)
-> + Saxon Assign (2)
-> - License Authentication Failed (1)
-> + Stylus Studio 2007 Download (2)
-> + EDI to XML validation (2)
-> + Reports: can't remove "undead"... (3)
-> + Document Wizard Incomplete (6)
-> + Opening xml converter (4)
-> + Node depth limit with MySQL? (5)
-> + Basics (2)
-> - Node depth limit with MySQL? (1)
-> + Creating an XML Schema from a ... (4)
-> - Issue with XSD (1)
-> + XSL-FO and Apache FOP (2)
-> + How Come Stylus Studio Fails T... (6)
-> + no suitable driver (8)
-> + 211,19: no declaration found f... (6)
-> - Validate HEX (1)
-> + Crashing when connected to dat... (3)
-> - Interface with quickbooks (1)
-> - CDATA control (1)
-> + [resolved] Namespace (and pref... (5)
-> - Hiding and Revealing Child Nod... (1)
-> + Cannot see values in Watch whe... (4)
-> - Help with CSV to XML and Regio... (1)
-> + How do I verify "opt=yes" URI ... (4)
-> - Stylus Studio claims xsd is in... (1)
-> + Can a generated XSD be used in... (4)
-> + I am not a developer I'm just ... (2)
-> + Stylus crash when deleting dat... (6)
-> - Preserving Structure (1)
-> - Preserving Structure (1)
-> - HL7 ORU group tags (1)
-> + Fixed Length Record Layout to ... (2)
-> + WebService Connect (6)
-> - WebService conection problems (1)
-> + Could not detect EDI dialect a... (3)
-> + I am a bookkeeper not a progra... (2)
-> + fatal error (4)
-> - Saxon linebreak (1)
-> + task scheduler (2)
-> - Number of Elements in Grid vie... (1)
-> + Compile Java (2)
-> + What happened to the EDI Wizar... (15)
-> + setting Transformer for java b... (3)
-> + XML Schema Documentation Gener... (3)
-> + EANCOM xsd-files (4)
-> + Failure of CDATA converting pr... (4)
-> + XML File created from text fil... (3)
-> + After purchase AND activation ... (2)
-> + XQuery Format of XML code snip... (4)
-> + Error during conversion (9)
-> - testing for empty nodes (1)
-> + edi converter - java fails (10)
-> + ddtek:serialize (3)
-> - File explorer view (1)
-> - Java Extension Functions (1)
-> + err:FODC0004 (18)
-> - Removing Attributes when Null (1)
-> + CDATA preservation (6)
-> + Help converting xml report to ... (2)
-> + Converting text to XML issue (3)
-> - example not working (1)
-> + XML Editing (2)
-> + Multiple EDI messages within s... (5)
-> + Mapping RDBMS and XML Schema t... (2)
-> + MySQL Database importing (2)
-> + XSD validation using XSV fails... (3)
-> + Is this really well-formed? (3)
-> + HL7 EDI to XML problems -'ORU_... (11)
-> + How do I modify the Xquery to ... (2)
-> + XML mapping difficulty (3)
-> + XLST Conversion (2)
-> + HTML TO XSL Conversion (2)
-> - Convert an EBCDIC file to XML (1)
-> + License Manager still indicate... (4)
-> + Still sometimes getting beat b... (2)
-> + What versions of MySQL are sup... (5)
-> - External XSLT processor proble... (1)
-> + DDEE0082 Erro Internal system ... (6)
-> + Calling function from .NET C# (2)
-> + Stylus studio projects bound t... (3)
-> + Report Designer mistakenly gen... (3)
-> + Choose Nodes in pipelines (3)
-> + Custom external processor and ... (2)
-> + predefined (4)
-> + translate function in java (2)
-> + XMLPipeline trouble in Linux (7)
-> + Converting Custom EDI Message ... (2)
-> + tab delimetered file with vari... (2)
-> + XML validation with XSD (2)
-> + Missing documentation: SSL_Cer... (2)
-> + Parse Xcel input file which is... (2)
-> + XML Publisher post processors (2)
-> + Alignment of table items in XM... (2)
-> + XML to PDF using XML Publisher (2)
-> + Blurry Background image / Vect... (4)
-> + URIResolver error on command l... (2)
-> + stylus studio - the (3)
-> + problem with omit from output ... (3)
-- Previous [481-500] [501-520] [521-540] 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
Greg WoodruffSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Greg Woodruff
Date: 25 Feb 2005 02:04 PM
I get the following error when attempting to connect to MS-SQL DB:

java.sql.SQLException: [StylusStudio][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectStub.connect(DataDirectStub.java:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)

My connection criteria:
Database Type: Microsoft SQL Server
Server URL: //localhost:1433;DataBaseName=Northwind
Username: sa
Password:
(NOTE: Password is blank)

Any help would be greatly appreciated.

Thanks.
Postnext
Ivan PedruzziSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Ivan Pedruzzi
Date: 25 Feb 2005 02:12 PM
Greg,

Most likely your server is not configured to use the TCP-IP transport.
Run the network utility to add TCP-IP
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

Which Stylus Studio build are you running (Help->About)?

Hope this helps
Ivan
Postnext
Greg WoodruffSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Greg Woodruff
Date: 25 Feb 2005 02:58 PM
I am enabled for TCP/IP (port 1433) and named pipes.

The build I'm using is 287h.

Any other suggestions?
Thanks.
Postnext
Ivan PedruzziSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Ivan Pedruzzi
Date: 25 Feb 2005 03:29 PM



If you are running Windows XP and you have installed XP SP2
you need to re-enable the TCP port that gets locked by default.

Here is the page that describes the process
http://support.microsoft.com/kb/841252

Hope this helps
Ivan
Postnext
Greg WoodruffSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Greg Woodruff
Date: 25 Feb 2005 04:00 PM
No luck. I am running Windows XP Pro with SP 2 but Windows Firewall is Off.
All registry settings noted in the MS Kb article are as expected with
exception to named instance setting:
HKLM/Software/Microsoft/Microsoft SQL Server/mssql$<instancename>/MSSQLServer/SuperSocketNetLib/Tcp
(it does not exist in my registry).

Any other ideas?
Thanks.
Postnext
Ivan PedruzziSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Ivan Pedruzzi
Date: 25 Feb 2005 04:12 PM

Dd you re-start SQLServer and Stylus Studio after the changes?

Ivan
Postnext
Greg WoodruffSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Greg Woodruff
Date: 28 Feb 2005 12:12 PM
I've restarted everything as well as rebooting my computer but no change.

I wrote TCP socket client/server console apps to test the ability to
connect to port 1433 via TCP and it worked fine.

Could this be a Java Virtual Machine issue? This is the version I'm using:
1.4.2_07-b05 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Thanks
Postnext
Ivan PedruzziSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Ivan Pedruzzi
Date: 28 Feb 2005 02:39 PM
>Could this be a Java Virtual Machine
>issue? This is the version I'm using:
>1.4.2_07-b05 Java HotSpot(TM) Client VM
>Sun Microsystems Inc.
> debug mode port:8000

I am running the same JVM; could you try using

//127.0.0.1


>
>Thanks
Postnext
Greg WoodruffSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Greg Woodruff
Date: 28 Feb 2005 04:25 PM
Still no go. :o(
Postnext
Tony LavinioSubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Tony Lavinio
Date: 02 Mar 2005 12:26 PM
In your test app, were you connecting with the same credentials (user=sa
and no password)? SQL Server can run in a mode where the SQL security is
disabled and it uses the operating system security, in which case 'sa'
won't be allowed to connect.
You can try this by starting SQL Query Analyzer and trying to connect
with the radio button set to "SQL Server authentication" which is the
mode that the JDBC driver would be using.
Posttop
Mike KanaleySubject: DB to XML Data Source: Can't connect to SQL Server DB
Author: Mike Kanaley
Date: 19 Mar 2005 07:28 AM
Pain in my butt too.
You will need to install SQL Service Pack 3a.
You can find this on Microsoft's support site.

http://www.microsoft.com/sql/downloads/2000/sp3.asp
(Only sql2ksp3 is really necessary unless you are using the analytics tools).

   
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.