Why are you mixing ODBC and ADO? If you are using ADO, you should be using the OLE DB Provider. What is your connection string?


>Good morning,
>
>I have a web app that was working fine until I started haing problems with VFP com objects that would throw server exception errors. When I loaded the com's in VFP I would get messages such as 'Resource type mis-match' or something like that. So I had to uninstall VFP 8(Sp1) and reinstall. After much pain I finally got my com objects to compile and load in VFP no problem. I can also call Com objects from ASP now without a problem.
>
>Unfortunately, now, whenever my ASP pages try to access my VFP databases through ADO the server hangs and the web page never even comes up. After the attempt to access the VFP database you can't even get to any ASP page until you restart the web services.
>
>I've tried installing new ODBC drivers but it seems like the OS (Windows 2000 Server) is ignoring all attempts. 6.01.8630.01 is the ODBC driver it is showing in the ODBC administration.
>
>Heres another kick. I can use ODBC fine inside VFP, create connection, create remote view to the odbc data source and retrieve data with no problem. It's only in ASP that it is hanging. I've double check permissions (should have been right anyway because the app was fine until the problem VFP com and then reinstall of VFP.
>
>Any ideas on how to proceed?
>
>MANY thanks in advance!