Connecting to dbf files across network

Nicklepedde Guest Sep 28, 2005 10:23 AM

Hello, I'm working on a project for a client, who has all their data for the server on a mounted drive. The data is on drive "N" and is in the form of dbf files. So I setup an ODBC datasource using the windows dbf driver to point to the folder. Then I tried to add it in CF admin, it threw and error saying: "'(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." I've also tried the diect connecting method fo running SELECT * from N:\order.dbf, and I get a file not found error. So it seems CF can't connect to the remote drive. I even tried setting up a mapping but that failed as well. Any help or insight would be greatly apreciated.

xenden 2 posts Apr 02, 2006 10:09 PM

I'd recommend getting a DBF jdbc driver, and instead of linking across the network, copy the files to the local server first. There are a few jdbc drivers that handle dbf files, just drop the driver .jar file in your JRun/lib folder, and create a datasource in CF administrator using the "other" database driver.

CFTalk :: Tip Of The Week :: Polls :: Book Of The Month :: CFStore
Another online store by CoyoteDirect.com  ~ Adventure Friendly