469,964 Members | 1,788 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

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
Nov 20 '05 #1
2 1167
* "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>
Nov 20 '05 #2
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

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Simon Bailey | last post: by
4 posts views Thread by Salad | last post: by
14 posts views Thread by John Spiegel | last post: by
3 posts views Thread by Burak Gunay | last post: by
2 posts views Thread by Toco | last post: by
3 posts views Thread by Salad | last post: by
7 posts views Thread by z71mdridin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.