database problems

[knutlig]

Hi...This works when i run it on my iis server "Data Source=c:\inetpub\wwwroot\johannes\news.mdb"

When i put it on my server i get this error message: 'c:\db\news.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

I have changed the path to Data Source=news.mdb since the mdb file is in the same folder as the file that acces the database, but something is wrong. I know i need to write something else that "Data Source" but i dont konw what. Can someone help me please

Cheers Knut

 

[Administrator]

You'll need to use the Server.MapPath() method to pass in the proper location on the server if not specified correctly in code or your configuration.

 

[knutlig]

how does the Server.MapPath() work?

Im wondering how to write the connectionpath using the Server.MapPath() function...

Cheers

 

[levyuk]

Just like this

Dim details As OleDbConnection
details = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database/details.mdb"))