As I have said I do not now the older version of ASP, only .NET. If you want to do some reading up on using .NET to access databases the links below are a good place to start:
...

I am not sure I follow you exactly when you say you want to join several tables in stored procedures, but if your trying to produce a page which is data sourced from several tables, why don't you...

I don't have any experience with the older version of ASP I am afraid, I have only ever used ASP.NET and ADO for Database connectivity on a web project. Why do you specifically want to use ODBC by...

I don't see that you have missed anything in setting up the database. What language do you intend to use on the frontend? PHP, ASP.NET etc ...