By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,973 Members | 1,901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,973 IT Pros & Developers. It's quick & easy.

JDBC and AS400

P: 1
Hi,
I am using com.ibm.as400.access.as400JdbcDataSource(Jt400.jar ) to read data from DB2 on AS400 V5R3. But here binary is not getting translated. when tried on V5R1 it works. ie binary is getting translated.
I tried even setting the property translateBinary = true, but no luck.
Is there any specific settings required for AS400V5R3.Any Idea?

Thanks in advance
-BR
Sep 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: 18
Assuming you are working in a Windows environment, it might be a better idea to use a different approach. Instead of connecting to the DB2 database directly with IBMs JDBC driver, try using a Windows ODBC driver for DB2 to create an ODBC data source in Windows. Then use the JDBC/ODBC bridge to connect to the ODBC source. Generally, I have found that the more advanced features are better supported in the ODBC drivers than in the JDBC drivers in most packages. (The exception is Progress where the ODBC driver is crap and the JDBC driver is the only thing that works!)
Oct 5 '05 #2

Post your reply

Sign in to post your reply or Sign up for a free account.