Using VB and ADO.NET

[Shooter4Life8]

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)

 

[Cor Ligthert [MVP]]

www.connectionstrings.com is your first friend.

Cor

 

[rowe_newsgroups]

I don't use the datasource wizards, so I can't help you there. But if
you want to set up your connection through standard coding, then the
following link will walk you through it:

http://support.sas.com/ctx/samples/index.jsp?sid=817

And for the connection strings:

www.connectionstrings.com

Personally, I built a shared class that handles all my connections,
then if I need to change the methods for a project I just inherit that
class and override/overload any methods I need to change. Just my
opinion.

Thanks,

Seth Rowe

 

[Shooter4Life8]

I think I got it fixed