Philip
I'm fairly new to this area so I'm not sure if I am using a DTC recordset.
Below is the script that does the connection and retrieves the records.

DIM objConn, objItemDetailsRS, strQuery, strConnection

'Establish connection with data source
SET objConn = Server.CreateObject("adodb.connection")
strConnection = "DSN=ERSData"
objConn.Open strConnection

strQuery = "SELECT code FROM plu WHERE code = '" & lcItemCode & "'"
SET objItemDetailsRS = objConn.Execute(strQuery)



George