Using CF4.5 I have set up an ODBC DSN to a FoxPro database on the network using the "Free Tables" option.
When I complete the setup of the DSN in CF Administrator it shows as verified. When I run a query based on this datasource it says it cannot find the table. When I copy the database to my local machine (the server) and set up the datasource it works just fine. I have tried this using both of the following: \\ServerName\DirectoryName G:\applications\DirectoryName What am I doing wrong? If I am attempting this incorrectly, why is CF Admin reporting it as verified, yet my SQL statement bombs with "cannot find table"? -Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete. it. Thank you, ViaHealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
