Hi,

I have a DB with a lot of table, which came with a software we bought (it is in SQl server 2003).
I added some table and I can have acces to them. But when I do a select to the original tables I get the next errror:
===
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]El nombre de objeto 'pl_mov_general' no es válido.

===

The code is simple. It is:
===
Set conn = server.createobject("adodb.connection")
conn.open "DSN=CCS_BACKUP"
set rs = server.createobject("adodb.recordset")
sql=" SELECT * FROM pl_mov_general"
response.write(Sql)
rs.open sql,conn
===

Should it be something with the level of security on the server? If so, how do I change that?

Many thx,

Johny

Check out this page, it might be able to help you:
http://tutorials.aspfaq.com/8000xxxx...37-errors.html

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Thx Dparsons,

I already read the page, but couldn´t find anything.

But I found it already.
the only thing I had to do is to add "IMP." before the table name.

So :
sql=" SELECT * FROM pl_mov_general"
Becomes:
sql=" SELECT * FROM imp.pl_mov_general"

Now I can´t tell you why. I just found out by luck.

Many thx,

Johny