'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

Intranet Set up with SQL server and ASP

Dear all,

I am trying to make a Intranet connection with SQL 2000 and ASP,
but a serious problem in connection string. Please can you help me in this issue

I am using following connection string.

(windows authontication)

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="PROVIDER=SQLOLEDB;Integrated Security=SSPI;Initial cataloge =nrth;DataSource=server"

System dsn =nrth
server name =server

This string makes following error

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

//global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

/test2.asp, line

can you correct this or suggest a valid connection string

Thank youThe DSN probably only exists on the one server. Try replacing it with
Server=servername.|||Originally posted by Satya
The DSN probably only exists on the one server. Try replacing it with
Server=servername.

still having error,

I am checking it in server itself

interpreting product A-2 >=1.978

Dear Jamie,

Thanks for the reply.

We have another problem to solve.

on the node we are getting product A -2 >=1.978

What does it mean (-2) ?

It is mentioned as two time slices ago. Please help me to undertand this.

From

menik

that is exactly the meaning. For example take the series

1, 3, 5, 6, 4, 2, 3

Say I have a tree that says "If (A-2) > 2 then result = (A-1 * 0.75) else result = (A-1 * 1.25)"

The next prediction in the series would be (3*1.25)=3.75 as (A-2) is 2 (not greater than two) and (A-1) is 3. The following prediction would be (3.75 * 0.75)=2.81 as (A-2) in this case is now 3, and (A-1) is the newly predicted value 3.75

interpreting product A-2 >=1.978

Dear Jamie,

Thanks for the reply.

We have another problem to solve.

on the node we are getting product A -2 >=1.978

What does it mean (-2) ?

It is mentioned as two time slices ago. Please help me to undertand this.

From

menik

that is exactly the meaning. For example take the series

1, 3, 5, 6, 4, 2, 3

Say I have a tree that says "If (A-2) > 2 then result = (A-1 * 0.75) else result = (A-1 * 1.25)"

The next prediction in the series would be (3*1.25)=3.75 as (A-2) is 2 (not greater than two) and (A-1) is 3. The following prediction would be (3.75 * 0.75)=2.81 as (A-2) in this case is now 3, and (A-1) is the newly predicted value 3.75