Fotolook contains the drivers for all the Agfa scanners, so you can get another Agfa scanner and plug it in and it should work, if you find a good deal. You should install Fotolook first, and then Windows will look for a driver (tell it to look on your hard drive), and will find something like agfablahblah.inf in the c:\windows\inf directory, and then you should be good to go.
You can get a cable that is HD-50 on one end and DB25 at the other end. Try pcconnection.com. As a general rule, get the shortest cable that will work. Long SCSI cables or a long chain of SCSI devices can invite magnetic interference and transmission errors.