Creating a new ODBC source

Top  Previous 

What happens if you can't find an ODBC source? You should configure it via Control Panel ODBC. Alternatively, you can set one up "on the fly", as explained here.

 

Suppose you're looking for a PIT database. But there isn't one...

 

PIT_ODBC_CantFind

 

Let's assume that you have already made a working copy of the prototype database supplied with the task. How do we go about setting this up as an ODBC data source?

 

Click New.

 

PIT_ODBC_New_1

 

Choose a User or System data source. User is probably more sensible. Click Next.

 

PIT_ODBC_New_2

 

Choose your database driver. Click Next.

 

PIT_ODBC_New_3

 

Click Finish.

 

PIT_ODBC_New_4

 

You should fill in the Data Source Name (no spaces) and the description, and Select a database. When you click Select, this dialogue box appears:

 

PIT_ODBC_New_5

 

Choose your database here and click OK. Your ODBC data source fields should now all be set up:

 

PIT_ODBC_New_6

 

Click OK. You will be returned to the ODBC selection screen with your new data source now available.