All of the projects that Russ mentioned I would expect to work great
with the Merant ODBC driver manager (libodbc.so) that we ship with
ColdFusion.
Russ, can you point me to the MS Access project? This is such a FAQ
that it would sure be nice to have somewhere to point to for a solution.
The only thing I could find on SourceForge was the MDB Tools project,
but they aren't working on an ODBC driver.
Also note that the Merant SQL Server driver does speak the on-the-wire
protocol and we have used it on Solaris and Linux in some very heavy
performance/clustering tests and it has worked great for us. Merant
expects to ship most of their ODBC drivers speaking the data base wire
protocol (no client libraries!) in version 3.7, which we will use for CF
5.0. Unfortunately, Oracle will not be included in this release. It
will still use client libraries....
--
Tom Jordahl
Allaire Development
Russ Cobbe wrote:
>> Many Allaire customers have used SequeLink to talk to data sources on
>> Windows. It basically is a 'universal' ODBC driver, which talks to a
>> Merant server on the Windows machine. This server has access to all the
>> data source on the Windows server, using ODBC, OLEDB, etc. The request
>> is performed and the results passed back to the SQL-Link ODBC driver on
>> the Unix platform.
>
>
> This is pretty slow though because it is a bridge. The TDS driver at
> http://libary.freeodbc.org natively talks to the MS SQL server.
> Nothing extra needs to be installed on the NT machine at all.
>
> It is quick and has been found to be more stable than the Merant
> drivers. On top of that, it is free and not $4000 like the Merant
> stuff.
>
> There is also an open source project in sourceforge that is working
> on making the MS Access MDB format readable. Another group is
> working on an ODBC driver for that that will work on unix. Big
> advantage here is it won't leak memory and will be multithreaded
> unlike MS's own Access drivers.
>
>
> Russ Cobbe
> President, Inline Internet Systems, Inc.
> 405 Britannia Road E, Suite 212 Mississauga, ON L4Z 3E2
> P: (905) 712 3841 F: (905) 712 2965
> http://www.inline.net http://www.ihtml.com
> Web Application Servers, E-Commerce Solutions
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
