Advertisement

12.29.2004 at 08:32AM PST, ID: 21256483
[x]
Attachment Details

Basic question about "Invalid object name" error on table

Asked by TruthHunter in MS SQL Server

Tags: object, name, invalid, error

Hi,

Sorry, I'm a DB newbie and this probably has a simple answer, but given that it's the week after Christmas there's no one  anywhere to be found around here and the MSSQL docs aren't much help so far.

Also, the app I'm using works on other people's systems fine, so I think this is something not configured right on my system-- I just don't know what to check.  I'm using VC++ 6.0 and ADO 1.5...

The connection to the DB and the creation of the recordset instance succeed, but the first "Open()" call (doing just a SELECT) fails with an "Invalid object name" COM error.  The table and column in the query exist, and I made sure the case of both were correct, and the permissions seem to be correct, but I'm not sure.

I'm hoping someone can just give me a specific lead to check.  It's pretty urgent, so I'm assigning the max points.  Thanks!Start Free Trial
[+][-]12.29.2004 at 09:06AM PST, ID: 12920227

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:12AM PST, ID: 12920277

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:37AM PST, ID: 12920455

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:50AM PST, ID: 12920550

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:50AM PST, ID: 12920555

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:56AM PST, ID: 12920580

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 09:57AM PST, ID: 12920590

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 10:13AM PST, ID: 12920721

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 10:14AM PST, ID: 12920731

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 10:23AM PST, ID: 12920814

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 11:34AM PST, ID: 12921403

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 12:04PM PST, ID: 12921619

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 12:26PM PST, ID: 12921747

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.29.2004 at 12:34PM PST, ID: 12921806

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: object, name, invalid, error
Sign Up Now!
Solution Provided By: ScottPletcher
Participating Experts: 3
Solution Grade: A
 
 
[+][-]12.29.2004 at 01:33PM PST, ID: 12922214

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32