This is the Pervasive formerly known as bTrieve. I am running the free edition of BlueDragon Server, so JDBC is not an option.
Pervasive's ODBC driver seems to have a problem with transaction management or locking when doing inserts/updates so I am hoping that I can find a way around ODBC. -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 8:03 AM To: CF-Talk Subject: Re: Datasource question Billy Cox wrote: > So...should I go with the ODBC connection to Pervasive SQL or try to > connect to Pervasive via linked server in SQL 2005 Express, or am I > barking up the wrong tree? Depends on which Pervasive you are talking about. If you mean the one that started life as BTrieve I would try the linked server approach. If you mean the one that started life as PostgreSQL I would try to connect directly to it with a PostgreSQL JDBC driver (the product is only rebranded, not actually changed). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
