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
|
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. |
michael wrote:Posted By: MackDaddy
Date Posted: 26 February 2003 at 6:03am
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, ------------- There have been many, many posts made throughout the world... This was one of them. |