Hi Cecil,

Here is my SWAG, are you sure the free table does not have any field types that are not VFP6 or below, because ODBC is only for VFP6 and below.

HTH
Beth

>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)
>