RE: Accesssing External Databases -- MIDRANGE-L

Thanks for your reply Jerry
That is exactly what I have
Here is the code

prop = JDBC_Properties();
JDBC_setProp(prop: 'userName' : 'As400_login');
JDBC_setProp(prop: 'password' : 'alanshoreiscool');
JDBC_setProp(prop: 'databaseName' : 'DirectResponseAdmin');

conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
:'jdbc:jtds:sqlserver://WBOHQECDB01:1433'
: prop );

I don't know which of my earlier e-mails you are responding to, but here is the latest steps that I took

I started from scratch again
1. I downloaded the latest jTDS Open Source driver for MS SQL Server from
http://jtds.sourceforge.net

2. From this unzipped download, I placed the jtds-1.3.1.jar file in the ifs directory '/java/jdbc'

3. I executed the command
ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jdts-1.3.1.jar')

4. I changed my program to the following - its trying to connect to a MS SQL server

prop = JDBC_Properties();
JDBC_setProp(prop: 'userName' : 'As400_login');
JDBC_setProp(prop: 'password' : 'alanshoreiscool');
JDBC_setProp(prop: 'databaseName' : 'DirectResponseAdmin');

conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
:'jdbc:jtds:sqlserver://WBOHQECDB01:1433'
: prop );

Then I ran the program
Its failing

This is what is being displayed

The java.version property was detected as input. This property is used as output only and has no effect on JVM initialization.
Exception in thread "main" java.lang.NoClassDefFoundError: net.sourceforge.jtds.jdbc.Driver
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:499)
at java.lang.ClassLoader.loadClass(ClassLoader.java:651)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:617)

Anyone see what I am doing wrong?
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gerald Kern
Sent: Wednesday, September 13, 2017 3:23 PM
To: Midrange <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accesssing External Databases

This is the value we use for the driver parm for JDBC_ConnProp.

net.sourceforge.jtds.jdbc.Driver

And it connects to our MS SQL servers on V7R1 and V7R2.

--
Thanks, Jerry

Gerald Kern
I.T. Manager
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623
Phone 419-479-5535
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD