RE: iSeries and JTDS

[Jay <tegger@xxxxxxxxxxx>]

The user ID and password do exist on the new server.
The server has been setup with SQL Server Authentication as our time clock processes wouldn't work without it.


> On October 18, 2017 at 11:06 AM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
>
>
> I use jTDS on SQL Server 2000 thru 2012, with no change required.  
>
> I'd start on the SQL Server side.  Are they allowing SQL Server Authentication (I think it's off by default)?  Does your user exist on the new server?
>
>
>
> -----Original Message-----
> From: Jay [mailto:tegger@xxxxxxxxxxx] 
> Sent: Wednesday, October 18, 2017 8:59 AM
> To: 'RPG programming on the IBM i (AS/400 and iSeries)' <rpg400-l@xxxxxxxxxxxx>
> Subject: iSeries and JTDS
>
> Overnight, our SQL server was upgraded from 2005 to 2012.
>
> Now, routines we had running that read the SQL databases for different things aren't working as an instance name was added when the new server was setup.
>
>  
>
> Now, we get connections refused everywhere.
>
>  
>
> I moved us to up to jtds 1.3.1 from jtds 1.2.5. No change.
>
>  
>
> Changed the connection code:
>
> prop = JDBC_Properties();                                    
>
> JDBC_setProp(prop: 'user'         : %trim(userStr));         
>
> JDBC_setProp(prop: 'password'     : %trim(passwordStr));     
>
> JDBC_setProp(prop: 'databaseName' : %trim(dbnameStr));       
>
> JDBC_setProp(prop: 'instance'     : 'MSSQL2012'     );       
>
> conn = JDBC_ConnProp('net.sourceforge.jtds.jdbc.Driver'      
>
>                      :%trim(connectStr)                      
>
>                      : prop );                               
>
>  
>
> Connection still refused.
>
> Any ideas?
>
>  
>
> The connection string itself is jdbc:jtds:sqlserver://JJSQLSRV01:1433    
>
> I've tried putting ";instance=MSSQL2012" at the end of it.
>
>  
>
>  
>
>  
>
> Jay
>
>  
>
>
> -- 
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-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