I see your scanner is older because it requires to be run under Classic (which was Mac OS 9 and previous). You will be able to run some older applications under Snow Leopard after installing Rosetta (Mac OS would automatically prompt you and download it from the Apple site); however, I do not think that the same applies to printer or scanner drivers.
You might want to try the following: after uninstalling whatever drivers you installed, plug in and turn on the scanner; go to System Preferences -> Print and Fax and click the "+" sign underneath the left pane. If the Mac OS has a compatible driver already built in, it should see the scanner. If it does not, I'd say that after at least 8 years, you might want to consider a new scanner?