Database code

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
huwnet Members Profile Find Members Posts Senior Member Joined: 30 May 2003 Location: England Status: Offline Points: 1375	Post Options Post Reply Quote huwnet Report Post Thanks(0) Quote Reply Topic: Database code Posted: 13 October 2004 at 1:18pm
	I have some code: Server.MapPath("db.mdb") How do I change is into a physical path?

Misty Members Profile Find Members Posts Senior Member Joined: 06 February 2002 Location: United States Status: Offline Points: 711	Post Options Post Reply Quote Misty Report Post Thanks(0) Quote Reply Posted: 13 October 2004 at 1:38pm
	I am not exactly sure what folder your database is in. But I will give you some code that may help you. Dim path path = Server.MapPath(".") path = Replace(path,"html","database") - assuming that your database is in a database folder outside the html folder. 'Create Connection object strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data " _ & "Source=" & path & "\" & databaseName Did this help? Edited by Misty

dpyers Members Profile Find Members Posts Senior Member Joined: 12 May 2003 Status: Offline Points: 3937	Post Options Post Reply Quote dpyers Report Post Thanks(0) Quote Reply Posted: 14 October 2004 at 11:59pm
	You can also preface it with a series of ../ (or is it ..\ - lol) to back up the path from wherever you are. On some systems, it seems to need an extra set of ../ though so you may need to experiment a little.
	Lead me not into temptation... I know the short cut, follow me.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.