I used the following mapPath connection string for several weeks with no problem:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../database/aura.mdb")
Then I started getting errors and I would change to:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../../database/aura.mdb")
and it work for a while. Again a couple days later or a few hours later, I would get error messages, saying database path could not be found. I would change back to the first string and it work again until the next error.
Then I read in that mapPath doesn't work well at my host, Brinkster. So I changed to the following physical path:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "Data Source=\\premfs14\sites\premium14\aasg\database\aura.mdb;"
But now I get the following error message:
Microsoft JET Database Engine error '80004005'
'C:\WINDOWS\system32\Data Source=\premfs14\sites\premium14\aasg\database\aura.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/aura/research.asp, line 8
Could someone please tell me what I am doing wrong? I am absolutely sure the path is correct. Even used <%= Server.MapPath("\")%> to check it.
Why is it putting 'C:\WINDOWS\system32\ in the error?