Sujet : Re: Accessing MS SQLServer from VMS in a JVM language
De : arne (at) *nospam* vajhoej.dk (Arne Vajhøj)
Groupes : comp.os.vmsDate : 27. Aug 2024, 02:33:26
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vajad6$2lbos$1@dont-email.me>
References : 1 2
User-Agent : Mozilla Thunderbird
On 8/26/2024 9:17 PM, Craig A. Berry wrote:
On 8/26/24 7:44 PM, Arne Vajhøj wrote:
This is surprisingly easy:
No surprise. It was easy with jTDS 15-20 years ago, but I think that
driver is deprecated now.
Looks like last release is from 2013.
But it may still work fine. TDS is a very old protocol.
Using the official Microsoft driver is could be important for some though.
1) enable SQLServer authentication (Windows authentication only will not work)
It might be possible using pure-Java Kerberos, but getting that working
sounds like work:
https://learn.microsoft.com/en-us/sql/connect/jdbc/using-kerberos- integrated-authentication-to-connect-to-sql-server?view=sql-server-ver16
Yes.
The driver comes with:
mssql-jdbc_auth-12.2.0.x64.dll
mssql-jdbc_auth-12.2.0.x86.dll
which obviously will not work on VMS.
Arne
Accessing MS SQLServer from VMS in a JVM language
Re: Accessing MS SQLServer from VMS in a JVM language