Global connection string to Access Databse

[Colin Graham]

i am currently developing an asp.net web application which is linked
to an Access database.

The main problem that i have is in creating a global pathname that i
can access. When i put my string into either the appsettings or a
global settings module i get an error on the server.mappath part of
the string. how can i get round this as i dont want to have to use a
specific path for the web application. it seems that this should be
easy as i can use a relative path in other parts of the system.

I suppose i could set a session state value or application state value
on start up but i hope someone can shed some light on my issue.

thanks in advance

C

[billmiami2]

Colin,

What is the exact error that you get when you try to get the physical
path with Server.MapPath? Also, how are you creating a connection
string? Are you appending the results of your MapPath to the
DataSource part of the connection string?

I always store my connection strings in an appSettings block in my
web.config file. I think that for MS Access, the connection string
(ODBC or OLEDB) requires you to use the physical path for the database,
but I don't see why you couldn't store the location of the database as
a relative path, map it to a physical location and then use the result
to create a connection string.

Bill

Colin Graham wrote:

i am currently developing an asp.net web application which is linked
to an Access database.

The main problem that i have is in creating a global pathname that i
can access. When i put my string into either the appsettings or a
global settings module i get an error on the server.mappath part of
the string. how can i get round this as i dont want to have to use a
specific path for the web application. it seems that this should be
easy as i can use a relative path in other parts of the system.

I suppose i could set a session state value or application state value on start up but i hope someone can shed some light on my issue.

thanks in advance

C