logged in user can't see tables

From: pablo (a@b.com)
Date: 08/31/02 

From: "pablo" <a@b.com>
Date: Sat, 31 Aug 2002 04:34:09 GMT

When I connect to my SQL 2000 database through a DSN in my .asp page using
SQL authentication, I cannot see my tables without first prefixing them with
the owner name. For example, my DSN is set to authenticate with a SQL
id/pass:

DSN=mydsn;UID=owner;pwd=xxx

when I try and select on a table owned by owner

SELECT * FROM employees

fails, and

SELECT * FROM owner.employees

works.

I tried the DSN without the UID and PWD, and the login fails, so I am sure I
am loggin in correctly.

I would like not to have to specifiy the owner prefix. Any ideas?

Relevant Pages

  • Re: Failed Connection to SQL Srvr 2005
    ... Next when DSN, by default, was ... On the server (Server Config ... I have a range of clients, some who have SQL 2000 ... (connections work). ...
    (microsoft.public.sqlserver.connect)
  • Re: crash on virtual dimensions
    ... SQL authentication doesn't work for SQL Server to anywhere. ... It is basically a way for access developers to start writing all of their ...
    (microsoft.public.sqlserver.olap)
  • RE: SQL-Server and Win2k3
    ... If your servername is the same, and ip address is the same then you should ... Check if your DSN creates an alias. ... If you have to recreate your DSN after moving SQL, ... but your instance of sql is NOT listening on this network ...
    (microsoft.public.sqlserver.connect)
  • Re: Failed Connection to SQL Srvr 2005
    ... why are you creating a DSN at all and why are you using ODBC? ... Understand that SQL ... Server has been configured for some time now to be invisible to the network ... (connections work). ...
    (microsoft.public.sqlserver.connect)
  • Balasan: RE: cant execute "use $database"
    ... I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO. ... I create 'myperl' as DSN from ODBC Administration Tools. ... Here is my connection string: ... Generally speaking, when you want to connect to a specific database, it ...
    (perl.dbi.users)