Thank you Stephen and KCWebMonkey for your help, I do manage to connect to DB without using dsn.
However, for some reason, I still can't insert a record to the DB...
For example, if I use the code given here
http://www.aspwebpro.com/aspscripts/records/insertnew.asp
I am stuck with the line...