I just tried your suggestion and there were no errors; I was able to establish a connection to the table via the DSN from within VFP. It seems as if ColdFusion just can't do it.
Cecil
>>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?
>
Can you access it with VFP SPT functions?
loSQL = SQLCONNECT([YourDSN])
IF loSQL < 0
AERROR(laError)
LIST MEMO LIKE laError*
ENDIF