Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Create DSN
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Create DSN

 Post Reply Post Reply
Author
WestN10 View Drop Down
Newbie
Newbie
Avatar

Joined: 25 February 2005
Location: United States
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote WestN10 Quote  Post ReplyReply Direct Link To This Post Topic: Create DSN
    Posted: 25 February 2005 at 5:48pm
My hosting company requires the database with the free forums to be placed within a database folder separate from the database folder within the free forums.  How do I create a DSN to point to the new folder, if that's what I need to do?
 
Please somebody help!
 
Thanks,
Nate
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 25 February 2005 at 7:46pm
The instructions that come with the forum illustrate how to relocate the db.
 
For a dsn-less connection, you basically specify the physical path - e.g. D:\hosting\myaccount\db~~~
 
For a DSN connection, your host will have a function in your control panel for creating dsn's and specifying the path to the db. If they don't, you will need to submit a trouble tiket to them to have them create one. The db must already exist on the host for them to create a dsn to it.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2005 at 2:49pm
Also, I'd recommend using the physical pathway (dsn-less) as dypers suggested. DSN connections make a registry call each time which is a slight performance hit over a dsn-less connection. Of course, the database folder needs to be located above root or have web/browse access disabled if below root and using the dsn-less connection.

If you need a script that will tell you the physical pathway, send me an email and I'll see if I can help you out.
Back to Top
WestN10 View Drop Down
Newbie
Newbie
Avatar

Joined: 25 February 2005
Location: United States
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote WestN10 Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2005 at 11:49am
Appreciate the help!  Got the DSN setup with the hosting company, but I may try the dsn-less connection.  Thanks again!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.