Newbie question on OleDbConnection

[Richard Lu]

Hi all,

In VB.NET I want to use access MS MDB database, and use following code.

....
Dim myConnection As OleDbConnection
....

But the compiler warns me that 'undefined type OleDbConnection', is there
anything missing?

 

[Larry Lard]

Hi all,

In VB.NET I want to use access MS MDB database, and use following code.

...
Dim myConnection As OleDbConnection
...

But the compiler warns me that 'undefined type OleDbConnection', is there
anything missing?

Make sure that System.Data.dll is included in the project's References
(it will be by default).

Make sure you have this statement

Imports System.Data.OleDb

at the start of each code file that uses OleDb objects. Or add
System.Data.OleDb to the global Imports list for the project (in
project properties).

 

[Lurc]

Done, thanks Larry.

Make sure that System.Data.dll is included in the project's References
(it will be by default).

Make sure you have this statement

Imports System.Data.OleDb

at the start of each code file that uses OleDb objects. Or add
System.Data.OleDb to the global Imports list for the project (in
project properties).