FoxPro Setup - ODBC Driver with Visual .NET

Author

ODBC Driver with Visual .NET

Marc

2005-06-10, 1:24 pm

I'm trying to access a foxpro DB with Visual .Net 2005 and any table I
clickon show table data just shows me the very first column data and nothing
else, am I doing something wrong here or is that how it is supposed to work?

Lee Mitchell

2005-06-10, 8:25 pm

Hi Marc:

I don't know what you are doing in .NET to display the data. Is this an
ASPX page or a data grid on a form?

In any case, you are probably better off if you use the VFP OLE DB Provider
instead of the VFP ODBC driver to access VFP data. You can get the driver
from this location:

http://www.msdn.microsoft.com/vfoxp...es/default.aspx

For the connection string syntax, see this link:
http://www.connectionstrings.com

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 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

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

>I'm trying to access a foxpro DB with Visual .Net 2005 and any table I
>clickon show table data just shows me the very first column data and
nothing
>else, am I doing something wrong here or is that how it is supposed to
work?

Cindy Winegarden

2005-06-13, 8:24 pm

Hi Marc,

Lee pointed you to the VFP OLE DB data provider, which is a better choice.
One reason is that over time new features have been added to the VFP data
engine and the ODBC driver can't read tables with the newer data features.
The VFP OLE DB data provider can read all versions of FoxPro and Visual
FoxPro.

I assume you've got a connection to a Fox "free table" directory or a VFP
DBC (database container) in your .NET Server Explorer. Once you've made the
connection the Fox tables should behave just like any other types of data
you've connected to.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Marc" <Marc@discussions.microsoft.com> wrote in message
news:3F411E0B-F522-482D-A720- E65AC1B95296@microso
ft.com...
> I'm trying to access a foxpro DB with Visual .Net 2005 and any table I
> clickon show table data just shows me the very first column data and
> nothing
> else, am I doing something wrong here or is that how it is supposed to
> work?

Sponsored Links