Thanks for the quick reply.

Unforutnatley, now I'm back to my same old problem.

Here's the quick recap... Everything was 100% ok until I started getting VFP COM errors. ASP connection was fine VFP Coms would return 'resource type mismatch' when loaded in VFP and would hang in ASP.

I reinstalled VFP 8 and SP1. Coms then worked fine. Unfortunately, now the ASP pages hang everytime you try to access VFP data. I was originally using ODBC to connect but just switched out to OLE DB provider. Same problem continues to happen though. ASP pages work fine until it connects to VFP. As soon as it connects to VFP through the ODBC or OLEDB the ASP page hangs and runs indefinitely.

You can connect fine to the VFP databases through ODBC or OLEDB through a VFP remote view or Excel. Only hangs in ASP.

I've tried a zillion different connection methods but the simple one I'm trying right now looks like this.

set dataset = Server.CreateObject("ADODB.recordset")
dataset.open SelectClause, "Provider=VFPOLEDB.1;Data Source=I:\Crown01\crownweb.DBC;Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE"

Any ideas on what I can do to get this problem fixed? your help is so appreciated!


>Open .UDL file in any text editor and copy a connection string from there to your ASP page.
>
>>I have created a UDL file in order to hookup to a VFP database through the OLE DB provider. The test connection works in the file.
>>
>>But now I'm struggling with what I need in ASP to connect using this .UDL file. What do I need to do to use this connection in my ASP page.
>>
>>MANY, MANY thanks in advance. We've now had this order site down for two days so I'm quite desperate to get this to work!