Ok, I created a new database called TestDatabase. In this I have a Table called Table1 and a field called test.

I used the sample code:

<%

set cnn = server.createobject("ADODB.Connection")

cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename "

%>

to connect to my database. I haven't received any errors yet but I havent tried to manipulate the database yet either. This is just an update of my progress. It would be great if people could tell me if im doing something wrong.

Thanks.