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
robert welteSubject: Cannot create SQL Server datasource
Author: robert welte
Date: 29 Dec 2006 06:57 PM
I'm trying to create a SQL Server datasource. Where do I find the driver for this? Does it have to be an objd driver?

Postnext
Minollo I.Subject: Cannot create SQL Server datasource
Author: Minollo I.
Date: 29 Dec 2006 09:01 PM
If you are running Stylus Studio Enterprise Suite, the SQL Server driver is bundled with the product; what problem do you get when you try to connect to your server?

Postnext
robert welteSubject: Cannot create SQL Server datasource
Author: robert welte
Date: 29 Dec 2006 09:23 PM
[StylusStudio][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect


I have added a MSSQL 2000 db, setup the sa account with a password and set the tcpip port to 1433. I started and stopped the db. Still getting the same error

Postnext
Minollo I.Subject: Cannot create SQL Server datasource
Author: Minollo I.
Date: 29 Dec 2006 10:30 PM
This is what I found looking for similar issues; the problem could be that your server is not accepting TCP/IP conections.

To check the enabled protocols for a server, follow these steps:
* In SQL Server 2000, start the SQL Server Network Utility (svrnetcn.exe).
* On the General tab, select the instance of Microsoft SQL Server on which to load an installed server network library.
* Make sure that TCP/IP appears in the Enabled Protocols list.
* To find the port number, in the Enabled Protocols list, click TCP/IP, and then click Properties. The Properties dialog box displays the port number.

There is an known bug: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol
In a SQL Server 2000 custom installation, if TCP/IP is the only selected protocol and all other protocols are disabled, SQL Server may not initialize and listen on TCP/IP sockets. The Server Network Utility shows that it is listening only on TCP/IP port 1433 even though it is not. To identify if SQL Server is not listening on TCP/IP, check to see if the value for TcpPort in the following registry key is incorrectly set to blank or empty:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=

To work around this problem, follow these steps:

* Start Registry Editor (Regedt32.exe).
* Locate the TcpPort value in the following key in the registry:
* Named instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[InstanceName]\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort

* Default instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
\MSSQLServer\SuperSocketNetLib\TCP\TcpPort

* On the Edit menu, click String. Enter either of the following values:
a. Type the port number you want. -or-
b. Enter a value of 0 to have SQL Server dynamically detect and assign a port the next time SQL Server starts.

* Click OK.
* Quit Registry Editor.

SQL Server 2000 Service Pack 4 (SP4):

You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install SQL Server 2000 Service Pack 3a, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/2000/sp4.mspx.

Postnext
robert welteSubject: Cannot create SQL Server datasource
Author: robert welte
Date: 30 Dec 2006 02:36 PM
WELL I'VE SPENT THE MORNING TRYING TO INSTALL SP4. IT COMES BACK WITH - INSTANCE NOT INSTALLED!.

COULD WE MOVE ON TO THE MSSQLEXPRESS i HAVE INSTALLED AS WELL AND SEE IF I CAN MAKE A CONNECTION THERE?

Postnext
Minollo I.Subject: Cannot create SQL Server datasource
Author: Minollo I.
Date: 30 Dec 2006 09:41 PM
I'm not positive SQL Server 2005 Express Edition is supported/certified by the DataDirect drivers Stylus Studio bundled; I'm checking that with our CfJDBC colleagues; see http://www.datadirect.com/products/xquery/matrix/ddxquery.htm for the databases officially supported.

In the meanwhile, as long as you know that the database server is listening on a TCP/IP port for connections, you can surely give it a try.

Postnext
Minollo I.Subject: Cannot create SQL Server datasource
Author: Minollo I.
Date: 02 Jan 2007 10:21 AM
Just to confirm: SQL Server 2005 Express Edition is supported by the Microsoft SQL Server JDBC driver bundled in Stylus Studio v2007.

Postnext
robert welteSubject: Cannot create SQL Server datasource
Author: robert welte
Date: 02 Jan 2007 02:05 PM
Stylus Studio will not recognoze that SQLEXPRESS is running at all
I've tried using [computer name]\[database name] as well as [database name] by itself. Neither work!

john welte

Postnext
Ivan PedruzziSubject: Cannot create SQL Server datasource
Author: Ivan Pedruzzi
Date: 03 Jan 2007 12:05 AM
Hi Robert,

If you type the following command do you see sqlserver running?

netstat -a -p TCP

you should have an entry like

TCP IVAN:ms-sql-m IVAN:0 LISTENING

Is the authentication method set to mixed?

If you have multiple SQLServer instances use the following syntax in the server URL field

//hostname\instancename:port


Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
robert welteSubject: Cannot create SQL Server datasource
Author: robert welte
Date: 03 Jan 2007 02:18 PM

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\rjwelte>netstat -a -p TCP

Active Connections

Proto Local Address Foreign Address State
TCP design:http design:0 LISTENING
TCP design:epmap design:0 LISTENING
TCP design:https design:0 LISTENING
TCP design:microsoft-ds design:0 LISTENING
TCP design:1025 design:0 LISTENING
TCP design:1027 design:0 LISTENING
TCP design:1031 design:0 LISTENING
TCP design:2811 design:0 LISTENING
TCP design:3306 design:0 LISTENING
TCP design:3833 design:0 LISTENING
TCP design:1028 design:0 LISTENING
TCP design:1562 design:0 LISTENING
TCP design:netbios-ssn design:0 LISTENING
TCP design:1641 by1msg4176108.phx.gbl:1863 ESTABLISHED
TCP design:1679 www.stylusstudio.com:http ESTABLISHED
TCP design:1680 www.stylusstudio.com:http ESTABLISHED

nothing listening to port 1433. By the way. I'm woring on a localhosy

john welte

Posttop
Ivan PedruzziSubject: Cannot create SQL Server datasource
Author: Ivan Pedruzzi
Date: 06 Jan 2007 12:28 PM
Robert,

If SQLServer doesn't show on netstat it means that the TCP-IP transport is not enabled on the server.

Please have a look the SQLServer documentation.

See previous thread
http://www.stylusstudio.com/SSDN/default.asp?action=9&fid=23&read=2893

Hope
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 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.