another thing that's throwing me off is where he uses:

VB Code:
  1. conn.open.......

I don't see a conn declared::?