Solved

encrypt connection between ms access and sql database backend

Posted on 2014-10-17
2
177 Views
Last Modified: 2014-10-17
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
Comment
Question by:RDLFC
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40386838
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
 

Author Comment

by:RDLFC
ID: 40387258
thanks, that was simpler than I thought.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question