To set up the dsn, you have to point to the database's ddf (data dictionary files). For example, if you right click on demodata, you can examine its properties. You will see the directories section-- the directory location for the dictionaries and the directory location for the files. The ddfs are special files that describe the contents of the database. When you say that you do not see any tables after setting up the database, this tell me that you created a new set of ddfs in the directory that the data files are in. A new set of ddfs dows not have the table definitions in them. Someone has to define the existing data tables to the ddfs.
So do you know, if your vendor provided predefined ddfs for your database. They do not necessarily have to be in the same directory as your data files. You can use the properties that was mentioned previously to indicate if the data files are in another location.
Try this: Create a new directoy. Copy the files with the extension *.ddf from the c:\pvsw\demodata to your new directory. Now go into the PCC and set up a new database. You can name it Fred for the database name. For the location, browse to your new directory. Select finish. Open the new database Fred in the PCC. You will see the tables since they are defined in the ddfs. But if you try to open one, it will fail, because the database is assuming that you have the files in the same directory as the ddfs. So now copy the datafiles from c:\pvsw\demodata into your new directory. In this case, the data files are all the files with the extension *.mkd . Now, you should be totally there and your new database should be functional.
You could have also copied your files to another directory. In that case, you would have gone to properties, to add a new data location. Then you would have removed the incorrect data location which points to your first new directory.