Web Wiz Support and Community Forums : SQL Server problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 11:56:53 +0000 Thu, 21 Dec 2006 21:08:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22241 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server problem : OK I searched threads and tested...]]> https://forums.webwiz.net/sql-server-problem_topic22241_post118535.html#118535 Author: Helliconia
Subject: 22241
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.


]]> Thu, 21 Dec 2006 21:08:30 +0000 https://forums.webwiz.net/sql-server-problem_topic22241_post118535.html#118535 <![CDATA[SQL Server problem : Yeah it;s the first table being...]]> https://forums.webwiz.net/sql-server-problem_topic22241_post118515.html#118515 Author: michael
Subject: 22241
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.]]> Thu, 21 Dec 2006 14:02:03 +0000 https://forums.webwiz.net/sql-server-problem_topic22241_post118515.html#118515 <![CDATA[SQL Server problem : This is my first foray into ASP...]]> https://forums.webwiz.net/sql-server-problem_topic22241_post118505.html#118505 Author: Helliconia
Subject: 22241
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!
]]> Thu, 21 Dec 2006 12:53:36 +0000 https://forums.webwiz.net/sql-server-problem_topic22241_post118505.html#118505