Using visual FoxPro 2.6 files with VB 3.0 
Author Message
 Using visual FoxPro 2.6 files with VB 3.0

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



Fri, 30 Oct 1998 03:00:00 GMT  
 Using visual FoxPro 2.6 files with VB 3.0

Quote:

>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



Sat, 31 Oct 1998 03:00:00 GMT  
 Using visual FoxPro 2.6 files with VB 3.0

Quote:

> 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!



Sat, 31 Oct 1998 03:00:00 GMT  
 Using visual FoxPro 2.6 files with VB 3.0

Quote:

> 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.



Mon, 02 Nov 1998 03:00:00 GMT  
 Using visual FoxPro 2.6 files with VB 3.0

Quote:

>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...




Wed, 04 Nov 1998 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. VB 3.0 and FoxPro 2.6 Help

2. Opening a Foxpro 2.6 database using VB 6.0

3. Querys to a FoxPro 2.6 for DOS table using with 1.9 million records

4. read/write FoxPro 2.6 *and* Access 97 database files

5. VB 3.0 and FoxPro 3.0 files

6. VB .NET Standard & FoxPro 2.6

7. Exporting Data in VB 4.0 to a FoxPro 2.6 DBF Format

8. Index not found! VB open FoxPro 2.6 table

9. Index not found! VB open FoxPro 2.6 table

10. packing/reindexing foxpro 2.6 from vb

11. VB and FoxPro 2.6 Indexing?

12. Accessing Foxpro 2.6 DBF from VB with indices

 

 
Powered by phpBB® Forum Software