|
|
 next
|
  Subject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 24 Feb 2005 11:34 AM
|
Ivan,
I am still experiencing difficulty in connecting to my database on the AS/400. I have been going through the documentation you sent me yesterday, however, it really hasn't been that helpful. It references tools that I don't have (i.e. DataDirect Test, DataDirect DB2 Package Manager). I assume this is because we are only privliged to a subset of the DataDirect functionality (This makes using their documentation very difficult). So, I've being trying to establish a connection using a connection string, however I don't fully understand the the parameter meanings (documentation is not very clear with the definitions given) and what might be valid values. Below is a list of the parameters and values I am trying to use, maybe you can give me some pointers on what I might be doing wrong.
Server URL: //BIJOUX;locationName=Z_VMV;collectionId=DEFAULT;packageName=JDBCPKG;CreateDefaultPackage=TRUE
//BIJOUX; Name of my AS/400 (I tried using the IP address, specifying ports, get the same error message every time)
locationName=Z_VMV; Library on AS/400 where the tables I want to convert to XML exist?
collectionId=DEFAULT; Not really sure what this value should be?
packageName=JDBCPKG;
CreateDefaultPackage=TRUE Set to true for initial connection, set to false thereafter
I keep getting the following error message:
java.sql.SQLException: [StylusStudio][DB2 JDBC Driver]Error establishing socket. Connection refused: connect
at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.stylusstudio.DataDirectStub.connect(DataDirectStub.java:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)
I was thining this was a security issue on the AS/400 side, but my admin gave me full authority to EVERYTHING.
I'm totally stumped... Please help.
Thank you,
Vincent
>To use DB2 select IBM DB2 as
>Database type; the URL should
>look like this
>
>//localhost:50000;locationName
>=;collectionId=;packageName=
>
>Take a look to your ODBC data
>source settings
>to figure out the parameter
>value to pass
>
>In my previous post I also
>pointed to the JDBC user guide
>to have a better understanding
>of Stylus Studio DB2 support.
>
>Ivan
>
|
|
|
|
|
StylusStudio1.doc
top