news:1161361964.309235.152200@b28g2000cwb.googlegroups.com...
> Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
> .NET. I would like to create an ADO.NET connection to a local Access
> database.  Any pointers or helpful informational sites would be much
> appreciated :)
>
> My main questions are:
>
> Do I need to add the OleDbDataAdapter and OleDbConnection objects from
> the data portion of the tool box? If so how do I get it to connect to a
> local (on my local harddrive) access database? When I have tried, I
> have right clicked the OleDbDataAdapter and gone to configure data
> adapter then I click New Connection. I'm not sure what to put in the
> fields to get it to connect to the database.
>
> If not, i've read about using some sort of connection string. (same
> problem again. not sure what the connection string is for a local
> database)
>

> Connection string for local Access database:
>
> "Provider=Microsoft.JET.OleDb.4.0;Data Source=" & pathToDatabase
>
> http://www.ConnectionStrings.com
>
>
> <Shooter4Li***@gmail.com> wrote in message
> news:1161361964.309235.152200@b28g2000cwb.googlegroups.com...
> > Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003
> > .NET. I would like to create an ADO.NET connection to a local Access
> > database.  Any pointers or helpful informational sites would be much
> > appreciated :)
> >
> > My main questions are:
> >
> > Do I need to add the OleDbDataAdapter and OleDbConnection objects from
> > the data portion of the tool box? If so how do I get it to connect to a
> > local (on my local harddrive) access database? When I have tried, I
> > have right clicked the OleDbDataAdapter and gone to configure data
> > adapter then I click New Connection. I'm not sure what to put in the
> > fields to get it to connect to the database.
> >
> > If not, i've read about using some sort of connection string. (same
> > problem again. not sure what the connection string is for a local
> > database)
> >