Name 'Application' is not declared

[yousuf42]

ProtectedConst Oledb Connection String error

ProtectedConst Oledb Connection String error

--------------------------------------------------------------------------------

I have a class module DataAccessLayer and I declared the following in the module.

ProtectedConst OLEDB_CONNECTION_STRING As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Application.StartupPath & "\..\..\Northwind.mdb;" & _
"User Id=admin;Password="

But the above statement appears as error and can't connect to database. anyone can help please?


Thanks in Advance

 

[yousuf42]

ProtectedConst Oledb Connection String error

I have a class module DataAccessLayer and I declared the following in the module.

ProtectedConst OLEDB_CONNECTION_STRING AsString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Application.StartupPath & "\..\..\Northwind.mdb;" & _
"User Id=admin;Password="

But the above statement appears as error and can't connect to database. anyone can help please?


Thanks in Advance

 

[JohnH]

Application class belongs to System.Windows.Forms namespace. I don't think you need it. To get from virtual application path to physical server path you have to use the MapPath method. You can't declare a constant with a variable value (!). Try this:

Protected dbFileName As String = New IO.FileInfo(IO.Path.Combine(Server.MapPath("."), _
  "..\..\Northwind.mdb")).FullName
 
Protected OLEDB_CONNECTION_STRING As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=" & dbFileName & ";User Id=admin;Password="