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
guy-francis vellaSubject: DB Connection Error
Author: guy-francis vella
Date: 09 Nov 2008 06:11 AM
Evening All

Trying to connect I get the following:
*******************
java.sql.SQLException: [XQuery][SQLServer JDBC Driver]The requested instance is either invalid or not running.
at com.ddtek.xquery.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.xquery.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(Unknown Source)
at com.ddtek.xquery.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.ddtek.xquery.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.ddtek.xquery.jdbc.base.BaseConnection.connect(Unknown Source)
*******************

As per other discussions on this board I have checked to ensure that TCP is running on my SQl server on port 1493 and that the local version of Java is correct.

I have tested it now with both a MS SQL 2005 and MS SQL 2000 server and get the same response each time. If I connect to the Server rather than a specific DB I can see the various DBOs, which would indicate that I have TCP/IP connectivity, but I get the error when I try to link to a DB.

Any help would be greatly appreciated.

thanks - guy

Postnext
Ivan PedruzziSubject: DB Connection Error
Author: Ivan Pedruzzi
Date: 10 Nov 2008 10:49 AM

Could you please contact us at stylus-field-report@@@@progress.com with details on the JDBC URL you are trying to use?

Thanks
Ivan Pedruzzi
Stylus Studio Team

Posttop
Ivan PedruzziSubject: DB Connection Error
Author: Ivan Pedruzzi
Date: 11 Nov 2008 09:42 AM

The problem has been solved using the appropriate JDBC URL.

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.