Re: Need ODBC driver for DBF files for VISTA

On May 2, 8:34 am, "Cindy Winegarden" <c...@xxxxxxxxxxxxxxxxxxx>
wrote:
Hi DK,

Can you use the FoxPro and Visual FoxPro OLE DB data provider, downloadable
from the link below my signature? It is fully compatible with all versions
of Fox tables and works with Windows Vista.

Also, your connection string is incorrect. If a DBC is present you should
point your connection string toward it ("Provider=VFPOLEDB.1;Data
Source=C:\Temp\MyDBC.dbc;"). A DBC file is a database container and contains
metadata, including the names of the DBFs it contains. If a DBC is not
present, which is probably the case for you, then you should point your
connection string toward the directory where the DBFs are
("Provider=VFPOLEDB.1;Data Source=C:\Temp\;"). In your SQL string you will
refer to the DBF itself by name and without the DBF extension, such as
"Select * From myTable".

As far as the Fox OLE DB data provider goes, it hasn't been updated since
VS6 and will not be tested or updated to work with Windows Vista. There was
a special version that came with Windows 2000 and Win2K would not allow you
to install the 6.01.8629.01 version, which was the final one. I don't know
if that is the case with Vista, and I'm not near my Vista machine to test an
install with that version.

--
Cindy Winegarden
c...@xxxxxxxxxxxxxxxxxxx

VFP OLE DB:http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC:http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

"DK" <dwes...@xxxxxxxxxxxxx> wrote in message

news:1178049874.011840.118180@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 1, 2:16 pm, Paul Clement

I have this one DBF file that for whatever reason cannot be read using
the OLEDB driver.

The connection string being passed is:
Driver=Microsoft Visual FoxPro
Driver;UID=;PWD=;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Ma­chine;Null=Yes;Deleted=Yes;SourceDB=c:
\datafile.dbf

The open statement works perfectly fine with VB6 under XP but fails
when run under VISTA.

The ODBC driver that comes installed with VISTA is version 1.00.02.00
dated 11/2/2006 the one on the XP machine is version 6.01.8629.01
dated 12/7/1999.

You have any idea why the OPEN might fail with an error that says that
function is not supported.

The open statements look like this:
On Error GoTo dberrorDBF
Set cnnDBF = New ADODB.Connection
With cnnDBF
.ConnectionString = ConnectDBF
.Open
End With

The error gets trapped in dberrorDBF.

But the original question was due to the fact that the VFPODBC.MSI
will not run with VISTA.

If version 6....... is the latest then what is the version that's on
the Vista machine?

One interesting thing I've found is that I have both a dotnet 1.1 and
a VB6 program that reads the same DBF file, the dotnet program can
succesfully use the VFPOLEDB provider but the VB6 program has to use
the VFPODBC provider for the same file (if it tries to use the OLEDB
provider it gets an immediate end of file).


.

Relevant Pages

  • Re: Need ODBC driver for DBF files for VISTA
    ... Can you use the FoxPro and Visual FoxPro OLE DB data provider, ... your connection string is incorrect. ... refer to the DBF itself by name and without the DBF extension, ... VS6 and will not be tested or updated to work with Windows Vista. ...
    (microsoft.public.vb.database)
  • Re: Word 07 mailmerge source using dbf
    ... I'll have another look at the Word 2007 + DBF stuff and see if I can spot any additional difficulties in doing the merge "from an app". ... Word is trying to connect using the OLE DB provider ... >> (this is what Word generates when you try to connect manually using ODBC) ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)
  • Re: Word 07 mailmerge source using dbf
    ... MS no longer supports a dbf datasource. ... "Peter Jamieson" wrote: ... Word is trying to connect using the OLE DB provider ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word 07 mailmerge source using dbf
    ... > Be great if you have first hand knowledge that dbf will work with 07. ... Because the OLE DB provider and ODBC driver may return some data - date, numeric, logical and perhaps even text - in different formats, you may need to make a decision as to whether you are going with OLE where it is available or sticking with ODBC. ... .dbf is still listed as a format in the list of formats in Word 2007's Select Data Source dialog box ...
    (microsoft.public.word.mailmerge.fields)
Quantcast