Error expanding views in Data Object Tree

I connect fine, can view tables in the Data Object Tree. But when trying to expand the Views, I get this error: DBVIS [SQL 0301] Input host variable *N or argument 2 not valid. I've tried google and searching this site but can't find anything. Any help appreciated, what the cause is, where to look, etc. Quick update, trying to double click the "view" icon in the Object tree I get the following error: An internal error occurred in: com.onseven.dbvis.sql.M: java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. The error may have affected the application state. Please to vendor. Long Message: [SQL0301] Input host variable *N or argument 2 not valid. Details:    Type: com.onseven.dbvis.sql.M Stack Trace: com.onseven.dbvis.sql.M: java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid.    at com.onseven.dbvis.db.AbstractFacade.getTables(Z:456)    at com.onseven.dbvis.J.B.N.ā(Z:792)    at com.onseven.dbvis.J.B.N.execute(Z:315)    at com.onseven.dbvis.J.B.Y.ā(Z:1386)    at com.onseven.dbvis.J.B.Y.run(Z:337)    at com.onseven.dbvis.J.B.B.ঐ(Z:3320)    at com.onseven.dbvis.J.B.B.execute(Z:1626)    at com.onseven.dbvis.J.B.Y.ā(Z:1386)    at com.onseven.dbvis.J.B.K.Ă(Z:1374)    at com.onseven.dbvis.J.B.K.doInBackground(Z:1521)    at javax.swing.SwingWorker$1.call(Unknown Source)    at java.util.concurrent.FutureTask.run(Unknown Source)    at javax.swing.SwingWorker.run(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid.    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:703)    at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4758)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)    at java.lang.reflect.Method.invoke(Unknown Source)    at com.onseven.dbvis.g.B.E.ā(Z:3526)    at com.onseven.dbvis.g.B.F$A.call(Z:1474)    at java.util.concurrent.FutureTask.run(Unknown Source)    ... 3 more System Information: Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 Edited by: Ric Roades on Jul 28, 2014 7:47 PM

I don't know, but doubt it. Will try to find out. It's an old server that all the data is being archived, which is the project I'm on. Since there are no updates to the apps on it, I think its unlikely they would be updating OS, etc. on it. But will try to find out. But another aspect of this, as I was looking around at it... I used to be able to connect to an ODBC/JDBC source on the server from which I'm running DBV. These are both problems that did not exist. Could it be something in the DBV installation? It seems when connecting to that we get the a media error, link severed. I didn't see anything really in the DBV log, so included the JDBC Driver log: ------------------------- Product Information ------------------------ Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: Generic Major Version: 6 Minor Version: 1 Profile: generic Connection Message: SSA 06.01.02.13324 JDBC-ODBC Bridge (sando.dll) 2.0001 (06.01.02.13117) --------------------------- Debug Printouts -------------------------- *DatabaseMetaData.getSchemas *DatabaseMetaData.getTables (,%,,null) Allocating Statement Handle (SQLAllocStmt), hDbc=6223856 hStmt=6224592 Tables (SQLTables), hStmt=6224592,catalog=, schema=%, table=, types=null Number of result columns (SQLNumResultCols), hStmt=6224592 value=5 *ResultSet.getMetaData *ResultSetMetaData.getColumnName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=1 value (String)=TABLE_SCHEM *ResultSetMetaData.getColumnLabel (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=18 value (String)=TABLE_SCHEM *ResultSetMetaData.getTableName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=15 value (String)= *ResultSetMetaData.getColumnTypeName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=14 value (String)=VARCHAR *ResultSetMetaData.getColumnDisplaySize (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=6 value (int)=128 *ResultSetMetaData.isNullable (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=7 value (int)=0 *ResultSetMetaData.getColumnType (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=2 value (int)=12 *ResultSetMetaData.isAutoIncrement (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=11 value (int)=0 *ResultSetMetaData.getPrecision (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=4 value (int)=128 *ResultSetMetaData.getScale (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=5 value (int)=0 Fetching (SQLFetch), hStmt=6224592 Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=2 value (int)=12 Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=3 value (int)=128 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 AP#FILEM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2006 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2007 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2008 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CAL_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2006 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2007 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1997 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1998 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2000 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2001 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2002 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BESTSYS1 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 CADBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 CLOCFL00M7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 DBA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 DBO Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 EHSWTK Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 EXDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FADBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FADV333 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY10_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY11_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY12_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY13_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GLCUST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GLDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GTDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCUST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV707 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV888 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV707 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV888 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 ICDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 ILM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 IRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 JPDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 MA#FILEM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_FY08 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PFM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PFM_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PLDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMM_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PUBLIC Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PX2000 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SAGE_FAS1 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SDS_REPOSITORY Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SETNPROD Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SETON_FY09 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SSA_SERVICE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SSDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SYSTEM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TE70MHR Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TE712HR Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMECUSTM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMEGLOBM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMEKEEPM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TKCSOWNER Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TXAUS Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 VILM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 WFCDB Fetching (SQLFetch), hStmt=6224592 End of result set (SQL_NO_DATA) *ResultSet.close Free statement (SQLFreeStmt), hStmt=6224592, fOption=1 *ResultSet has been closed *DatabaseMetaData.getTableTypes *DatabaseMetaData.getTables (null,null,%,null) Allocating Statement Handle (SQLAllocStmt), hDbc=6223856 hStmt=6224592 Tables (SQLTables), hStmt=6224592,catalog=null, schema=null, table=%, types=null Number of result columns (SQLNumResultCols), hStmt=6224592 value=5 *ResultSet.getMetaData *ResultSetMetaData.getColumnName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=1 value (String)=TABLE_TYPE *ResultSetMetaData.getColumnLabel (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=18 value (String)=TABLE_TYPE *ResultSetMetaData.getTableName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=15 value (String)= *ResultSetMetaData.getColumnTypeName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=14 value (String)=VARCHAR *ResultSetMetaData.getColumnDisplaySize (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=6 value (int)=256 *ResultSetMetaData.isNullable (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=7 value (int)=0 *ResultSetMetaData.getColumnType (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=2 value (int)=12 *ResultSetMetaData.isAutoIncrement (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=11 value (int)=0 *ResultSetMetaData.getPrecision (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=4 value (int)=256 *ResultSetMetaData.getScale (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=5 value (int)=0 Fetching (SQLFetch), hStmt=6224592 Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=2 value (int)=12 Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=3 value (int)=256 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 RETCODE = -1 ERROR - Generating SQLException... SQLState(08S01) vendor code(531457) java.sql.SQLException: [ODBC][Nucleus ODBC Driver][TXAUS Kronos FAS]Communication media error. Link severed at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLFetch(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.next(Unknown Source) at com.onseven.dbvis.J.B.U.?(Z:3187) at com.onseven.dbvis.J.B.U.?(Z:2910) at com.onseven.dbvis.J.B.Y.processResultSet(Z:2773) at com.onseven.dbvis.J.B.Y.processResultSet(Z:1331) at com.onseven.dbvis.J.B.N.?(Z:848) at com.onseven.dbvis.J.B.N.execute(Z:726) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.Y.run(Z:337) at com.onseven.dbvis.J.B.B.?(Z:3320) at com.onseven.dbvis.J.B.B.execute(Z:1626) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.Y.run(Z:337) at com.onseven.dbvis.m.A.K.?(Z:1170) at com.onseven.dbvis.m.A.K.?(Z:76) at com.onseven.dbvis.m.A.K.execute(Z:258) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.K.?(Z:1374) at com.onseven.dbvis.J.B.K.doInBackground(Z:1521) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) *ResultSet.close Free statement (SQLFreeStmt), hStmt=6224592, fOption=1 *ResultSet has been closed

I realize this is now an old thread, but being on a client server and project demands, I've just now been able to install an older version - 9.0.9. It's release date was 8/2013, which I know we were working at that time. All this has been on a DEV server - I also tried v8.0.n on a Prod server, same issue. At this point, I think it must be environment. I'll review earlier suggestions for environment variables discussed. Thanks... Edited by: Ric Roades on Sep 16, 2014 5:00 PM

Oh - sorry. The local DSN is on a Windows 2008 R2 server. The database is a proprietary source by Informatica. They supply a driver which we use to create the ODBC DSN. We connect to AS/400, Oracle, SQL Server with DBV across the network.

Haven't had time yet to try the older version. Hate it when work gets in the way! On the ODBC/JDBC bridge for the local source, unfortunately, their instructions say to make an ODBC DSN, with the driver being their driver. I'm not sure how else to do that.

Thanks again, Roger. Correct, upgrades to DBV. I don't know exactly when it stopped, as it worked on an AS/400 project phase, we moved on, then came back to that some months later, and I know the personal version of DBV was upgraded over time, then I purchased it. So don't know what version last worked. But yes, it appears it's all of our AS/400 connections, Oracle seems ok, so far, but I also used to use it with a proprietary ODBC/JDBC driver for a db local to the server DBV runs on. That quit working, as well. So I will try an older version - what about the purchased license? Will it matter?

According to my contact at the client, there have been no upgrades on the AS/400. I'm open to any other suggestions.

I do get the error when expanding views from a schema with NO special characters. Tried one with @, and one called A3EP, both get the error. I copied the jt400.jar into the DBV directory as below: