×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi David,
I did get it to work by setting the Classpath. However it did not seem to work 'out of the box' when I placed the .jar into the path you mentioned.
For some reason I have JDBC_Connect() working when JDBC_ConnProp() was not. I can followup about that later (next week maybe). For now, success! Thanks to Scott for the JDBCR4 service program.
-Kurt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of David Sager
Sent: Friday, October 21, 2011 3:27 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: JDBC4R - Issue finding driver
Kurt,
Try placing the jar file in /QIBM/UserData/Java400/ext as that's always included in the Classpath. This will confirm whether or not it's something in your environment variables or another issue.
hth!
date: Fri, 21 Oct 2011 14:34:23 -0500
from: Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx>
subject: JDBC4R - Issue finding driver
I'm trying to setup connections to our SQLServer 2005 & 2008 servers.
I'm not at all familiar with JDBC stuff or setting up java. I've been following Scott's presentation:
http://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf
I downloaded the jtds jar and placed it in the IFS root in a folder called
/java/jdts/
The jar is jtds-1.2.5.jar. I thought I'd rename it to try jtds.jar as
well. Since it wasn't working I didn't know if I needed the /java/jdts/
under the Home directory in the IFS so I put it there as well.
As an Amazon Associate we earn from qualifying purchases.