Uploading Connection String?

[Arne Beruldsen]

I've got a Web App developed via VBNet. I'm using WebForms and a small Access database. It's easy enough to set the connection string when the database is on my local machine. However...I need to upload both the app and the database. Is there a way I can set the connection string similar to the old App.path routine?

Thanks

[Ken Cox [Microsoft MVP]]

Hi Arne,

I suspect you are looking for server.mappath("accessdb.mdb") to use in
building the connection string.

Ken
"Arne Beruldsen" <Ar***********@discussions.microsoft.com> wrote in message
news:8F**********************************@microsof t.com...

I've got a Web App developed via VBNet. I'm using WebForms and a small
Access database. It's easy enough to set the connection string when the
database is on my local machine. However...I need to upload both the app
and the database. Is there a way I can set the connection string similar
to the old App.path routine?

Thanks

[Arne Beruldsen]

Thanks...
I think that's what I need...should the line in the connection string look like this?
....
"DataSource=server.mappath("MyDB.mdb"); " & _
....

It doesn't seem to accept it the way I have it written.

Thanks...
"Ken Cox [Microsoft MVP]" wrote:

Hi Arne,

I suspect you are looking for server.mappath("accessdb.mdb") to use in
building the connection string.

Ken
"Arne Beruldsen" <Ar***********@discussions.microsoft.com> wrote in message
news:8F**********************************@microsof t.com...

I've got a Web App developed via VBNet. I'm using WebForms and a small
Access database. It's easy enough to set the connection string when the
database is on my local machine. However...I need to upload both the app
and the database. Is there a way I can set the connection string similar
to the old App.path routine?

Thanks

[Ken Cox [Microsoft MVP]]

Hi Arne,

More like:

"DataSource=" & server.mappath("MyDB.mdb") & "; " & _

"Arne Beruldsen" <Ar***********@discussions.microsoft.com> wrote in message
news:4F**********************************@microsof t.com...

Thanks...
I think that's what I need...should the line in the connection string look
like this?
...
"DataSource=server.mappath("MyDB.mdb"); " & _
...

It doesn't seem to accept it the way I have it written.

Thanks...