Greg;

Some suggested links:

http://www.codeproject.com/database/connectionstrings.asp

http://fox.wikis.com/wc.dll?Wiki~Exam70-155ADO~VFP

http://fox.wikis.com/wc.dll?Wiki~ADO

http://www.experts-exchange.com/Databases/FoxPro/Q_21046680.html These guys charge money for access to answers.

http://www.georgehernandez.com/h/xDatabases/aaIntro/MDAC.htm

Good luck and go for it! :)

Tom





>Thanks a bunch for the reply!!!
>
>I don't have an OLE DB provider available in the list of choices from what I can tell. I've scoured Microsoft's site for a VFP 8 compatible OLE DB and I just can't seem to figure out what I to download and installed to make it available. If it was installed it would be listed in the Data Sources inside the administrative tools, correct?
>
>I really appreciate the help. This problem is taking up some serious time and it's on our live server so it's really killing me now.
>
>
>
>
>>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!