CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)
Microsoft OLE DB Provider for SQL Server (0x80040E14) Invalid object name

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
6
Date Created
Sunday, September 26, 2010
Last Updated
Wednesday, November 24, 2010
This Article Has been Viewed
2434 times
Short Desc
When writing out our SQL Statments, we sometimes misspell our Table and or column names, when this is done we cause these simple irritating error like Microsoft OLE DB Provider for SQL Server (0x80040E14)
Details
In your Select Statement, you sometimes make simple typo errors that can cause asp to send an error to the page.
In this case, it was a the adding of a letter to our TableName that caused this error.

Microsoft OLE DB Provider for SQL Server (0x80040E14)
Invalid object name 'GetResolved'.
/kb/Header.asp, line 139
Recreate Issue
This select statment that we used that threw this error to the browser is:

<%
Set getIssue = CreateObject("ADODB.Command")
getIssue.ActiveConnection=objConn
getIssue.Prepared = true
getIssue.commandtext="SELECT ID, Title FROM GetResolved"
set rsIssue = getIssue.execute
%>

As you can see in the above statement the TableName is:
IssueResolved
This is incorrectly spelled out.
Resolve Issue
To resolve this issue, simply spell the TableName correctly and recompile your code to the browser.

<%
Set getIssue = CreateObject("ADODB.Command")
getIssue.ActiveConnection=objConn
getIssue.Prepared = true
getIssue.commandtext="SELECT ID, Title FROM GetResolve"
set rsIssue = getIssue.execute
%>

All Topics