Database not found

[emadmilan]

hi


when i try to connect to my database which is MS Access file i get this error
Could not find file 'C:\Users\Emad N. Alrwaily\Desktop\Sorting\Projects\WebSite1\MyDataBase.mdb'

and this hapen to my i put the connection string like this

Dim StrCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDataBase.mdb;"

but when i put the full path of the database directory it work like this

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Emad N. Alrwaily\Desktop\Sorting\WebSites\WebSite1\MyDataBase.mdb;"

please help

 

[arjmand]

Hi

Not sure, but try "..\", like this

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\MyDataBase.mdb;"

 

[JohnH]

server.mappath() is used in this sample: ASP.NET Database Connection