What happens if you're using PigTab for the first time, and need to set up an ODBC (Open Database Connectivity) source for PigTab? 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 PigTab database. However, every step is identical! Just choose your copy of the PigTab 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 PigTab, 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...
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.
Choose a User or System data source. User is probably more sensible. Click Next.
Choose your database driver. Click Next.
Click Finish.
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:
Choose your database here and click OK. Your ODBC data source fields should now all be set up:
Click OK. You will be returned to the ODBC selection screen with your new data source now available.