Re: sqlserver JDBC driver problem.



Lothar Kimmeringer wrote:

Matthew Shelton wrote:

I'm liking eclipse a little better as an IDE, but for my own piece of
mind, how the *** do you get the classpath to work in netbeans?

I left with the "failure to load sqljdbc_auth.dll" error, thats when I
switched to eclipse and got it working.

The DLL must reside in a directory that is part of the PATH-
variable and not the classpath. Maybe Eclipse is adding the
classpath to the PATH-variable.

Putting the DLL inside %WINDIR%/system32 should work for all
IDEs but you have to cope with the DLLs agein when deploying.


Regards, Lothar

You can keep the dlls in the same directory as the application jar file
(not the lib/ subdirectory).

This also works with "regular" windows applications, but it does look in
its own directory last, so if the dlls are also in system32, you might
have version problems.

I always "package" dlls to reside in the application directory. Haven't
had issues yet, but YMMV.
--
Sabine Dinis Blochberger

Op3racional
www.op3racional.eu
.