Connecting a oracle database to ASP pages

Hi im new to using ASP (hence the username). I have a project at university where i have to link an oracle databases to ASP pages. i have created the oracle tables in oracle and i haven't got a cue how to link the tables to a web servre using ASP code.

Can anyone help please, any hints or putting me on the right path will be welcome.

Thanks in advance.

Make sure you have an Data Source ODBC connection on your web server. Also make sure your TNSNames.ora file that you want to point to is reference your tablespace/database.

ASP Code:
Dim objConn1

Set objConn1 = Server.CreateObject("ADODB.Connection")
objConn1.ConnectionString = "Data Source=<tablespace or database name>; User ID=" <userID> ";Password=" <password> ";"
objConn1.open