Table not found error for web app?

Posted on 2006-05-18
Medium Priority
Last Modified: 2012-06-27

I am trying to move from access tables to sql server.
I have my sql server database and table in place, but the web app is giving me this error:

ODBC Error Code = S0002 (Base table not found)

I have double checked that everything is there, and it is.
I can go into the SQL server enterprise manager and see the table and it works there fine.

I think something needs to be done for permissions for web access to the table.
Is this a true statement?

What are the steps to giving my db table web access?
Question by:g118481
LVL 20

Expert Comment

ID: 16709924
Check who owns the table. If it is not dbo, then you might have to use
the fully qualified table name
LVL 75

Accepted Solution

Aneesh Retnakaran earned 500 total points
ID: 16710371
Hi g118481,

Run this Query to fing the owner of the table

select Table_Schema owner , Table_name
from information_schema.tables

Aneesh R!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question