Web Wiz NewsPad - SQL 2005 Parameters

Print Page | Close Window

SQL 2005 Parameters

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24831
Printed Date: 28 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL 2005 Parameters

Posted By: JDub
Subject: SQL 2005 Parameters
Date Posted: 15 November 2007 at 2:44am

I just know I have something wrong but cannot put my finger on it.

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

Invalid object name 'tblNPConfiguration'.

/newspad/common.asp, line 137

I have only modified this area of the

strSQLServerName = "my sql 2005 URI here" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "my username" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "my password" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "my DB name"

There are no special characters whatsoever. What am I missing here ... thanks in advance for the second set of eyes.

FYI the SQL server setup ASP worked fine.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 15 November 2007 at 8:50am

It's certainly connecting to the database, so the db connection details are fine.

The error is saying that it can not find the table tblNPConfiguration. Try opening the database and checking that this table exists in the database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting