CODEWITHSUNDEEP
javasql-serverjdbc
biju_c
biju_c

Reputation: 11

mssql-jdbc-6.3.4.jre8-preview.jar does not have sqljdbc_auth.dll

I am using JDBC in my code and I get this error:

Sep 24, 2019 9:01:47 AM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path

I understand to fix this, the path of sqljdbc_auth.dll must be given in java library path.

But when I extracted my JDBC jar (mssql-jdbc-6.3.4.jre8-preview.jar), I could not find sqljdbc_auth.dll at all inside it.

What do I do now? Pls help!

Upvotes: 0

Views: 194

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 109144

As documented on the project page of the Microsoft SQL Server JDBC driver, https://github.com/Microsoft/mssql-jdbc, you need to manually download them:

Download the DLLs

For some features (e.g. Integrated Authentication and Distributed Transactions), you may need to use the sqljdbc_xa and sqljdbc_auth DLLs. They can be downloaded from the Microsoft Download Center

That link actually points to an installer (self-extracting zip) of the JDBC driver. This installer contains the DLLs. If you're using a different version, you may need to find the installer of that version in the Microsoft Download Center.

Upvotes: 1

Related Questions