• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

encrypt connection between ms access and sql database backend

i currently use the connection string below when i connect to a sql database from the ms access db.  The connection string is used for passthrough queries and recordsets.  it works fine

Connection string
connstring = "Provider=SQLOLEDB;DRIVER=SQL Server;SERVER=" & serverip & ";UID=" & usernamewrite & ";PWD=" & passwordwrite & ";DATABASE=DBName"

I am not being asked to encrypt the connection I am making the sql server.  any advise on how to go about doing that?
0
RDLFC
Asked:
RDLFC
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You would add:

encrypt=true

to the connection string.  However note that this requires setup on the SQL Server and client (in the form of a SSL certificate) if that has not already been done:

Encrypting Connections to SQL Server
http://technet.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx

Jim.
0
 
RDLFCAuthor Commented:
thanks, that was simpler than I thought.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now