You'll find that the datasource will verify for almost anything. To get
this to work do the following:
1 - configure cf service as a user account that has access to the other
server
2 - configure your datasource with the full path to the foxpro file - for
example: \\server\d$\database\
Now, here's th fun part - the latest MDAC relies on the Borland BDE to be
installed for access to DBase files and, I think, FoxPro as well. If you
need a BDE installer then let me know...
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
----- Original Message -----
From: "Eric Bradburn" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 01, 2000 3:04 AM
Subject: Accessing Foxpro on a different server
> Hi, All.
>
> I am attempting to access a foxpro db on a server on the LAN (legacy app
>
> of client uses FoxPro). I have the VFP drivers installed on the
> ColdFusion server box, and receive a verified message when checking the
> datasource. The problem that occurs is when I attempt to query against
> it and it returns a message the the TABLENAME.dbf file could not be
> found. I have tried naming the server in the path on the ODBC
> configuration as well as creating a mapping from the ColdFusion box to
> the directory with the FoxPro DB. I'm thinking of making an Access DB on
>
> the ColdFusion box to link to FoxPro but I really dread going about it
> this way. Any ideas?
>
> Thanks,
> Eric
>
>
>
>
>
>
>
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
