Print Page | Close Window

Error Type:....

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=5047
Printed Date: 02 April 2026 at 4:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Error Type:....
Posted By: madcap
Subject: Error Type:....
Date Posted: 15 August 2003 at 11:04am

I'm trying to get the forums to work locally on my pc so that i can redesign a site I built...however when I try to load the forums I keep getting the following error...

I've changed the UID and Password for the site (which runs off an MS SQL 2000 db and I've integrated the tables etc of the webwizforums into the SQL db) but now get the error below...can anyone please throw / shed some light on what the problem is so that I can try and resolve it?

TIA

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

  • Error Type:
    Microsoft OLE DB Provider for SQL Server (0x80040E09)
    SELECT permission denied on object 'tblForum', database 'gfg2003', owner 'dbo'.
    /forumsgfg/default.asp, line 438

    Line 438 is: rsStatistics.Open strSQL, strCon




  • Replies:
    Posted By: gate-11
    Date Posted: 15 August 2003 at 11:38am
    you have no writes to write or read from the db!


    Posted By: madcap
    Date Posted: 15 August 2003 at 11:41am

    okay thanks for the info...but how does one sort read / write on an SQL 2000 db?

    Any info would be really appreciated....



    Posted By: gate-11
    Date Posted: 15 August 2003 at 11:47am

    you have SQL server?

    i thins that you shuld download the ACCESS version...

     

    go to your

    control panel-->admin--> ODBC admin..

    add MS access (*MDB) and give it write/read premmitions.



    Posted By: madcap
    Date Posted: 15 August 2003 at 12:05pm

    Using the Access version isn't an option for me gate-11 as the rest of the site runs from the sql 2000 db.

    So any other ideas gate-11 or anyone?



    Posted By: gate-11
    Date Posted: 15 August 2003 at 12:29pm

    can you run ASP scripts that us access db?



    Posted By: madcap
    Date Posted: 15 August 2003 at 12:54pm
    Yes I can...I can even run asp scripts that run SQL db's but its just certain pages....


    Posted By: gate-11
    Date Posted: 15 August 2003 at 1:33pm
    so whay you don't us ACCESS db?!


    Posted By: madcap
    Date Posted: 15 August 2003 at 4:15pm

    I've sorted it - I deleted and recreated the user and its working fine now...

    I didn't have to resort to Access...




    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