Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - REALLY need some help here!!!!!!!!!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

REALLY need some help here!!!!!!!!!
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
MackDaddy View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MackDaddy Quote  Post ReplyReply Direct Link To This Post Topic: REALLY need some help here!!!!!!!!!
    Posted: 24 February 2003 at 8:10am

I just received my boxed version of WW forum today, and it tests fine on Personal web server (Win98).

Trouble is, when I uploaded it to my webspace, created an ODBC to the database through Control Panel (and tested it OK) I still get the following error.

Provider error '8000ffff'

Catastrophic failure

/forum/common.asp, line 176

My web host advised they don't support DNS-less connections and to use the ODBC instead.

Now, does this mean I comment out all the connections in the common.asp files? If not, how do I format the DNS one (I don't understand the instruction given in the script.

I've run other .asp applications without a hitch. See www.appledaft.org/index2.asp

Is there anything else I'm missing? Any and all help is appreciated here. WW is the best asp forum I've seen (hence why I parted with £12 to get it)

MD
Back to Top
mstrujic View Drop Down
Newbie
Newbie
Avatar

Joined: 24 February 2003
Location: Croatia
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mstrujic Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2003 at 8:23am

You need to define your DNS connection to the base.

After that, try to change whole line in the common.asp  (in the forum folder, and in the admin folder)

from:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strDbPathAndName)

to:

strCon = "DNS=name of your defined connection;"

I think that will work...

 
Back to Top
MackDaddy View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MackDaddy Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2003 at 8:26am

Cheers!

I take it the "defined connection" means the physical path to the database? i.e. e://wwwroot/inetpub/blah blah blah.....

 

MD
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2003 at 11:00am
No your host will setup a dsn let's call it MackDaddy. This dsn points to e:\blahblahblah all you would have to drive would be:
strCon = "DSN=MackDaddy;"
Back to Top
MackDaddy View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MackDaddy Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2003 at 11:20am

cheers,

just to be absolutely sure: DSN and DNS are the same thing (just a typo?)

setting up ODBC through my control panel doesn't make the blindest bit of difference?

Contact my host to request a DNS to point top the physical path wher e the forum database sits - eg - e://blah blah/blah?

Thanks again fro all your help

E
Back to Top
Str8Dog View Drop Down
Senior Member
Senior Member


Joined: 18 December 2001
Location: United States
Status: Offline
Points: 2118 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Str8Dog Quote  Post ReplyReply Direct Link To This Post Posted: 24 February 2003 at 11:37am
DSN and DNS are two very differnt things... but I think it was a typo...
[IMG"> http://www.str8dog.com/images/str8dog.gif">
I wasn't born with enough middle fingers.
Back to Top
MackDaddy View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MackDaddy Quote  Post ReplyReply Direct Link To This Post Posted: 25 February 2003 at 8:06am

Right,

I have now tried everything suggested to no avail - I'll email my host and ask them to look at it

Thanks to all who helped in this post

MD
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 25 February 2003 at 6:12pm
How can a host disallow a DSN-Less connection?
There have been many, many posts made throughout the world...
This was one of them.
Back to Top
 Post Reply Post Reply Page  12>

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.