>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
Hi George,
Sorry, I got caught up in something else last night. I will test this later this evening (I have meetings most of the day). What you have posted looks fine. Not sure what is happenning here.
As David mentioned, you can build a VFP COM server to do the data access, and install that on the web server. This is a perfectly sound approach. However, note that it requires maintaining and installing a DLL, and for simple data access from an ASP, it shouldn't be necessary. The DSN approach should work. I'll let you know how it goes for me.