|
midrange.com
Mark,
I could not leave the schema blank or it fails. After I entered a library, I
got
Executing Request [SELECT * FROM ZNICOLAYP.QSOURCES]
Error occured: java.sql.SQLException: [SQL0901] SQL system error.
java.sql.SQLException: [SQL0901] SQL system error.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:388)
... when trying to connect.
Kind regards,
Paul
PS. Also an Oracle one which initially connects fine blows whenever I click on
a listed table. Guess I'll keep on using TOAD for now.
------------------------
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx> wrote:
------------------------
>Paul,
>
>Here is mine.
>
>*Bookmark Name - S1028570
>*Username - iSeries user profile
>*Password - iSeries password
> Schema (Optional) - Could be a library name. I leave it blank
>*Connect - jdbc:as400://xxx.xxx.xxx.xxx(iseries IP Address);translate
>binary=true
>*Driver - com.ibm.as400.access.AS400JDBCDriver
>*Type - Generic JDBC
>*Driver Filename - The path to your jt400.jar file. Mine is c:\program
>files\ibm\Client Access\jt400\lib\jt400.jar
>
>Thanks,
>
>Mark
>
>Mark D. Walter
>Senior Programmer/Analyst
>CCX, Inc.
>mwalter@xxxxxxxxxx
>http://www.ccxinc.com
>
>
>
>
> "Paul Nicolay"
>
>
> ora.be> cc:
>
> Sent by: Subject: Re: RE: [WDSCI-L]
> Re: Re: Need a bit of help . . .
> wdsci-l-bounces@xx
>
> drange.com
>
>
>
>
>
> 05/27/2003 10:17
>
> AM
>
> Please respond to
>
> Websphere
>
> Development Studio
>
> Client for iSeries
>
>
>
>
>
>
>
>
>
>Mark,
>
>Do you have a sample on what to fill in for an iSeries connection ?
>
>Thanks,
>Paul
>
>------------------------
> Websphere Development Studio Client for iSeries
>wrote:
>------------------------
>
>>Rick,
>>
>>If you downloaded a JAR file, chances are you downloaded the version for
>>Eclipse 2.1. You need to download Quantum Plugin 2.0.2 which is compiled
>>for Version 2.0 of Eclipse. The one in WDSc 5.0. It is a Zip file. You
>then
>>unzip the class files into the Eclipse plugin folder. On my system it is
>>c:/program files/ibm/websphere studio/eclipse/plugins. It should then be
>>there when you restart WDSc. The URL for the download page is
>>http://sourceforge.net/project/showfiles.php?group_id=7746&release_id=161251
>
>>
>>
>>Thanks,
>>
>>Mark
>>
>>Mark D. Walter
>>Senior Programmer/Analyst
>>CCX, Inc.
>>mwalter@xxxxxxxxxx
>>http://www.ccxinc.com
>
>
>
>_______________________________________________
>This is the Websphere Development Studio Client for iSeries (WDSCI-L)
>mailing list
>To post a message email: WDSCI-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
>or email: WDSCI-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/wdsci-l.
>
>
>
>
>_______________________________________________
>This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing
>list
>To post a message email: WDSCI-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
>or email: WDSCI-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/wdsci-l.
>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
