Re: sqlserver JDBC driver problem.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lew wrote:
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.

I think it's a terrible idea to put application code in the Win system
directory. It's one of my bugbears with Windows that everyone does that.

OTOH, everyone does that. Just heaven help you if you ever have to to
upgrade Windows, or to re-install it, not that Windows is ever unstable
enough that you'd ever need to do that, ever.

Yet another reminder why *nix is a superior OS. a link to a directory
in the path would have been the only way to do it.

You never hear a windows guy talk about uptime ;)

The solution worked, thanks guys.

This leads me to another question, There are obvious issues with
deployment with this setup. Assume this app will be made available to a
few hundred users (employees).
So is there a way to create a static link a win32 DLL file and the JAR
file as if I wrote it myself? or is it any better to create a folder
with the files in it and add the path to the path variable upon
installation?

Let me know what you think, im curious about your opinions.

~MS


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHSFHl9v5kFOkJa9gRAkB+AKCYcBv6uD4kIbc6+o+E7UgmuWRYCgCfY9jp
6Jq0bQS1vc5cERj957R266E=
=yxGx
-----END PGP SIGNATURE-----
begin:vcard
fn:Matthew Shelton
n:Shelton;Matthew
adr;dom:;;;Philadelphia;PA
email;internet:crash700@xxxxxxxxx
x-mozilla-html:FALSE
version:2.1
end:vcard