Re: RPG - MsSQL Connection

[Chamara Withanachchi <chamaraw@xxxxxxxxxx>]

Scott,

I have changed the driver to jtds and connection string as following

       prop = JDBC_Properties();
         // JDBC_setProp(prop: 'userName'     : 'sa');
         JDBC_setProp(prop: 'user'         : 'sa');
         JDBC_setProp(prop: 'password'     : 'sdb#123');
         JDBC_setProp(prop: 'databaseName' : 'testDB');

         //conn =
JDBC_ConnProp('com.microsoft.sqlserver.jdbc.SQLServerDriver'
         //                    :'jdbc:sqlserver://10.100.19.36:1433'
         //                    : prop );
         conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'
                             :'jdbc:jtds:sqlserver://10.100.19.36:1433'
                             : prop );
         JDBC_freeProp(prop);


but now I'm getting the following error.

call sqltest
     Printer device PRT01 not found. Output queue changed to QPRINT in
library
       QGPL.

     Environment variable added.

     Java Virtual Machine is Classic.

     Java exception received when calling Java method.

     The Java Virtual Machine has ended.

     Application error.  MCH74A5 unmonitored by QJVAJNICLS at statement

       0000000001, instruction X'0000'.

     Pointer not set for location referenced.

     Application error.  MCH3601 unmonitored by QJVAJNICLS at statement

       0000000001, instruction X'0000'.

     Unable to create Java Virtual Machine.

     Unable to create Java Virtual Machine.

     Pointer not set for location referenced.

     Unable to create Java Virtual Machine.

     Unable to create Java Virtual Machine.

     Pointer not set for location referenced.

     Unable to create Java Virtual Machine.

     Unable to create Java Virtual Machine.

     Pointer not set for location referenced.

     Pointer not set for location referenced.

     Function check. MCH3601 unmonitored by QRNXUTIL at statement
0000000018,
       instruction X'0000'.

     The call to JDBC_FREER ended in error (C G D F).


Thanking You

Chamara
On Fri, Sep 10, 2010 at 10:54 PM, Scott Klement
<rpg400-l@xxxxxxxxxxxxxxxx>wrote:

> Chamara,
>
> You simply haven't provided me with any information.  I know exactly two
> words about your situation, and they are 'Unrecoverable Error'.
>
> Put yourself in my position.  I've never worked with a Microsoft
> Database, you're running a version of the JDBC drivers that I've never
> seen, I don't have the program in front of me that I can do any sort of
> troubleshooting or experimenting to try to find the error.  I don't even
> know what your code looks like (though, knowing that probably wouldn't
> help.)
>
> All I know is 'Unrecoverable Error'. Would you be able to solve a
> problem given that situation?
>
> My suggestion at this point:  Try the jTDS driver.  Many people have had
> better luck with jTDS vs. the Microsoft driver, because it's developed
> in a cross-platform method.
>
> Maybe it'll at least give you a more useful error message.
>
>
> On 9/9/2010 10:58 PM, Chamara Withanachchi wrote:
> > Can you please tell me what is the wrong im my code (Im using your JDBCR4
> > Service program)
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.