>>>>>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.
Sorry for the delay. I've been under the weather.
I'll post it to you privately tomorrow.
George
Ubi caritas et amor, deus ibi est