dll missing in JDBC
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
You need to set a -D system property called java.library.path
that points at the directory containing the sqljdbc_auth.dll
.
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!
For easy fix follow these steps:
- goto: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url#Connectingintegrated
- Download the JDBC file and extract to your preferred location
- open the auth folder matching your OS x64 or x86
- copy sqljdbc_auth.dll file
- paste in: C:\Program Files\Java\jdk_version\bin
restart either eclipse or netbeans