Question Type 'OleDbConnection' is not defined

[ravi_dangi]

i got this error Type 'OleDbConnection' is not defined

my code is:-
Imports System.Data.OleDb
Public Class View2
Dim mycn As OleDbConnection = New OleDbConnection(cs)
Dim Command As OleDbCommand
Dim i As Integer
Dim SQLstr As String
Dim dr As OleDbDataReader
Dim ver As Integer


for cs means:-
Module connection_Strings
Public cs As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\usofverification.mdb"
End Module

 

[kulrom]

Well you have the Imports System.Data.OleDb statement on your page and everything else looks fine to me.
I even tried to reproduce the issue creating a new project with a form named View2 and then i added module named connection_Strings.
It works for me

 

[kulrom]

Can you think of anything that may help us identifying the issue? OS, .NET FW, IDE ...?

Maybe the compiler is not complaining about this specific declaration? Is it possible that you have another OleDbConnection object somewhere in the project?

 

[cjard]

Possibly he doesnt have a reference to System.Data.OleDb DLL.. ?

ravi, delete this project and start another one.. BUT, read the DW2 link in my signature, section "Creating a Simple Data App" - follow that Microsoft tutorial and you'll have your database program up and running in about 10 minutes, posibly less

 

[kulrom]

Possibly he doesnt have a reference to System.Data.OleDb DLL.. ?

Hmm it is weird cuz it does not complain about the Import directive.
It must be something else i believe. Otherwise Imports line would be underlined by the intellisense as well. Wouldn't it?