SQL Server Problem

[Tim M]

Hi

Using ADO, when I run the 'sp_columns' strored procedure
for a particular table in my database it returns all
information correctly. However, when I try to run a
query on the same table (or any table for that matter) I
get an error saying the table doesn't exist in the
database.

Does anyone know what is wrong?

Thanks,
Tim

[Bob Barrows]

Tim M wrote:

> Hi
>
> Using ADO, when I run the 'sp_columns' strored procedure
> for a particular table in my database it returns all
> information correctly. However, when I try to run a
> query on the same table (or any table for that matter) I
> get an error saying the table doesn't exist in the
> database.
>
> Does anyone know what is wrong?
>
> Thanks,
> Tim

It sounds like a permisions problem. Verify that the login you are using to
connect to SQL has permissions to the database and the tables. See SQL Books
Online (in your SQL Server start menu program group) for details.

Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"