ADO & FoxPro

ADO & FoxPro

Post by hein » Fri, 12 Apr 2002 06:17:36



Is there a way to create and query foxpro database files
from within VB 6.0 using ADO?  I.e. I want to create
temporary tables for use only while the VB app is running.

Thanks

 
 
 

ADO & FoxPro

Post by Merv Coupe » Fri, 12 Apr 2002 13:32:17


The answer is Yes

The easy way to get to hold of the ADO Fox Pro Driver etc is by buying a
copy of

ADOAnywhwere at

http://www.adoanywhere.com/

It is quite cheap and can be a life saver

Also if you search on MSN for ADO FoxPro Driver you should find the method
to connect to your FoxPro table

The Driver will run in ADO 2.1

Regards

Merv Couper


Quote:> Is there a way to create and query foxpro database files
> from within VB 6.0 using ADO?  I.e. I want to create
> temporary tables for use only while the VB app is running.

> Thanks


 
 
 

ADO & FoxPro

Post by Mike Collie » Fri, 12 Apr 2002 21:17:53


Thanks for the reference Merv.

To create a table, use CREATE TABLE statements, if you have a table already,
AdoAnywhere will show you the CREATE TABLE syntax for FoxPro to get you
going..

--
Michael Collier Bsc (Hons)

Interactive ADO Object Browser (Free Trial) www.adoanywhere.com
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com

--


> The answer is Yes

> The easy way to get to hold of the ADO Fox Pro Driver etc is by buying a
> copy of

> ADOAnywhwere at

> http://www.adoanywhere.com/

> It is quite cheap and can be a life saver

> Also if you search on MSN for ADO FoxPro Driver you should find the method
> to connect to your FoxPro table

> The Driver will run in ADO 2.1

> Regards

> Merv Couper



> > Is there a way to create and query foxpro database files
> > from within VB 6.0 using ADO?  I.e. I want to create
> > temporary tables for use only while the VB app is running.

> > Thanks

 
 
 

1. ADO & Foxpro

Any good places that use vb and use foxpro tables to look at??
have many foxpro tables but want to start using vb but keep
the tables for now until the oracle is ready.  until then i need to
use foxpro. so anyone have a good example on connection to
a foxpro table that actually works?

and can u import ascii files without having to break it down
like the fields in the table?

any help would be great thanks

jb

2. using symbolic links with ORACLE_HOME variable in unix - WARNING

3. Foxpro & ADO

4. sysdepends bug - The Neverending Story

5. FoxPro Indexes & ADO

6. help needed

7. profiler

8. VB + ADO + FOXPRO DB + PACK TABLES & DATABASE

9. FoxPro & Visual FoxPro Developers

10. FoxPro Mac FoxPro 2.5 & JetEngine

11. Microsoft Foxpro & Visual Foxpro Accessing Informix

12. How to Save data in Foxpro 2.6 using Visual Foxpro Driver (ADO)