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
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 03 Feb 2006 01:06 PM
--------------------------------------------------------------------------------

I am trying to connect to a DB2/400 database.

I am using DataDirect SequeLink which was configured as per the instructions supplied.

When I try to connect to the database using this connection using the default port and the appropriate User name and Password, I get an error "TCP/IP connection refused".

Can anybody provide me with some guidance here?

Thanks.

Postnext
(Deleted User) Subject: ODBC Connection refused
Author: (Deleted User)
Date: 03 Feb 2006 02:07 PM
Hi, Howard. Stylus Studio has built-in support for IBM DB2. Have you tried using the built-in driver to connect? (File > New > DB to XML Data Source). Can you try that and let us know if it works for you?

Additional information on this topic is here:
http://www.stylusstudio.com/~ssdn/default.asp?action=9&read=3321&fid=23&style=WebBoard

Hope this helps.

David Foster
Stylus Studio Team

Postnext
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 03 Feb 2006 03:19 PM
Hi David,

Thanks for the quick reply and the info provided.

After a few (many) adjustments, I have been able to connect to my DB.
However, I can not see any tables within the Database, I do not see any database icons beside the Databases that exist on the 400. When I open the Databases, I don't see any tables (other than 1 Test that was created by an outside application).

Do these tables need a different definition to be viewable ? - they were created using standard DDS on the 400.

Where do I go from here ?

Postnext
(Deleted User) Subject: ODBC Connection refused
Author: (Deleted User)
Date: 03 Feb 2006 03:31 PM
Hi, Howard. The fact that you can see one (but not all) table suggests that the user (username/password) you used to create the database connection doesn't have adequate permissions to read the others.

Out of curiousity: did you create the connection using the Stylus Studio DB to XML user interface?

David Foster
Stylus Studio Team

Postnext
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 03 Feb 2006 03:47 PM
Hi again David,

Yes, I used the standard DB to XML connection as you suggested, the info provided was very helpful.

The User ID and password (mine) are at the highest level on this system (Security Officer).

What troubles me is that the Databases do not show as such (no DB icon) as described in the video presentation. Please see attached Print Screen - the Database I need to access is called JSDB, as you can see only 1 table shows here.

Perhaps, I should more fully explain the requirement here and you could tell me if I'm on the right path.

I need to map 3 tables on my iSeries400 to an XML document, the schema of which was provided by a third party (governmental agency) who is to receive this information.

I will not need to select a subset of records from any of the tables.

Is there a simple way to accomplish this task?

Thanks,

Howard


ImageTest1.bmp
Screen Shot

Postnext
(Deleted User) Subject: ODBC Connection refused
Author: (Deleted User)
Date: 03 Feb 2006 04:32 PM
Hi, Howard.

Try forcing the connection to a specific database by adding the DatabaseName= parameter to the Server URL specified in the Connection Settings. (You can find more information about these and other DB2 connection settings here: http://www.stylusstudio.com/doc/jdbcug.pdf.)

For example:
//localhost:50000;DatabaseName=JSDB;locationName=;collectionId=;packageName=

Also, make sure that the locationName you specify is correct.

If that works, you can use the URL builder inside the XQuery Mapper to accomplish what you want. A video demonstrating this process is here:
http://www.stylusstudio.com/videos/dbtoxml2/dbtoxml2.html. (It shows the XSLT Mapper, but the principles are the same.)

Hope this helps.

David Foster
Stylus Studio Team

Postnext
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 04 Feb 2006 02:22 PM
Hi David,

This new setting doesn't work either. I don't think it is used with the iSeries, at least from what I read in the referenced manual.

Here is the Server URL I am using;

//iSeries400:446;locationName=S105ZZRM;collectionId=JSDB;packageName=JDBCPKG

iSeries400 is the name used on this PC to access the iSeries (defined in the HOSTS table).

Port 446 was verified using NETSTAT

S105ZZRM is the name that is shown using WRKRDBDIRE

JSDB is the name of the Database I want to access.

I do get a connection, but the only thing that shows as a Database is S105ZZRM, the other databases do not appear with the proper icon.

I also reviewed the video tutorial suggested, but did not see how to map multiple tables to a single XML document using a provided schema.

Howard

Postnext
(Deleted User) Subject: ODBC Connection refused
Author: (Deleted User)
Date: 06 Feb 2006 09:48 AM
Hi, Howard. We're talking with the DataDirect JDBC team to understand what the problem is and how to correct it. We'll post as soon as we have something to tell you.

David Foster
Stylus Studio Team

Postnext
Ivan PedruzziSubject: ODBC Connection refused
Author: Ivan Pedruzzi
Date: 07 Feb 2006 08:35 AM
Howard,

Please try changing the locationName=JSDB.

The JDBC team is telling us that ISeries 400 supports only one database per machine where locationName is the database name.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 07 Feb 2006 12:39 PM
Hi Ivan,

No luck. Error message "Remote Database not found".

I have tried to duplicate your solution from 1 year ago as suggested by David and have followed the advice parameter by parameter.

Here is the Server URL I am using;

//iSeries400:446;locationName=S105ZZRM;collectionId=JSDB;packageName=JDBCPKG

iSeries400 is the name used on this PC to access the iSeries (defined in the HOSTS table).

Port 446 was verified using NETSTAT

S105ZZRM is the name that is shown using WRKRDBDIRE

JSDB is the name of the Database I want to access.

I changed 'locationName=JSDB' and received the error message above.

When I use the above URL I get a successful connection, I see S105ZZRM as a database. When I expand S10ZZRM is see JSDB, but it does not show as a Database (no DB icon) and my tables do not appear when expanding JSDB.

Howard

Postnext
Ivan PedruzziSubject: ODBC Connection refused
Author: Ivan Pedruzzi
Date: 07 Feb 2006 02:02 PM
Howard,

From what I am gathering the database name is correct (S105ZZRM).
Given that fact that DB2 supports only one database per server, JSDB has to be something else.
Could it be a collection?

How do you determine that JSDB is a database on server Series400:446?

What you see in the tree control named JSDB (your screenshot) is a schema that seems to have only one table associated to it.

Could be possible that the JSDB database is mounted from a different server, in other words it physically resides on another machine?
If that is the case you will need to connect to the machine where the database lives.

Ivan Pedruzzi
Stylus Studio Team

Posttop
Howard KruppSubject: ODBC Connection refused
Author: Howard Krupp
Date: 07 Feb 2006 04:07 PM
Hi Ivan,

S105ZZRM is the name of the one and only server. It is not a "database".

JSDB is a 'library' on the server which contains a Database. This database contains hundreds of tables.

I have reviewed all the settings in our functioning ODBC connection and find no reference to a "collection".

Howard

 
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.