By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,678 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,678 IT Pros & Developers. It's quick & easy.

Invalid object name 'TABLE'

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
> 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

P: n/a
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.