Connecting to FoxPro to .Net

[Edb]

Hi Everyone,

I need to build an ASP.Net project that wraps around a FoxPro Database. It
appears that I need

to create an ODBC Connection to .dbf files. Some of them have relations to
each other.

I have not done this before but have a few assesments on how to do it.

a. Create ODBC Connection to each database and make connection strings in
..Net to them.
The issue with this is what if I need to grab specific column types from
each .dbf file? How to do?

b. Create ODBC Connection to SQL and link the database to SQL Server. I
am curious ... because SQL
is linking the databases, can I run stored procedures in SQL to join column
types to my project.

I am just curious. I thank everyone in this forum for there assistance.

Happy Day and Happy Coding,
edb

[Herfried K. Wagner [MVP]]

* "Edb" <m1**@dm2000.com> scripsit:

I need to build an ASP.Net project that wraps around a FoxPro Database. It
appears that I need

to create an ODBC Connection to .dbf files. Some of them have relations to
each other.

I have not done this before but have a few assesments on how to do it.

a. Create ODBC Connection to each database and make connection strings in
.Net to them.
The issue with this is what if I need to grab specific column types from
each .dbf file? How to do?

b. Create ODBC Connection to SQL and link the database to SQL Server. I
am curious ... because SQL
is linking the databases, can I run stored procedures in SQL to join column
types to my project.

You will get more information on that here:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>
<http://www.connectionstrings.com>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Robert Green [MSFT]]

Another option you might consider is to use the Visual FoxPro OLEDB
Provider, which you can download from MSDN. There are differences in
functionality with the OLEDB Provider depending on whether you are using 2.x
databases or VFP (3.0 or later) databases, but it may be helpful to you.

There is also a pretty good article in the MSDN Library on using ASP.NET and
VFP (both code and data) together.

Hope this helps,

Robert Green
Microsoft

"Edb" <m1**@dm2000.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Everyone,

I need to build an ASP.Net project that wraps around a FoxPro Database. It
appears that I need

to create an ODBC Connection to .dbf files. Some of them have relations to each other.

I have not done this before but have a few assesments on how to do it.

a. Create ODBC Connection to each database and make connection strings in
.Net to them.
The issue with this is what if I need to grab specific column types from
each .dbf file? How to do?

b. Create ODBC Connection to SQL and link the database to SQL Server. I
am curious ... because SQL
is linking the databases, can I run stored procedures in SQL to join column types to my project.

I am just curious. I thank everyone in this forum for there assistance.

Happy Day and Happy Coding,
edb