Chris Moore
|
Posted: 08/13/2003, 9:38 AM |
|
I need to publish my web page to my server. It uses an Access database. I
have read the KB article on using the Server.MapPath("database.mdb")
setting.....but....where do I place this? If I place it in the Connection
settings under Project Settings, I get a connection error because it
doesn;t like the quotes in there. Am I supposed to manually place override
code in at the top of every ASP that access's the database? If so, where
does this code go?
How should I handle this?
Thanks
Chris
|
|
|
DonB
|
Posted: 08/13/2003, 1:37 PM |
|
You should deploy your database outside of the website's folder structure
for security reasons. You don't want to make it possible to construct a URL
that points to the MDB file - because then someone can download it in its
entirety.
Server.MapPath will construct a path to some location within your website.
Therefore, MapPath is a nonsolution to your problem.
Pick a directory, and establish that as the location for the database by
defining the connectionstring in the Project settings. YOu really don't
have a good way to alter the connection string prior to the connection being
opened (this occurs before you have any opportunity to intervene by way of
an Event routine).
I decided to define my development database location to be on the same path
as my webserver - my ISP decided where that location was so I had no choice
in selecting it.
DonB
"Chris Moore" <chris@dblayout.com> wrote in message
news:Xns93D676C1AECB4cabubba@66.180.229.147...
> I need to publish my web page to my server. It uses an Access database. I
> have read the KB article on using the Server.MapPath("database.mdb")
> setting.....but....where do I place this? If I place it in the Connection
> settings under Project Settings, I get a connection error because it
> doesn;t like the quotes in there. Am I supposed to manually place override
> code in at the top of every ASP that access's the database? If so, where
> does this code go?
>
> How should I handle this?
>
> Thanks
>
> Chris
|
|
|
Kåre Simensen
|
Posted: 08/16/2003, 2:21 AM |
|
Hi Chris
I use access-database and with a connection string like this:
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&
server.MapPath("\fpdb\Nyheter.mdb")&";Persist Security Info=False"
"Chris Moore" <chris@dblayout.com> wrote in message
news:Xns93D676C1AECB4cabubba@66.180.229.147...
> I need to publish my web page to my server. It uses an Access database. I
> have read the KB article on using the Server.MapPath("database.mdb")
> setting.....but....where do I place this? If I place it in the Connection
> settings under Project Settings, I get a connection error because it
> doesn;t like the quotes in there. Am I supposed to manually place override
> code in at the top of every ASP that access's the database? If so, where
> does this code go?
>
> How should I handle this?
>
> Thanks
>
> Chris
|
|
|
|