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 (1126)
- Stylus Studio Technical Forum (13843)
-> + Stylus Studio & Berkeley DB XM... (4)
-> + XSLT for page breakout (2)
-> + How to avoid creating empty el... (2)
-> + Error in converting 945 EDI us... (4)
-> + XML to X12 (invoice 810 edi) (2)
-> - Stylus Studio 2009 Enterprise ... (1)
-> + Stylus Studio 2007 - license d... (2)
-> + XML to X12 conversion error (6)
-> + How to reset JVM (to another j... (2)
-> + How to generate XML sample dat... (2)
-> + Document Path reference after ... (4)
-> + concatenate with xquery (6)
-> + i want to capture the xml tag ... (3)
-> + "View Sample XML" in schema an... (2)
-> + Can't get to Toolbar settings ... (2)
-> + SOAPException (3)
-> + how to patch xml files with wr... (2)
-> + wysiwug xslt editor (2)
-> + XML to Google Charts (10)
-> + XML to HL7 (2)
-> - Outputting this XML (1)
-> + Interpreting XSD Error Message... (2)
-> + converter EDI --> typ = no (8)
-> + License issue (7)
-> + One of the simplest questions ... (3)
-> + xQuery transformation encounte... (2)
-> + Schema Evolution (2)
-> + Preview in Browser button gray... (4)
-> + converter:EDI:val=no AND chr=.... (4)
-> + [XQuery][DB2 JDBC Driver]Unsu... (2)
-> + Need Help Create XML file thro... (4)
-> + Flat file to XML conversion in... (5)
-> + How to set delimiters if it's ... (4)
-> + XSD Validation failing (4)
-> + XSD Validation failing (2)
-> + Web Service Call cannot retrie... (7)
-> + Flat file conversion to XML (2)
-> + Stylus Studio crash (5)
-> + Stylus Studio No Longer loads (2)
-> + How do I print in color? (2)
-> + Integrating Documentum WebPubl... (2)
-> + Stylus Studio crashes on openi... (4)
-> + Change format of XML output fo... (3)
-> + XSLT mapper / Source file not ... (7)
-> + Stylus Studio crashes on start... (3)
-> + Loading GML3.1 (3)
-> + NullPointerException when runn... (5)
-> + Can not open Stylus Studio (3)
-> + macros for custom validation e... (6)
-> + Does Stylus Studio generate XM... (4)
-> + another csv conversion (7)
-> + ADD CVS to Source Control drop... (2)
-> + Automate xquery (6)
-> + Correcting multiple XML docume... (2)
-> + Unable to locate Components\Da... (5)
-> + Runtime Error, Struzzo.exe, Ab... (11)
-> + Convert XML to EDIfact (3)
-> + I don't have the Mapper tab (6)
-> + CSV conversion with null field (3)
-> + Converting a Complex Flat File... (2)
-> - installion in batch mode (1)
-> + Complete Custom Validation Lis... (2)
-> + creating xml from csv flat fil... (9)
-> - need Help Regarding XBRL (1)
-> + Exception FODC0004: file or di... (2)
-> + Activation (2)
-> + java runtime error (2)
-> + connection problem with AS 400... (4)
-> + XML to 837I EDI -- multiple NM... (3)
-> + WYSIWYG in SSv7 (2)
-> - Write into < head /> tags us... (1)
-> + Maximum recursion depth exceed... (2)
-> - Code coverage testing (1)
-> - Passing JavaScript with multip... (1)
-> + preserving white space in XML ... (8)
-> + XXX maps to XXX system (3)
-> + Help with extracting bookmarks... (2)
-> + Stylus Studio crashes when sou... (2)
-> + WSDL not Displaying properly (5)
-> + How to use fonts other than ba... (5)
-> + Saxon XSLT2 and FOP for XSL:FO... (3)
-> + Converting from XML to EDIFACT (5)
-> + Looping more than one time thr... (2)
-> - Need help with using XQuery in... (1)
-> + Looping - Taking the comma out (3)
-> + xslt mapper is only processing... (4)
-> - Newbie: using Saxon 9.1 with F... (1)
-> + Editing ![CDATA[]]> in the Gr... (2)
-> + Convertic EDI files into XML (7)
-> + Type2 Authentication missing D... (6)
-> + Please help in a simple conver... (5)
-> + Doc/Literal Wrapped (4)
-> + Error starting Stylus Studio (9)
-> + WYSIWYG Menu Bar and Tab Missi... (2)
-> + XML file size limits (2)
-> + XML Publisher (2)
-> + cant get namespace declaration... (5)
-> + Fixed Width to XML (3)
-> - file to xml conversion (1)
-> + Create Multiple Page (3)
-- Previous [481-500] [501-520] [521-540] Next
+ Website Feedback (244)
+ XSLT Help and Discussion (7447)
+ XQuery Help and Discussion (1870)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (361)
+ 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-2011 All Rights Reserved.