access 2000 definition file

Hi,

I tried to define my db connection following

Const m_DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=abc1234/s/database/database.mdb;'


the db file that I put in the discountasp.net hosting

which I run the webpage, and it showed

Microsoft JET Database Engine error '80004005'

Disk or network error.

/s/Data.asp, line 79

I think it delas with the path that I define, could anyone please teach me how to do.

Thx
Frank

 

Hi,
What you more than likely want is a Server.MapPath method like this:


Dim m_DSN
m_DSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("abc1234/s/database/database.mdb") & ";"

 

thank you so much