all groups > sql server odbc > november 2003 >
You're in the

sql server odbc

group:

Can't see a particular table in a database


Can't see a particular table in a database CQMMAN
11/26/2003 4:22:54 PM
sql server odbc:
Hello,

I am trying to get info from a SQL7 database via ODBC. I can connect and
view the vast majority of tables, but one particular table (ceninfo_data)
does not appear.

In SQL Enterprise manager, I have taken a look at the permissions on the
table and public can select from it.

What am I missing?

Cheers
CQMMAN
"See, free nations are peaceful nations. Free nations don't attack each
other. Free nations don't develop weapons of mass destruction." George W
Bush -Milwaukee, Wis., Oct. 3, 2003

Re: Can't see a particular table in a database CQMMAN
11/26/2003 4:50:30 PM
Doh!

Fixed it. I was replicating a database and had changed the permissions on
the original, but not on the replicated database.

Cheers



[quoted text, click to view]

AddThis Social Bookmark Button