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".
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?
Subject: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.
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?
Subject: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.
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.)
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.
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.
Subject: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.