Re: Extracting data with VFP from PRISM database
From: Henri Visser (hvisser_at_o2.co.uk)
Date: 07/14/04
- Next message: Paul Pedersen: "Re: failure to write data"
- Previous message: shmiel: "Re: outlook express"
- In reply to: Lee Mitchell: "RE: Extracting data with VFP from PRISM database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Jul 2004 23:18:26 +0100
Thank you
I was hoping someone might be aware of one of the first two options you
suggested, especially ODBC (now that would be SWEEEET!!!)
I assume they must have some kind of Windows driver because they have a
Windows "Query Builder" app that looks like it might have been done in VB.
It creates standard SQL queries that extracts the data from PRISM through
the app.
The app gets data from the PRISM db in the following manner as far as I can
see from the documentation.
Local Data Dictionary -> Universal Data Dictionary -> PRISM
They must have a driver built into the Query app, because I can't see any
'unusual' entries in the ODBC/Data Sources control panel applet.
I can and already have started on exporting the data to fixed width text
files, but I'm afraid this option might be a bit too manual, because the
users will have to do this on a daily basis, NOT ideal!
Regards
Henri Visser, MCSE (Windows 2000)
The local data dictionary is stored locally in an Access file.
"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:lS5ioweaEHA.3748@cpmsftngxa06.phx.gbl...
> Hi Henri:
>
> No, I have not hard of anyone connecting to data from a PRISM database.
> However, does Alphameric have a Windows compliant ODBC driver or an OLE DB
> Provider? If they have an ODBC driver, you can use SQL Passthrough or a
> remote view. If you have VFP 8.0, you can use a cursoradapter with an OLE
> DB provider.
>
> If they do not have either of these technologies available, then you need
> to export the data in a format that VFP can read with the IMPORT or APPEND
> FROM commands.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 Public Beta Now Available!! --*
> Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
> >Has anyone here tried to extract data using VFP from a PRISM database (on
> >UNIX) as used by Pennine systems (now owned by Alphameric).
> >I'm sorry I can't be more specific, but if anyone here has done it before
> >they will know what I mean.
>
> >Thanks
> >Henri Visser, MCSE (Windows 2000)
>
>
- Next message: Paul Pedersen: "Re: failure to write data"
- Previous message: shmiel: "Re: outlook express"
- In reply to: Lee Mitchell: "RE: Extracting data with VFP from PRISM database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
