dbase III, IV, 5 files and ADO 2.0

13 Feb 2007 2:17 PM

ray well

hi,

how can i access a dBase *.dbf database in CODE only, in Visual Basic .Net
2005 and Ado 2.0 ?

this is for a off site machine where i have to access the data thru code.
how do i make the connection and which provider do i use? all the code i saw
is for Sql server or Access. i would prefer to access the database directly
without using an Access front end to which the *.dbf files are linked.

a few lines of code would be appreciated.

thanks,

ray

13 Feb 2007 4:38 PM

Miha Markic [MVP C#]

"ray well" <nospam@nospam.com> wrote in message
news:OIvgRo3THHA.1364@TK2MSFTNGP06.phx.gbl...
> hi,
>
> how can i access a dBase *.dbf database in CODE only, in Visual Basic .Net
> 2005 and Ado 2.0 ?
>
> this is for a off site machine where i have to access the data thru code.
> how do i make the connection and which provider do i use? all the code i
> saw is for Sql server or Access. i would prefer to access the database
> directly without using an Access front end to which the *.dbf files are
> linked.

You should use OleDb provider and for the connection string see here:
http://www.connectionstrings.com/

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/