Invalid object name 'TABLE'

[MyATiX]

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) != 'undefined')
this._rsADO.ActiveCommand.Parameters(Number(i)).value =
this._params;
}
}

// 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_ONDATASETCHANGED);
this._objEventManager.fireEvent(RS_ONDATASETCOMPLETE);
return true;
}
}
return false;
}

 

[Tjoekbezoer van Damme]

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

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) != 'undefined')
this._rsADO.ActiveCommand.Parameters(Number(i)).value =
this._params;
}
}

// 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_ONDATASETCHANGED);
this._objEventManager.fireEvent(RS_ONDATASETCOMPLETE);
return true;
}
}
return false;
}

 

[Bob Barrows]

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