connect to a database

[jarv]

hi I would like to connect to  a database to retrieve some records could someone please check my code...

 

<?php

$var = Connection;
$var = sConnString;
$sSQL

Set Connection = Server.CreateObject("ADODB.Connection")

sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ 
"Data Source=" & Server.MapPath("db/tellist.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open strConnection 
sSQL = "SELECT * FROM phonebook";

Set rsContactList = objconn.execute("PhoneBook")
Do While Not rsContactlist.EOF

echo rsContactlist("rsName")

rsContactlist.MoveNext 
Loop
objConn.close
Set rsContactlist = Nothing
?>