SSDN - Creating Scenario with MS SQL Server 2000 Database

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Dennis Francis

Subject: Creating Scenario with MS SQL Server 2000 Database
Author: Dennis Francis
Date: 17 Aug 2005 11:10 AM

I am creating a Scenario using MS SWL SERVER 2000. I received the following error message:

[StylusStudio][SQLServer JDBC Driver]Error establishing socket. Connection refused

Ivan Pedruzzi

Subject: Creating Scenario with MS SQL Server 2000 Database
Author: Ivan Pedruzzi
Date: 17 Aug 2005 11:21 AM

Take a look to this thread it may help

http://www.stylusstudio.com/SSDN/default.asp?action=9&read=2893&fid=23#8885

Ivan Pedruzzi
Stylus Studio Team

Dennis Francis

Subject: Creating Scenario with MS SQL Server 2000 Database
Author: Dennis Francis
Date: 18 Aug 2005 05:50 PM

I downloaded the JDBC driver and installed it. However, I received the same error message when I created the scenario. I am not sure how to configure the driver. This has been a frustrating week for me working with this package. I think everything should be documented as to how you connect to your database. I need a direct solution to the problem. I have wasted one week.

Thanks.

Ivan Pedruzzi

Subject: Creating Scenario with MS SQL Server 2000 Database
Author: Ivan Pedruzzi
Date: 18 Aug 2005 08:54 PM

Hi Dennis,

You don't need to download anything, Stylus Studio bundles the driver for Microsoft SQL Server.

- Are you running SQL Server 2000 SP3a?
If not you can download SP3a update for free from
the Microsoft web site

- Is the TCP-IP transport enabled on the server?
(see the SQL Server Network Utility)

- Is Security set to "SQL Server and Windows"?
(see the SQL Server Enterprise Manager)

Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.