467,081 Members | 1,140 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

Invalid object name 'TABLE'

Can someone please tell me why I keep getting the following error? I think
it is part of the connection but can't pin down the exact error. I would be
grateful if someone might have any ideas.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'itemSecUsers'.
/eOrders/_ScriptLibrary/Recordset.ASP, line 466

...:: CODE ::..

function _RS_open()
{
if (this._rsADO != null)
{
if (!this.isOpen())
{
this._objEventManager.fireEvent(RS_ONBEFOREOPEN);
if (this._params != null)
{
for (var i=0; i < this._params.length; i++)
{
if (typeof(this._params[i]) != 'undefined')
this._rsADO.ActiveCommand.Parameters(Number(i)).va lue =
this._params[i];
}
}

// force AbsolutePosition to work in server-side cursor for SQL
if (this._rsADO.CursorLocation == 2)
this._rsADO.Properties('IRowsetScroll') = true;

// double-check after ONBEFOREOPEN is fired
if (!this.isOpen())
this._rsADO.Open(); // line 466

this._objDBConn = this._rsADO.ActiveConnection;
this.fields = CreateFields(this._rsADO);
this._bExecuted = true;

if (this._bookmark != 0)
this.setBookmark(this._bookmark);
else
this._syncBOFandEOF();

// fire initial events
this._objEventManager.fireEvent(RS_ONROWENTER);
this._objEventManager.fireEvent(RS_ONDATASETCHANGE D);
this._objEventManager.fireEvent(RS_ONDATASETCOMPLE TE);
return true;
}
}
return false;
}

Jul 19 '05 #1
  • viewed: 5387
Share:
2 Replies
> Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'itemSecUsers'.
/eOrders/_ScriptLibrary/Recordset.ASP, line 466
Well obviously it has something to do with itemSecUsers, maybe something
that is used for opening something in the recordset (this._rsADO.Open();) ?

As far as i can see no code with itemSecUsers is included, so I would start
looking where it goes wrong with itemSecUsers...

--
Greetings,

Tjoekbezoer
"MyATiX" <myatix_at_hotmail.com> schreef in bericht
news:%2****************@TK2MSFTNGP12.phx.gbl... Can someone please tell me why I keep getting the following error? I think
it is part of the connection but can't pin down the exact error. I would be grateful if someone might have any ideas.


..:: CODE ::..

function _RS_open()
{
if (this._rsADO != null)
{
if (!this.isOpen())
{
this._objEventManager.fireEvent(RS_ONBEFOREOPEN);
if (this._params != null)
{
for (var i=0; i < this._params.length; i++)
{
if (typeof(this._params[i]) != 'undefined')
this._rsADO.ActiveCommand.Parameters(Number(i)).va lue =
this._params[i];
}
}

// force AbsolutePosition to work in server-side cursor for SQL
if (this._rsADO.CursorLocation == 2)
this._rsADO.Properties('IRowsetScroll') = true;

// double-check after ONBEFOREOPEN is fired
if (!this.isOpen())
this._rsADO.Open(); // line 466

this._objDBConn = this._rsADO.ActiveConnection;
this.fields = CreateFields(this._rsADO);
this._bExecuted = true;

if (this._bookmark != 0)
this.setBookmark(this._bookmark);
else
this._syncBOFandEOF();

// fire initial events
this._objEventManager.fireEvent(RS_ONROWENTER);
this._objEventManager.fireEvent(RS_ONDATASETCHANGE D);
this._objEventManager.fireEvent(RS_ONDATASETCOMPLE TE);
return true;
}
}
return false;
}

Jul 19 '05 #2
This looks like client-side code, making this question off-topic for these
asp newsgroups (remember, asp is server-side technology). Moreover, it looks
like you are using a Visual Interdev DTC recordset (ughhh!), making this a
good question to ask on one of the m.p.vi.* newsgroups.

Bob Barrows
PS. You should not be using the deprecated OLEDB Provider for ODBC Drivers.
Use the native OLEDB provider for SQL Server instead.
PPS. My advice is to stay away from VI DTC's - they are horrible: buggy and
damn near impossible to troubleshoot if you have a problem like this

MyATiX wrote:
Can someone please tell me why I keep getting the following error? I
think it is part of the connection but can't pin down the exact
error. I would be grateful if someone might have any ideas.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'itemSecUsers'.
/eOrders/_ScriptLibrary/Recordset.ASP, line 466

..:: CODE ::..

function _RS_open()
{
if (this._rsADO != null)
{
if (!this.isOpen())
{
this._objEventManager.fireEvent(RS_ONBEFOREOPEN);
if (this._params != null)
{
for (var i=0; i < this._params.length; i++)
{
if (typeof(this._params[i]) != 'undefined')
this._rsADO.ActiveCommand.Parameters(Number(i)).va lue =
this._params[i];
}
}

// force AbsolutePosition to work in server-side cursor for SQL
if (this._rsADO.CursorLocation == 2)
this._rsADO.Properties('IRowsetScroll') = true;

// double-check after ONBEFOREOPEN is fired
if (!this.isOpen())
this._rsADO.Open(); // line 466

this._objDBConn = this._rsADO.ActiveConnection;
this.fields = CreateFields(this._rsADO);
this._bExecuted = true;

if (this._bookmark != 0)
this.setBookmark(this._bookmark);
else
this._syncBOFandEOF();

// fire initial events
this._objEventManager.fireEvent(RS_ONROWENTER);
this._objEventManager.fireEvent(RS_ONDATASETCHANGE D);
this._objEventManager.fireEvent(RS_ONDATASETCOMPLE TE);
return true;
}
}
return false;
}


Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mr.KisS | last post: by
2 posts views Thread by Jerry Nelson | last post: by
4 posts views Thread by Curious | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.