Converting visual foxpro to sql 2000

I am trying to convert a foxpro database to sql 2000 using the wizard within sql 2000 but it keeps giving me an odbc error when accessing the foxpro database? I am stuck and don't know where to turn next. Any ideas? Thanks
rick,
Please share your error message and the version of Visual FoxPro you are
using. It sounds like a problem in defining your
ODBC data source, but need more info.
Russell Fields
"rick" <anonymous@.discussions.microsoft.com> wrote in message
news:DCEDB7E2-CC4A-4661-8E8F-19169A3D35AD@.microsoft.com...
> I am trying to convert a foxpro database to sql 2000 using the wizard
within sql 2000 but it keeps giving me an odbc error when accessing the
foxpro database? I am stuck and don't know where to turn next. Any ideas?
Thanks
|||In news: DCEDB7E2-CC4A-4661-8E8F-19169A3D35AD@.microsoft.com,
rick <anonymous@.discussions.microsoft.com> wrote:
> I am trying to convert a foxpro database to sql 2000 using the wizard
> within sql 2000 but it keeps giving me an odbc error when accessing
> the foxpro database?
Hi Rick,
FoxPro tables can come in either of two formats. They can be "free" tables,
meaning that each table is independent of the others, or they can be part of
a "database container" which holds metadata and allows additional features
for the tables. If you see a file with a DBC extension then you've got a
database.
Also, tables using any of the new features that were introduced in VFP7 and
VFP8 can only be accessed via the FoxPro and Visual FoxPro OLE DB data
provider.
Both the ODBC driver and OLE DB data provider are downloadable from
http://msdn.microsoft.com/vfoxpro/do...s/default.aspx .
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org www.cindywinegarden.com

Converting Visual FoxPro reports to RDL

I need to convert Microsoft Visual FoxPro reports (FRX files) to RDL format.
FoxPro report has groups.
I think I must create nested List elements to simulate grouping and add
report fields to those list elements.
I have analyzed some possibilities:
1. Generate RDL XML from VFP FRX file using XmlDocument or XML stream.
2. Using dynamic RDL generation class from http://www.gotreportviewer.com
3. Transform XML report defintion generated by FoxPro XMLListener
(http://msdn2.microsoft.com/en-us/library/ms994713(VS.80).aspx) to RDL
4. Use intermediate format like described in
http://www.vfpconversion.com/Blog.aspx?blogid=1b208937-2232-4b48-9a12-8c89f98ce08f&blog=us:Mike&messageid=b842330d-c2e2-4b5e-9d04-3415c8c0a4ad
Any idea or sample of FRX to RDL conversion ?
Andrus.Hi Andrus,
I see there is a VFP to RDL conversion tool at
http://www.vfpconversion.com/Vfp2NetReports.aspx .
--
Cindy Winegarden
cindy@.cindywinegarden.com
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"Andrus" <kobruleht2@.hot.ee> wrote in message
news:%23SyWacFVHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I need to convert Microsoft Visual FoxPro reports (FRX files) to RDL
>format.
> FoxPro report has groups.
> I think I must create nested List elements to simulate grouping and add
> report fields to those list elements.
> I have analyzed some possibilities:
> 1. Generate RDL XML from VFP FRX file using XmlDocument or XML stream.
> 2. Using dynamic RDL generation class from http://www.gotreportviewer.com
> 3. Transform XML report defintion generated by FoxPro XMLListener
> (http://msdn2.microsoft.com/en-us/library/ms994713(VS.80).aspx) to RDL
> 4. Use intermediate format like described in
> http://www.vfpconversion.com/Blog.aspx?blogid=1b208937-2232-4b48-9a12-8c89f98ce08f&blog=us:Mike&messageid=b842330d-c2e2-4b5e-9d04-3415c8c0a4ad
>
> Any idea or sample of FRX to RDL conversion ?
>
> Andrus.
>
>