Re: Need ODBC driver for DBF files for VISTA

On May 1, 2:16 pm, Paul Clement
<UseAdddressAtEndofMess...@xxxxxxxxxxxxxx> wrote:
On 1 May 2007 11:40:15 -0700, DK <dwes...@xxxxxxxxxxxxx> wrote:

¤ Does anyone know where to obtain the ODBC driver install file for DBF
¤ files that will install under VISTA.
¤
¤ The 2 that I have will not install with VISTA.

ODBC may not be the best choice. Can you use the ISAM drivers with Jet OLEDB instead?

Maybe you could indicate how you are trying to connect.

Paul
~~~~
Microsoft MVP (Visual Basic)

Paul,

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=Machine;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.


.

Relevant Pages

  • Re: vb6 kill file in Vista
    ... ¤ Hi I have developed an app in vb6 which I am trying to port over to Vista. ... The files that I am trying to delete are all located in this install ...
    (microsoft.public.vb.general.discussion)
  • Re: Need ODBC driver for DBF files for VISTA
    ... ¤ Does anyone know where to obtain the ODBC driver install file for DBF ... The 2 that I have will not install with VISTA. ...
    (microsoft.public.vb.database)
  • Re: VB6 Professional installed on Vista Compatability Issues
    ... ¤ I have been running Microsoft VB6 Professional for quite a while on Windows ... However when I attemted to run my application within VB6 on the Vista ... The SP6 install also needs to be run as an administrator. ...
    (microsoft.public.vb.general.discussion)
  • Re: Jet DB problem with uac
    ... ¤ We have a vb6 app using Jet 4.0. ... When we install on Vista, ... If we turn uac off or start up with "Run as ... You probably need to install the database to an appropriate location. ...
    (microsoft.public.vb.database)
  • Re: clubbing of windows vista and windows server2008 in a single boota
    ... I am not sure if you can go clubbing with Vista or Windows 2008 ... rather than being an 'installer', ... John Pritchard how it all works and got some surprising answers. ... Imaging (.WIM) file, which is basically our operating system folders ...
    (microsoft.public.windows.vista.general)