ADO.NET in VS2003 Connection String for dBASE
- From: "Q Johnson" <QJohnson@xxxxxxxxxxx>
- Date: Wed, 5 Jul 2006 17:42:03 -0500
I'm using VB.NET in Visual Studio 2003. I want to get an ADO.NET connection
to some dBASE V files and cannot find the magic syntax for some reason.
I've tried this
Provider=Microsoft.Jet.OLEDB.4.0;
Initial Catalog=C:\Visual Studio Projects\DE-Trans
Teammate\DeTransTm8\bin\Source_Files;
Data Source=070105DL.dbf;
Extended Properties=dBASE IV
as well as this (switching the initial catalog and data source values):
Provider=Microsoft.Jet.OLEDB.4.0;
Initial Catalog=070105DL.dbf;
Data Source=C:\Visual Studio Projects\DE-Trans
Teammate\DeTransTm8\bin\Source_Files;
Extended Properties=dBASE IV
Neither one of those is working.
The path is known to be good and the file exists there.
But when I try to use the connection object in code like this:
Dim cn As New OleDbConnection(fnGetDbfConnectionString())
cn.Open()
it blows up on the .Open call. (The fnGetDbfConnectionString function
returns the text offered above.)
I've also tried Extended Properties= dBASE 5.0, to no avail (even though it
looks successful in the Connect property in MSysObjects when I link to the
same table from MS Access2003 on this same machine).
I'm out of ideas. Any of you have any?
Q Johnson
.
- Prev by Date: Re: Incorrect syntax near ':'
- Next by Date: Problem with date field in UPDATE statement WHERE clause
- Previous by thread: Re: Incorrect syntax near ':'
- Next by thread: Problem with date field in UPDATE statement WHERE clause
- Index(es):
Relevant Pages
|
|
