>I have a FPW 2.5 system that I would like to add Oracle access to. Right now we have a separate non-FP program that creates a flat file from the Oracle database and places the file in a network share for our FPW app to load.
>
>Can I change the FPW app to access an Oracle view directly?
>
>I have the Dist. Kit for 2.5 but I seem to recall something like a connectivity kit. Does anyone have any experience with this? Can it access an Oracle view? If such a thing exists how do I find it? Does Microsoft still sell it (I doubt it, myself)?
>
>I would appreciate any help you can provide.
Larry,
I had the 2.6 connectivity kit, but rather than try to futz around with it to try to connect to SQL Server 2000, I created a VBScript file using the OLE DB provider for SQL Server, and called it using the ShellExecute function.
Since I know that Oracle has its own OLE DB provider, I think that the same technique might work here.
George
Ubi caritas et amor, deus ibi est