VB.Net to Access

[GerardMcL]

Hi,

Ive recently switched from VB6 to VB.Net. In VB6 I set up my dbConn As ADODB.Connection then my connection string

Provider=MSDASQL;DSN=SysDSN;

But I have tried this in VB.Net and keep getting a problem I have

Provider=Microsoft.Jet.OLEDB.4.0;DSN=CorlinDSN;

I have a .Net book that is detailing a Data Adapter approach, Can I just make the connection in the forms code?
Thank You for any help.

 

[jebenson]

Try using the OLEDB connection/adapter:

Dim Conn As System.Data.OleDb.OleDbConnection
Dim da As System.Data.OleDb.OleDbDataAdapter
Dim ds As DataSet
Dim ConnStr As String

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\your\access\db\yourdb.mdb;"

Conn = New System.Data.OleDb.OleDbConnection(ConnStr)
Conn.Open()

da = New System.Data.OleDb.OleDbDataAdapter("Select * from <TableName>", Conn)

ds = New DataSet

da.Fill(ds)


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira

 

[ThatRickGuy]

When in doubt...

http://www.connectionstrings.com

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.