Print Page | Close Window

REALLY need some help here!!!!!!!!!

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=472
Printed Date: 29 March 2026 at 3:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: REALLY need some help here!!!!!!!!!
Posted By: MackDaddy
Subject: REALLY need some help here!!!!!!!!!
Date 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



-------------
MD



Replies:
Posted By: mstrujic
Date 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...

 



Posted By: MackDaddy
Date 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



-------------
MD


Posted By: michael
Date 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;"


Posted By: MackDaddy
Date 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



-------------
MD


Posted By: Str8Dog
Date Posted: 24 February 2003 at 11:37am
DSN and DNS are two very differnt things... but I think it was a typo...

-------------
http://www.str8dog.com/ - [IMG - http://www.str8dog.com/images/str8dog.gif -
I wasn't born with enough middle fingers.


Posted By: MackDaddy
Date 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



-------------
MD


Posted By: Bunce
Date 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.


Posted By: michael
Date Posted: 25 February 2003 at 7:55pm
I guess you just deny the IUSER execution right on the component (dll)


Posted By: MackDaddy
Date Posted: 26 February 2003 at 4:12am

So it's reasonale to ask them (host) to change the permissions on the IUSER execution to allow this?

The ironic thing is, I'm using the Access 2000 DSN-less connection on my other webspace with the same provider - http://www.thesparklers.co.uk/forum - www.thesparklers.co.uk/forum !!!!

I've emailed them again and await their answer.

short of this, I'm off to find a new host, any recommendations for cheap reliable ASP hosting?????



-------------
MD


Posted By: Bunce
Date Posted: 26 February 2003 at 5:31am

Originally posted by michael michael wrote:

I guess you just deny the IUSER execution right on the component (dll)

You mean the jet or odbc driver .dll?  I guess that would work, but wouldn't the DSN still utilise the same driver dll's, and that would use the same permissions.. I think ??

Why would they go to that trouble anyway? 



-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: MackDaddy
Date Posted: 26 February 2003 at 6:03am
Originally posted by Bunce Bunce wrote:

Originally posted by michael michael wrote:

I guess you just deny the IUSER execution right on the component (dll)

You mean the jet or odbc driver .dll?  I guess that would work, but wouldn't the DSN still utilise the same driver dll's, and that would use the same permissions.. I think ??

Why would they go to that trouble anyway? 

 

I guess the thing that really bugs me is that the driver I used for one site doesn't work for another, despite being hosted by the same company (Hostonce.com). and, some of the ASP stuff I already use on the appledaft site (Minisurvey poll and newsboard) work, but the forum doesn't!!!

Is it me, or should I really be hassling the host?



-------------
MD


Posted By: Bunce
Date Posted: 26 February 2003 at 6:24am

If you're 100% certain that the code is identical then I would contact the host.

Check what versions of MDAC, ODBC etc they are running perhaps.

Cheers,
Andrew



-------------
There have been many, many posts made throughout the world...
This was one of them.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net