I want to throw in here..
My experience with PervasiveSQL is that it is a flat file system, not a
RDBMS. Both FileMaker and Lotus Approach use the flat-file approach to DBs,
if you want a frame of reference. It's not a relational database and I
wouldn't recommend using it as a relational database.
Business Visions (An accounting software) was developed on top of
Pervasive SQL, and while we (when I say we, I mean me) are supposed to
write some migration / transfer code to move data from a web order database
into the internal Business Visions accounting system, I haven't actually
done serious experimentation w/ accesing Pervasive SQL w/ ColdFusion via ODBC.
I was very upset after being told that the client was upgrading to the
SQL Server version of Business Visions to find out that there was no SQL
Server version and the 'SQL' version of the product was developed in
Pervasive SQL.
--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
DotComIt: Database Driven Web Data
My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com
My New Book: ColdFusion: A Beginner's Guide due out next February
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Todd for President, muffins for all
~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists