Sorry, me again. I just did a quick error test by adding.

if not rsADO.EOF then

Response.Write rsADO("test")

'Response.Write rsADO("FieldName2")

else

Response.Write("EOF")

and it now displays EOF to the page. I know this...

I am now using:

<%

' Dim the Recordset Object

Dim rsADO

' Define the Connection String From Above

ConnectionString = "Provider=SQLOLEDB; Password=;User ID=sa;Initial Catalog=TestDatabase;Data Source=mydatasource;"

' Create the Object

Set rsADO = Server.CreateObject("ADODB.Recordset")

Source = "SELECT *...

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...

Thanks frank. I do have Enterprise Manager so I will look for tutorial with that. I will also look for tutorials for OLEDB.