|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
Re: Secure connection to SQL Server from Perl DBI
|
On Thursday 28 May 2009, Eric Roode wrote:
> I need to connect to a secure SQL Server database using Perl DBI.
> I need to find a way to authenticate the user securely (without fear
> of eavesdropping, and without storing passwords on the client side).
> I'm using SQL Server 2008 on Windows Server 2008, and Perl 5.10 on XP.
>
> SQL Server supports encrypted connections via something called the
> "SQL Server Native Access Client API", but I cannot tell whether this
> is supported by any DBD driver, or how to use it if it is.
>
> I am reluctant to use the DBD::ODBC driver with SQL Server
> authentication, because ODBC transmits user IDs and passwords in
> cleartext.
Have you looked at DBD::Sybase? We use that where I work (for apache/mod_perl
with an MS-SQL backend). At least on linux you need freetds to talk the MSSQL
wire protocol, I don't know what the Windows client side would give you.
-
**Majordomo list services provided by PANIX <URL:http://www.panix.com>**
**To Unsubscribe, send "unsubscribe phl" to majordomo@lists.pm.org**
|
|