Uploading Connection String?

[Guest]

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

 

[Guest]

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]]

Hi Arne,

More like:

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