ODBC (Mike OShea)

[Bill Campbell]

On Fri, Feb 10, 2006, ryan at bulldogsoftware.com wrote:
>On Fri, Feb 10, 2006 at 02:04:52PM -0500, O'Shea, Michael (LABS) said:
>
>> 
>> How do I configure my Filepro Unix Application to use ODBC and "READ/WRITE" Oracle Tables?
>> As I was told by fptech, that this cannot be done and that this isn't even in the plans for unix.
>> 
>> I'm looking for this to be a "CLIENT" of the oracle table.
>
>Well there are a few things that you need to do.
>
>1. get filePro ODBC
>2. add an fp_id field to your Oracle table
>3. in filePro create a new ODBC type filePro file and attach it to the
>Oracle datasource.
>
>So perhaps what fP meant by "cannot be done" is that you cannot do this
>on Unix. 

I have never used FP's ODBC, but assume that it has to be pretty
much the same as OpenOffice.org's in that it requires the
unixodbc program, *AND* the appropriate odbc libraries to connect
to the target system (Oracle in this case).

As I understand ODBC, it's basically a shim that translates the
client's database requests into SQL that the target database
understands.  This is also basically how the perl DBI and python
database abstraction layers work.

Conversely, for FilePro to have an ODBC server capability, I
would expect that (a) one could do any updates to the database
from FP's SQL, and (b) that they would have to provide the
appropriate ODBC libraries for Window and unixodbc which could be
used on those platforms.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

``Capitalism works primarily because most of the ways that a company can be
scum end up being extremely bad for business when there's working
competition.'' -rra