RE: Encrypting data over the network

From: Farooq Mahmud [MS] (farooqm_at_online.microsoft.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 00:43:15 GMT

Hello Tony,

Encryption between SQL Server and clients occurs at a layer below ADO and
ODBC. Check out the following article which describes how to encrypt
communications between SQL Server and clients:

276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553

With this set it won't matter if the application uses ODBC or ADO.

Hope this helps,
Farooq Mahmud
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no
rights.

Relevant Pages

  • Re: Connection from ASP- ODBC vs. SQLOLEDB
    ... The ASP code is already using ADO (adodb.connection, ... The new provider is better than ODBC isn't it, ... SQL Server Client Network Utility- "Enable Shared Memory": ... ASP, ASP.NET as well as Microsoft Content Management Server 2002 SP1a. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Heres a rather broad question...
    ... ADO.NET and not its predecessor, will they fix any ADO problems that arise? ... authentication or permission issues with SQL Server 2000. ... The only thing I would say is that Microsoft have frozen development on ODBC ...
    (microsoft.public.data.ado)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... My fix was to use ADO ... With ODBC the connection remains open the ...
    (comp.databases.ms-access)