'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