ASP Connection String

[Harlequin007]

Morning Everyone.

I have a bit of a problem you might be able to help with. I am using FrontPage to prsent some database results from a database and it works OK. However, I ant the database connection to point to a database located elswhere on the network (as this will save time and effort copying the database accross each time it is updated).

this is the connection string currently (contained in "Global.asa":

Application("ECOTracker_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/DePuy_ECO_Tracker.mdb"

I tried changing the database name to the one on the network using UNC pathname but no joy.

Any suggestions...?

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[seanwest]

im not sure if we are supposed to give out urls here, but all the help you need with connection strings is at
(connectionstrings you know what.)

hope thats ok, dont see why it wouldnt be when its just a valuable resource.

hope it helps.

 

[Harlequin007]

Thanks Sean

You can post URLs mate - providing you aint pushing a product or service.

I checked that page out Sean and unfortunately it didn't have anything about FrontPage.

I'll keep digging around.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------

 

[TonyRosen]

http://www.connectionstrings.com

 

[Tarwn]

With access y0ou not only have to have a file system path, you also have to have permission along that path. So a mapped drive would work and I think a shared folder would work (provided your default IIS user was allowed access or you changed the user to one who already has access).

Best bet might be a mapped drive, but then I'm lazy and can't stand all th use rmanagement stuff I write scripts to add more than one user rather than handle the junk manually

-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/