Yea i am trying to produce a page which is data sourced from several tables, so if create a 'view' of that data and select from the view in my ASP page.How do i connect the database [i mean the code on the .asp file] i have done the ODBC

Oh and the other thing is if i try to use eneterprise to create the vies it's selecting all columns and not giving me an option to select which ones i want.when i click add table it's not showing any columns just the table name and a star i have tried to play around with but i am getting no where

Thankx for shadding some light i was completely blank