>>>>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.
>>
>>Since I am not a VBScript wiz, could you send me a sample one I could play with?
>
>If one with SQL Server 2000 is OK, then I'll post it privately. It's on my laptop and I'll have it later to-day.

That would be fine. Thank you.