freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Using SSL With DBLIB/TinyTDS

From: Ken Collins <ken AT metaskills.net>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [freetds] Using SSL With DBLIB/TinyTDS
Date: Mon, 11 Apr 2011 13:08:50 -0400

So I was testing the latest 0.91 with "Forced Encryption" turned on at the
server level. And I monitored my network traffic and saw that indeed I was
getting a secure connection. My question is, is there a way to specify this
at the client level? In my code I have:

DBSETLDBNAME(login)

If the user specifies a :secure option. But it will not encrypt, only when I
set the server to force clients. I can verify that my DBLIB connection is in
plain text by doing a test query like "SELECT N'secret' AS [password]". Is
this expected behavior? What should DBSETLDBNAME do?

- Ken

[freetds] Using SSL With DBLIB/TinyTDS, Ken Collins, 04/11/2011
- Re: [freetds] Using SSL With DBLIB/TinyTDS, James K. Lowden, 04/12/2011
  - Re: [freetds] Using SSL With DBLIB/TinyTDS, Ken Collins, 04/12/2011
    - Re: [freetds] Using SSL With DBLIB/TinyTDS, James K. Lowden, 04/13/2011