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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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).

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.