----- Original Message -----
From: "Javed Mushtaq" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 8:58 AM
Subject: URGENT: FOXPRO
> Hi all, Please could you tell me if you can hook cold fusionupto Foxpro?
Yes, that is not a problem.
> Is it any different to access as a datasource compared to Microsoft
Access?
Yes. FoxPro database structures are derived from DBase. The way you set up
the datasource is that the datasource does not point to a file (like an
Access MDB) but rather to a directory. Then, any database files in that
directory can be used in a query (note: you can also use files that are not
in the specified directory as long as you use paths). One weird thing about
DBase (and maybe FoxPro as well) is that the default in the ODBC setup is
for ODBC to return even deleted rows. If FoxPro is the same as DBase then
you need to disable this manually from the ODBC setup (not from CFA).
> Does anyone use Foxpro as a datasource and how haveyou found it to be?
FoxPro ODBC drivers, like DBase, are single threaded (and blocking) which
means that only one query can be running at one given moment. If you are
doing lengthy queries you will notice a degradation in other simultaneous
queries.
> In addition, if the datasource is flat filed can ColdFusion access the
data
> or can Cold Fusion only accessRelational databases.
ColdFusion has no problems accessing any flat databases AFAIK.
> Finally what is the difference between Foxpro and Visual Foxpro?All help
> appreciated.Javed
>
I think there may be some minor differences in the file formats but the ODBC
driver should account for that.
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
Get your free copy of iMS POST-SE Server from CoolFusion!
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
