Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use FPW to access SQL Server
Message
 
À
31/01/2005 14:40:54
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Versions des environnements
Visual FoxPro:
FoxPro Windows
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Oracle
Divers
Thread ID:
00980456
Message ID:
00984092
Vues:
22
>>>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform