How to Setup an ODBC Data Source

The first step in setting up an ODBC data source on your Windows machine is finding the Data Sources control panel option. On Windows XP and older machines, the Data Sources control panel is located in the Control Panel - Administrative Tools - Data Sources shortcut. For Windows Vista, to get to the Data Sources control panel, go to the Control Panel window, click the link to show the classic view, and then select Administrative Tools and Data Sources.

If you are running a 64-bit operating system, and you would like to set up a 32-bit ODBC datasource, there is a different location from which the Data Sources control panel must be launched. Here is an example of the location on a Windows Vista 64-bit machine:

C:\Windows\SysWOW64\odbcad32.exe

Here is a screen shot of the Data Sources control panel on Windows Vista:

ODBC Data Source 1

Once the Data Source window has been opened, the Add button can be clicked to add a new data source. A new window will display with all of the available ODBC drivers that are installed on your machine. Below is an example screen shot:

ODBC Data Source Add

Look in the list for the type of database you want to set up a database for, for example, Microsoft Access Driver, Microsoft dBase Driver, SQL Server Native Client, etc. Once you find the appropriate option, click Finish.

At this point, another new window will display with database specific fields. For example, the SQL Server Native client will ask you the name, description, and SQL Server instance to connect to. The Microsoft Access driver will prompt you for the location of teh .mdb Access file, etc. Enter the appropriate information, and remember what you named the data source. Click Finish.

At this point, the new data source is created. Depending on the data source, there may be an option to test the data source. It is a good idea to make sure the test is successful before trying to connect with RazorSQL.

To get connected with RazorSQL, open the connection wizard, select the appropriate database type, select ODBC as the connection type, and select the name of the ODBC data source you just created from the ODBC data source drop down.