Re: Accesssing External Databases

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Appears that you didn't add the JDBC driver to your classpath...

You might want to investigate Deiter's ArdGate...
https://sourceforge.net/projects/appserver4rpg/

Allows for simple embedded SQL usage..

Charles


On Wed, Sep 13, 2017 at 8:57 AM, Alan Shore <ashore@xxxxxxxx> wrote:

> Hi everyone
> Before I forget, we are on V7r1
>
> I have been asked to investigate how we can connect to an external database
> Google search presented the following web page
> http://www.scottklement.com/jdbc/
>
> Scott Klements - Accessing External Databases from RPG
>
> Thank God for Scott
>
> I am following his pdf presentation and I am somewhat sure that everything
> is loaded into our test system
> Using one of his examples to access an SQL server database
> I changed the connection string and the username and password and ran the
> example program in debug mode
> It is failing
> With
>
> Exception in thread "main" java.lang.NoClassDefFoundError:
> com.microsoft.sqlserver.jdbc.SQLServerDriver
> Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.
> SQLServerDriver
>         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)
>
> As this is ALL brand new to me - where do I even START to look at what my
> problem is?
>
> As always - any and all help REALLY appreciated
>
>
>
> 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
>
> --
> 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