>Thanks Philip
>Talk to you soon
>
>George

Hi George,

I used the following script:

	Dim strQuery, strConnection, objRS, objConn
	
	'Establish connection with data source
	SET objConn = Server.CreateObject("adodb.connection")
	SET objRS = Server.CreateObject("adodb.recordset")
	
	strConnection = "DSN=Testdata"
	objConn.Open strConnection

	strQuery = "SELECT prodcode, descrip FROM products"
	objRS.Open strQuery, objConn
	
	Response.Write objRS.Fields("prodcode").Value
	Response.Write objRS.Fields("descrip").Value	

No problems. It is slightly modified from your original version. The DSN, "Testdata" is a VFP ODBC driver accessing free tables on the LAN.

The ISUR account has full permissions (for test purposes) on the network folder holding the tables. Have you tried giving the ISUR account full control on the table folder? Does it make a difference? If so, then security is likely the issue, which I think it may be. The driver is not the issue, I don't think.

The ISUR account on the web server has the same drive mapping (ie: fully qualified path) to the table folder that the driver does, right?