jTDS JDBC driver usage without ntlmauth.dll
Hi all,
i had many problems to creat an applet using MS sqljdbc.jar.....especially for signing the fat jar file. i got errors and no solution.
i found jTDS JDBC driver and it seems very good. my Applet works as far as i know ;-) , but requests that this "ntlmauth.dll" be installed locally on every PC.
hum...read the doc but i'm too blind or to dumb to understand it well...(cry)
Anybody got the same problem ? any helper for a newbee ?
Thx for all.
You might want to ask on the jTDS forum(s).
As a guess you are using NT authorization rather than database authorization. And to do that sort of auth it needs to access Win API calls, so it needs the dll.
One solution is to not use that sort of authorization. The other is to figure out how to download the dll via the browser.
Hi ,
try this ...
Class.forName("net.sourceforge.jtds.jdbc.Driver");
String connectionUrl = "jdbc:jtds:sqlserver://" + server + "/" + instance;
try {
Connection myCon = DriverManager.getConnection(connectionUrl,sqlUser,sqlUserPwd);
keep in mind that if you need a SQL securised connection you simply have to put the id and pwd values after the connectionURL (ie: in sqlUser and sqlUserPwd ) and if you want a NT authorization securised don't put those values but you 'll have to copy the ntlmauth.dll in the right place)
This is very easy once you 've made it;-)
'hoping this will help you.
