This is why we shouldn't use anything but Visual FoxPro:

I like Visual FoxPro, or maybe we should say that I love Visual FoxPro. It is a great language, if not the best. Even though .NET has made a lot of strides toward being more like VFP (by borrowing its technology), .NET is still not as easy to code in as VFP. VB.NET, in my opinion, might be the closest thing to being like VFP.

Anyway, on to my problem, besides the fact that VFP isn't used by all companies. The problem I'm having is accessing a VFP 9.0 Free Table called MSDS.DBF from within ColdFusion. I made a System DSN and it has the Visual FoxPro driver, and is pointed to the very table which will be used, yet I cannot access that VFP table; I always get a Datasource error. Is there anyone on this forum who can help me to figure out how to get ColdFusion to access Visual FoxPro tables?

Here's the error report:

 Error Occurred While Processing Request
Datasource msds_vfp could not be found.
 
The error occurred in C:\Inetpub\wwwroot\CF8Samples\MSDS_VFP.cfm: line 9

7 : 
8 : <!--- Get msds list from database --->
9 : <cfquery name="msds_list" datasource="msds_vfp">
10 : SELECT msds_no, tradename, supplier, supp_phone, supp_ext,
11 : 	emergcont, emergphone, dPrep, chem_name

DATASOURCE 	  msds_vfp
Resources:

    * Check the ColdFusion documentation to verify that you are using the correct syntax.
    * Search the Knowledge Base to find a solution to your problem.

Browser   	Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11
Remote Address   	127.0.0.1
Referrer   	
Date/Time   	08-Aug-08 09:42 AM
Stack Trace
at cfMSDS_VFP2ecfm35326385.runPage(C:\Inetpub\wwwroot\CF8Samples\MSDS_VFP.cfm:9) at cfMSDS_VFP2ecfm35326385.runPage(C:\Inetpub\wwwroot\CF8Samples\MSDS_VFP.cfm:9)

java.sql.SQLException: Datasource msds_vfp could not be found.
	at coldfusion.sql.DataSrcImpl.validate(DataSrcImpl.java:95)
	at coldfusion.sql.SqlImpl.validate(SqlImpl.java:279)
	at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:467)
	at cfMSDS_VFP2ecfm35326385.runPage(C:\Inetpub\wwwroot\CF8Samples\MSDS_VFP.cfm:9)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)