in reply to Database access error.

I am glad that you've solved your problem.

On a side note, I would like to offer some thoughts on your script, if you don't mind.

First of all, the Monastery chant. use strict and warnings, so that you can catch the errors before they catch you.

Then, you are getting a value from standard input without any processing. You should at least use chomp to remove the newline at the end of the string, and then check that your listname doesn't contain any characher that later on may make your life difficult.

Furthermore, a call to $sth->finish is only needed when you are fetching records. For data manipulation commands such as INSERT or UPDATE, you don't need it.

Cheers