It uses ANSI 92 as it's standard. CF does work with it, but you need to set the Datasource using the ODBC Control Panel, then use the generic ODBC driver setting in CF to call the datasource.
It does work, but make sure to read their articles on ODBC Performance issues and limitations...it doesn't scale. And we've found no way to perform an online backup w/o first turning the service off during the backup. There can be no activity done during the backup, otherwise the backup is corrupt. My bitch list is long.... -----Original Message----- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 8:35 PM To: CF-Talk Subject: RE: SQL Pervasive and Cold Fusion?? Good timing.. Pervasive SQL is your run of the mill SQL database server. The clien t utility is a complete rip-off o f Enterprise Manager. There's an ODBC driver for it and it uses standard SQL syntax, so I c an't see why you CF wouldn't "just work" with it. -----Original Message----- From: kellymconf [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:25 PM To: CF-Talk Subject: SQL Pervasive and Cold Fusion?? Hi! Has anyone ever dealt with SQL Pervasive? Basically I have a new client and their Association Mgmt Software backend is SQL Pervasive. I have never heard of this. They basically view the database portion of it in Access yet supposedly it is not an access back end. Anyway we are going to need to set up an ODBC datasource for this database that we will be connecting to from a remote location. That p art should be easy, but since i know nothing about Pervasive I am not aware how to even add a login, so th at Cold Fusion can connect to it etc. Anyone have any info about it or could you point me in the right direction? Thanks Kelly ~~~~~~~~~~~~~~~~~~~~~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~~~~~~~~~~~~~~~~~~~~~ _____________________________________________________________________ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation * $99/Month * Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
