What is ODBC used for? Include in your post and explanation of ODBC and the security...

What is ODBC used for? Include in your post and explanation of ODBC and the security concerns with ODBC.

Solutions

Expert Solution

What is ODBC used for ?

An ODBC driver uses the Open Database Connectivity (ODBC) interface by Microsoft that allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data. ODBC permits maximum interoperability, which means a single application can access different DBMS.

Explanation of ODBC and the security concerns with ODBC.

ODBC does not encrypt your data for transmission, so to provide security for the database traffic you need to tunnel the ODBC traffic through the network using Secure Shell, Secure Sockets Layer, Point-to-Point Tunneling Protocol/Layer 2 Tunneling Protocol or IPSec. Depending on your wireless configuration, you might have some protection in place for wireless traffic. If you have a VPN, you usually can use that to create encrypted connections between systems in your network and from outside.

If you are starting from scratch you can create point-to-point SSH tunnels with OpenSSH or one of the commercial SSH packages. Or if both systems run Windows, you can build SSL VPN tunnels using OpenVPN or the Microsoft VPN tools found under Dial Up Networking to establish secure connections between clients and server for your ODBC traffic. SSH port forwarding is fairly easy to implement if you are an administrator for only a few connections.

venereology answered 3 months ago

Next > < Previous

Related Solutions

What is the flexible budget? Include in your post an explanation of how sales revenue, variable...

What is the flexible budget? Include in your post an explanation of how sales revenue, variable costs and fixed costs are calculated for the flexible budget. Also, explain the master budget variance, volume variance and flexible budget variance.

Post a brief post introducing yourself to your colleagues. Include an explanation for how Walden’s vision,...

Post a brief post introducing yourself to your colleagues. Include an explanation for how Walden’s vision, mission, goals, and social change initiatives relate to your professional and academic goals and to your becoming a scholar-practitioner. Also include an explanation for how the Walden MSN program outcomes and perspectives relate to your professional and academic goals and to your becoming a scholar-practitioner.

Post to the following topic. Your post must include the web sites of the research used...

Post to the following topic. Your post must include the web sites of the research used in your discussion. Your post should be at least one well-developed page (300-350 words). Is college worth the cost? Cite your resources.

Do a research and review information about the HIPAA Security Rule. In your post, include the...

Do a research and review information about the HIPAA Security Rule. In your post, include the following information: Discuss the impact of these security regulations on healthcare organizations. How have these regulations changed the way organizations view security? Do you think the regulations are too stringent, not enough, or just right? Explain your rationale.

Post your article here and include the following information in your post: 1. What is the...

Post your article here and include the following information in your post: 1. What is the article about? 2. What did you learn? 3. How does it relate to the readings from the book this week? This discussion for the class BU 491Management Issues and Society

How are Social Security benefits calculated for married couples (your explanation should include a definition of...

How are Social Security benefits calculated for married couples (your explanation should include a definition of the terms AIME and PIA)? Explain the equity considerations of this system (who gets the best and worst returns on their taxes paid into the system with respect to income and marriage)?

Question