Using visual FoxPro 2.6 files with VB 3.0

Using visual FoxPro 2.6 files with VB 3.0

Post by Nathan Schult » Tue, 14 May 1996 04:00:00



I have a VB application which has been
loading a FoxPro v. 2.5 database with the
opendatabase command.  The data supplier would like
to move to Visual FoxPro v. 2.6 files as the data
source for future releases.  Does anyone have any
experience with this?  Do I need to install the
Access 2.0 compatibility layer?

        Thanks,
                Nathan

 
 
 

Using visual FoxPro 2.6 files with VB 3.0

Post by Peter Mikalajun » Wed, 15 May 1996 04:00:00



>I have a VB application which has been
>loading a FoxPro v. 2.5 database with the
>opendatabase command.  The data supplier would like
>to move to Visual FoxPro v. 2.6 files as the data
>source for future releases.  Does anyone have any
>experience with this?  Do I need to install the
>Access 2.0 compatibility layer?

VB 3.0 out of the box will handle 2.6 files just fine.
Actually, little if anything changed in terms of file
format between 2.5 and 2.6.

Just beware of general fields.  A good xbase
developer can store anything they choose to in
a general field, making it almost impossible to
retrieve with using FoxPro.


http://www.xnet.com/~kd9fb

 
 
 

Using visual FoxPro 2.6 files with VB 3.0

Post by Joe Foster of Bo » Wed, 15 May 1996 04:00:00



> I have a VB application which has been
> loading a FoxPro v. 2.5 database with the
> opendatabase command.  The data supplier would like
> to move to Visual FoxPro v. 2.6 files as the data
> source for future releases.  Does anyone have any
> experience with this?  Do I need to install the
> Access 2.0 compatibility layer?

>    Thanks,
>            Nathan

The compatibility layer combined with the Access Service Pack
will let you use FoxPro 2.6 databases. Here are the relevant
URL's for these and other essential patches:

<ftp://ftp.microsoft.com/softlib/mslfiles/comlyr.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/accsvc.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/vbrun300.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/vbdb300.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/ww1000.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/ww1116.exe>
<ftp://ftp.microsoft.com/softlib/mslfiles/setupk.exe>

The Connect string for FoxPro 2.6 is "FoxPro 2.6;".

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!

 
 
 

Using visual FoxPro 2.6 files with VB 3.0

Post by Nathan Schult » Fri, 17 May 1996 04:00:00



> VB 3.0 out of the box will handle 2.6 files just fine.
> Actually, little if anything changed in terms of file
> format between 2.5 and 2.6.

> Just beware of general fields.  A good xbase
> developer can store anything they choose to in
> a general field, making it almost impossible to
> retrieve with using FoxPro.


> http://www.xnet.com/~kd9fb

        How do I do this with VB 3.0 out of the
Box?  I tried just substituting the new files, and
that didn't work.  I tried changing the FoxPro 2.5
to FoxPro 2.6 in the opendatabase call, but then I
got an unexpected data type error.

        N.

 
 
 

Using visual FoxPro 2.6 files with VB 3.0

Post by Jim Swind » Sun, 19 May 1996 04:00:00



>I have a VB application which has been
>loading a FoxPro v. 2.5 database with the
>opendatabase command.  The data supplier would like
>to move to Visual FoxPro v. 2.6 files as the data
>source for future releases.  Does anyone have any
>experience with this?  Do I need to install the
>Access 2.0 compatibility layer?
>    Thanks,
>            Nathan

Your comments above say "Visual Foxpro" and "2.6".  These are not the
same.  Visual Foxpro was version 3.0 and has a totally different table
structure than 2.5 and 2.6.  I don't know if there is any connection
into 3.0 or not...


 
 
 

1. ForSale/Trade: FoxPro 2.6 for Windows and Visual FoxPro 3.0

For sale:

        FoxPro 2.6 For Windows, Standard Edition........... $60/obro

        Visual FoxPro 3.0 Professional Edition Upgrade..... $275/obro

Both are in new conditon.  Manuals for 2.6 a still in shrink wrap.  3.0
used once.  Neither have been registered yet.  I am looking for FoxPro
2.6 for Windows Professional Edition.  I would prefer to do a trade+cash
deal with one or both of the above programs.

-Jon

2. CREEPING HEADER IN ACE

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

4. Help? Any VB programmers care to assist?

5. VB 3.0 and FoxPro 2.6 Help

6. Retrieving I/O Statistics within Stored Procedure

7. VB 3.0 and FoxPro 3.0 files

8. full-text search in SQL7 w/stored procs

9. FP 2.6, VFP 3.0, VB 3.0 and the future in client/server

10. WTB:FoxPro 2.6 (std/pro),Foxbase+,FoxPro 2.0,VFPro 3.0

11. Visual Basic App using Foxpro 2.6 DB

12. Using FoxPro 3.0 tables in VB using ADO

13. SET NULL OFF in FoxPro 2.6 Using VB and ADO