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 » XQuery Help and Discussion » Connection to MS SQL Server in SS09 Enterprise under Vista SP1
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Sample XQuery extension using ... (2)
-> + Another EDI problem (7)
-> + Removing xmls:od and xmls:xsi ... (2)
-> + Configuring MarkLogic with Sty... (10)
-> + EDI to XML (7)
-> + Can't write to SQL-Server (4)
-> + XQuery and SQL-Server (2)
-> - Connection to MS SQL Server in... (2)
-> ->Connection to MS SQL Serv...
-> + copy/modify with Stylus Studio... (5)
-> - copy/modify with Stylus Studio... (1)
-> + [SQLServer JDBC Driver]Value c... (5)
-> + wild card chracter usage in XS... (2)
-> + Xquery with SQL NEWID function (4)
-> + Change Only One Line (5)
-> + Format DB xQuery results (3)
-> + Adding MsSQL Database to XQuer... (3)
-> + Need help with using XQuery in... (2)
-> + please help! simple XML transf... (2)
-> + xquery for invoice data (3)
-> + Xquery to cross reference two ... (3)
-- Previous [121-140] [141-160] [161-180] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Thomas Zapf-SchrammSubject: Connection to MS SQL Server in SS09 Enterprise under Vista SP1
Author: Thomas Zapf-Schramm
Date: 14 May 2009 06:01 AM
I can't connect to an instance of MS SQLServer Express 2008 from Stylus Studio Enterprise 2009.

The name for the machine is HAL4, the name of the SQL Server instance is SQLEXPRESS. So I tried:

//HAL4
=> Error: [XQuery][SQLServer JDBC Driver]Error establishing socket to host and port: HAL4:1433. Reason: Connection refused: connect

//HAL/SQLEXPRESS
=> Error:
[XQuery][SQLServer JDBC Driver]Error establishing socket. Unknown host: HAL4/SQLEXPRESS

Looking at the error message i think //HAL4 is better.

But why is the connection refused? TCP/IP is activated, Port is 1433. In SQL Server security is set to operating system security (I need no userid/password when I open the SQLServer Management Studio).


Astelix

PS: I downloaded the latest sqlserver jdbc drivers from MS (version 2.0) but I have no clue what to do with them.
Posttop
Thomas Zapf-SchrammSubject: Connection to MS SQL Server in SS09 Enterprise under Vista SP1
Author: Thomas Zapf-Schramm
Date: 14 May 2009 06:33 AM
OK. Solved it myself. TCIP Port has to be 50182.

//HAL4:50182 works.
   
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.