Re: Connection to dBase file but not using .dbf extentions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 16:04:00 -0500

On Mon, 16 Aug 2004 19:44:13 GMT, "Andy" <Roonz@Ameritech.Net> wrote:

¤ Hey all, Was wondering if there is another parameter to pass along with the
¤ rest of the connection string to have Jet look for a dBase connection using
¤ something other than .dbf?
¤
¤ Here's my conn string for reference...
¤
¤ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cDataPath & ";Extended
¤ Properties=dBASE IV;"
¤
¤ We just happen to use the extension .DAT for all of our database files.
¤

I don't believe the driver will recognize the file with a different extension. There was a
workaround in DAO, by including the file and extension separated by #, but I don't believe that
works with Jet OLEDB and the ISAM driver. Haven't tried it using ODBC.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: Importing csv files must have a csv extension?
    ... > I don't know of any limitation that prevents you from using a text ... > with an extension other than csv, but I can't say without a doubt that ... > Note you can set the extensions in the connection string. ... > to have the support files for the Jet provider, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... In some versions of .NET, if not all, you have to install JET ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... I still get the sam message in my output window. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Use ADO.net 3.5 to connect with Excel 2003
    ... I try to google and everywhere give me the same connection string. ... The OLEDB providers for JET shipped separately from the standard MDAC. ... In some versions of .NET, if not all, you have to install JET ... I cannot find the download page, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Reinstall Microsoft Jet 4.0
    ... I don't think there's any uninstall for Jet. ... settings and/or connection string settings rather than Jet being corrupted. ... Making sure your table has a primary key field may also help solve ...
    (borland.public.delphi.database.ado)