Creating a new ODBC source

Top  Previous  Next

What happens if you're using RatBat for the first time, and need to set up an ODBC (Open Database Connectivity) source for RatBat? You should configure it via Control Panel ODBC [in Windows 2000, Control Panel Adminstrative Tools Data Sources (ODBC)]. Alternatively, you can set one up "on the fly", as explained here.

 

The example below is for a PIT (Pavlovian-instrumental transfer) database, as I couldn't be bothered to redo all the screenshots for a RatBat database. However, every step is identical! Just choose your copy of the RatBat database instead.

 

Remember: you shouldn't use the supplied database without making a copy for yourself. (It will work, but if you ever uninstalled or reinstalled RatBat, this file might be replaced or lost. It is much safer to make your own copy and set up ODBC to use your copy.)

 


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.