dll missing in JDBC

Solution 1:

keep sqljdbc_auth.dll in your windows/system32 folder and it will work.Download sqljdbc driver from this link Unzip it and you will find sqljdbc_auth.dll.Now keep the sqljdbc_auth.dll inside system32 folder and run your program

Solution 2:

For easy fix follow these steps:

1. goto: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url#Connectingintegrated
2. Download the JDBC file and extract to your preferred location
3. open the auth folder matching your OS x64 or x86
4. copy sqljdbc_auth.dll file
5. paste in: C:\Program Files\Java\jdk_version\bin

restart either eclipse or netbeans

Solution 3:

Alright guys, I found it out! I didn't really need to change the java.library.path but the "Native library location" of sqljdbc.jar

This is the best answer I could find: https://stackoverflow.com/a/958074/2000342

It works now, thanks for the support!

Solution 4:

You need to set a -D system property called java.library.path that points at the directory containing the sqljdbc_auth.dll.