( Newbie SQL 7 )Table CUSTOMER not found in sysobjects

[Nozy]

Greeting to all

Having problems with accessing a table in SQL 7.

Trying to connect to a table in SQL 7, consisting of three feilds, very simple. I am tring to access it using Cisco ICM 4.5. Everytime I try to conect I recive an error :-

Table Customer not found in sysobjects.
Unable to get table info for Machine,Customer_DB,Customer

What is sysobjects ??.

Please help

Cheers
Nozy

 

[JohnDTampaBay]

SysObjects is a system table in each database that keeps track of that database's objects.

From BOL: sysobjects
Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object.

I don't know about Cisco ICM, but my guess would be that you aren't connecting to the correct database and, therefore, the Customer table does not exist. I would check the connection settings used to connect to the database and check the default database for the user you are trying to connect as.

Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.