MY Eyes have been opened

Robert Haussmann haussma at nextdimension.net
Thu Feb 9 09:51:19 PST 2006


> 	With the client version, filePro requests a ODBC server
> (such as MySQL which is constantly running, waiting for a request)
> to read and write the MySQL records. A filePro ODBC server
> would have to run constantly and allow MySQL to read and
> write filePro's records.
> 

A data source does *not* have to be client/server to have an
associated ODBC driver that allows other software to read/write
to the data source.

Examples include:

Excel
Access
dbase
foxpro
text files

None of these have a server component running.  They are ODBC
drivers that allow non-client/server types of sources to be 
read/written.  I think this would be what 99% of developers 
asking for "ODBC server" really want.

That being said, there are software companies that sell "ODBC
framework" development kits for approx $10K.  These are royalty
free.  To provide ODBC-access to legacy data, you just need to
provide the "glue" between the ODBC framework and the underlying
data source (presumably handle record locking, read/write records,
etc.).  For anyone that is interested, one such example is (no
idea on the cost or licensing on this one; it's just the first
that comes up in google).

http://www.odbcsdk.com/products/openaccess/odbc_overview.asp

Bob Haussmann
Tabor Children's Services, Inc.



More information about the Filepro-list mailing list