Web Wiz Forums - SQL Server problem

Print Page | Close Window

SQL Server problem

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=22241
Printed Date: 08 April 2026 at 11:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server problem

Posted By: Helliconia
Subject: SQL Server problem
Date Posted: 21 December 2006 at 12:53pm

This is my first foray into ASP and I'm having some difficulties setting up the forums.

For testing purposes i'm running IIS and Sql Server Express on my pc while i develop the site then will move it to a webhost when complete.

My problem is this error I get when i try and open the index.asp page after completing setup:

---------------------------

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'tblDateTimeFormat'.

/functions/functions_date_time_format.asp, line 78

-----------------------------

the line mentioned is:

rsDateTimeFormat.Open strSQL, adoCon

The table 'tblDateTimeFormat' exists in the sql db, so whats the problem with it?

Is this the first place where the website connects to the website?

I'm completely lost here!

Replies:

Posted By: michael
Date Posted: 21 December 2006 at 2:02pm

Yeah it;s the first table being looked up. I believe you that the table exists but you also need to make sure that you connections file is pointing to the right database. Do a quick search on this forum, there have been a few posts about exactly this issue.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Helliconia
Date Posted: 21 December 2006 at 9:08pm

OK I searched threads and tested a few of the ideas i found.

If i setup the ForumUser account with DBO schema and access permissions I get the same error as above. If I give it Administrator access the forum works.

Any handy hints on why the DBO access wasn't working? I would really rather not have the user details sitting in code for an account with admin privileges for the db.