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
Tracy TiceSubject: How to connect to Informix
Author: Tracy Tice
Date: 17 Nov 2006 06:36 PM
I am trying to connect to Informix 9.4 on a unix server. Am familiar with ODBC and a little ADO, but the Connection Settings dialog is confounding me. Can someone provide an example for Server URL specific to Informix? I have gotten various errors, most recently:
[StylusStudio][Informix JDBC Driver][Informix]Database not selected yet..
I installed the Additional Language support option for JRE - am I missing anything else?
Appreciate any help - please let me know if I need to include some other detail.
Tracy

Postnext
Ivan PedruzziSubject: How to connect to Informix
Author: Ivan Pedruzzi
Date: 17 Nov 2006 07:06 PM

Hi Tracy,

Please have a look here for Informix Connection properties
http://media.datadirect.com/download/docs/connectsqlxml/jdbcug/jdbcinfx.htm#924955

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Tracy TiceSubject: How to connect to Informix
Author: Tracy Tice
Date: 17 Nov 2006 07:29 PM
Thank you (and as I've seen mentioned on other posts, what a quick reply!), but afraid I'm not getting it. On opening the Connection Settings dialog defaults to:
//localhost:2003;informixserver=informixservername

Based on my ODBC connection, I initially tried:
//10.10.0.5:1526;informixserver=sertec_on

There I get the error mentioned above. Now, based on the info from DataDirect, I tried stating each property explicitly (as I understand them?):
//servername=10.10.0.5;portnumber=1526;informixserver=sertec_on

...resulting in the error (after a little time, 20-30 sec):
[StylusStudio][Informix JDBC Driver]Error establishing socket. Unknown host: servername=10.10.0.5

I'm afraid I need some very specific instructions here :-)

Postnext
Ivan PedruzziSubject: How to connect to Informix
Author: Ivan Pedruzzi
Date: 17 Nov 2006 08:13 PM
Please try the following

//10.10.0.5:1526;informixserver=sertec_on;DatabaseName=<database name>

replace <database name> with the database name

In case of error could you post the entire stack trace?

Are you using File Explorer -> Relational DB or "DB to XML data source"?


Thank You
Ivan Pedruzzi
Stylus Studio Team

Posttop
Tracy TiceSubject: How to connect to Informix
Author: Tracy Tice
Date: 19 Nov 2006 05:58 PM
That was it! I was under the impression that the DBs would just be displayed in the tree after connection. (DB to XML, by the way.) Thank you very much.
Tracy

 
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.