SQL Server Encryption?

[BaileyBurger]

Greetings!

We've been under greater scrutiny from our clients on security,
understandably. Our network guy tells us devrs that we need to start encrypting
the data stored in SQL server 2K, but I have no idea how this is done or how
this will effect our CF apps. I've been searching MSDN, but have not found
anything terribly useful. If anyone has suggestions on where I would find
practical, CF-based info, I'd grealy appreciate it!

TIA!

[BaileyBurger]

Greetings!

We've been under greater scrutiny from our clients on security,
understandably. Our network guy tells us devrs that we need to start encrypting
the data stored in SQL server 2K, but I have no idea how this is done or how
this will effect our CF apps. I've been searching MSDN, but have not found
anything terribly useful. If anyone has suggestions on where I would find
practical, CF-based info, I'd grealy appreciate it!

TIA!

[cjeris]

The Microsoft JDBC Type 4 driver for SQL Server does not support connecting to
SQL Server over SSL. Thank you very much Microsoft. A previous poster on this
forum (I can't remember the reference) suggested jTDS as an alternative JDBC
driver which does support SSL connections. It's free software:
[url]http://jtds.sourceforge.net/[/url]

[rich@tcaprint.com]

Hi-

I downloaded SourceForge's jTDS driver in hopes that it will satisfactorily
encrypt the DSN between our in house CF server and an exterior SQL Server that
requires encrypted transmissions. Does anyone know where exactly to place the
..jar file that comes with jTDS?

Thanks,

Rich