Invalid Object Name Error

Hi,
I have created a new database with a new table and when I try to access it
via ADO I get the InValid Object Name Error. It exists because I see in
Enterprise manager and I verfied the table name. Any ideas?
ThanksIf a user without dbo rights creates a table, it's owner is that user
instead of dbo. For example mydb.john.mytable. If you select from a table,
but do not specify the owner in the path, then it assumes the owner is 'dbo'
and considers the table mydb.dbo.mytable not to exist. Look closely in EM
and confirm that the 'owner' column says dbo for that table.
"Joe" <joew@.theemail.com> wrote in message
news:e584EROqFHA.564@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have created a new database with a new table and when I try to access it
> via ADO I get the InValid Object Name Error. It exists because I see in
> Enterprise manager and I verfied the table name. Any ideas?
> Thanks
>|||Joe wrote:
> Hi,
> I have created a new database with a new table and when I try to
> access it via ADO I get the InValid Object Name Error. It exists
> because I see in Enterprise manager and I verfied the table name. Any
> ideas?
> Thanks
Are you sure you are in the correct database after you connect using
ADO? You can change/verify the database using the
Connection.DefaultDatabase property after you connect.
Also, is the object owned by dbo? If not, you need to specify the owner
name when accessing the object if you are connected using a user name
other than the owner.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks for the post. The Connection.DefaultDatabase property is the correct
db and in Enterprise Manager shows that dbo is the owner. I am by
this.
Thanks
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OBp4NlOqFHA.364@.TK2MSFTNGP11.phx.gbl...
> Joe wrote:
> Are you sure you are in the correct database after you connect using ADO?
> You can change/verify the database using the Connection.DefaultDatabase
> property after you connect.
> Also, is the object owned by dbo? If not, you need to specify the owner
> name when accessing the object if you are connected using a user name
> other than the owner.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Nevermind I am a dunce, it has been a long day. I was linking into the wrond
db (very similar in names due to testing).
Thanks
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:OBp4NlOqFHA.364@.TK2MSFTNGP11.phx.gbl...
> Joe wrote:
> Are you sure you are in the correct database after you connect using ADO?
> You can change/verify the database using the Connection.DefaultDatabase
> property after you connect.
> Also, is the object owned by dbo? If not, you need to specify the owner
> name when accessing the object if you are connected using a user name
> other than the owner.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com

Invalid Object Name ctsv_####...

DB Gurus,

I have a VB 6 utility that is using ADO to connect to replicated tables and I get the following error when I try to update the recordset:

Invalid Object Name 'ctsv_18C3929C22...'

This code worked great until the team that owns one of our SQL servers decided to turn of Replication. After getting replication back up and running, we set up a push subscription rather than a pull as before.

The util is running against the subscriber's tables...not the source tables.

What the heck have I gotten into here?

What does ctsv mean?

Thanks,
GregGood question, what the heck is it? Also make sure you fully qualify table names with schema owner. Maybe that's what it's barking at...

'Invalid object name'

Dear all,
I've got an issue which to encompass both sql and vb and I can't work out.
I'm trying to retrieve data from an ASP page by ADO 2.6 and appears the
following error:
"
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'GEN_VentDesp'.
/mtotgen/pruebas.asp, line 8
"
Snippet of code:
<%
set cnn=Server.CreateObject("ADODB.Connection")
ConectarBD(cnn)
sql = "SELECT * FROM GEN_VentDesp"
set rs = cnn.Execute(sql)
%>
I haven't idea why happens this. Moreover 'GEN_VentDesp' object exists on
the database (sql2k) and the user for that connection own the fine
permissions so that
I'm stuck..
Does anyone ever user or experienced this kind of error'
Thanks in advance,Could be few things. Check if you are connected to the database that
the objects exist in. Also check who owns the object. If the object
is not owned by the dbo and the object's owner is not the user that you
use in the connection string, then you need to specify the owner's name
as part of the object's name.
Adi|||Also check that the user you are logging in as has access to the object.
Connecting to Query Analyzer using the same login, and running the SQL
manually is the best test. If that works then it should work in your code.
If it does not work, then your SQL Connection, object name, or permissions
are wrong. Basically, get it working in the database to eliminate any
database issues, then put it into your app and is issues arrive you will
know they are the app and not the database.
"Adi" <adico@.clalit.org.il> wrote in message
news:1147338575.972058.140510@.g10g2000cwb.googlegroups.com...
> Could be few things. Check if you are connected to the database that
> the objects exist in. Also check who owns the object. If the object
> is not owned by the dbo and the object's owner is not the user that you
> use in the connection string, then you need to specify the owner's name
> as part of the object's name.
> Adi
>sql