How to make an ODBC connection to a SQL Database

Need to make an ODBC connection to an SQL Database?   First off, what is it?  An ODBC connection uses SQL drivers to connect programs such as Microsoft Access to your database allow you to have a ‘front-end’ to develop forms and to perform queries of the database.

database_server arrow DesktopBlog

I wrote two articles several years ago for Bright Hub.   The first one was how to make a connection and the other was how to setup SQL to experiment and learn SQL.

Using Microsoft Access to Connect to a SQL Database

Setting Up Microsoft SQL 2008 in VirtualBox

Students who have access to DreamSpark can load SQL and Server 2008 on their computers in order to learn Server and SQL.   How do you learn about making queries with SQL’s query analyzer or how to make tables?   Use

Other articles –
Check Your Online Database with SQL Injections – HP Scrawlr

Protecting Your SQL Database with Security Roles

Hardening Your SQL Server

SQL Server 2005 and SQL Server 2008 Encryption

Protecting your SQL Server

Is your SQL connection slow?

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computers and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s