Tables on SQL server not showing

Check the DSN to make sure the user it's connecting as has permission to
access the tables owned by usr1234.
Alternatively (and better all around), connect to the database via an OLE DB
connection instead of using a DSN (www.connectionstrings.com) as DSNs are
the slowest form of database connection.


"capitalino" <webforumsuser@macromedia.com> wrote in message
news:e3voal$gvb$1@forums.macromedia.com...
> I?m connecting to an SQL database hosted online; I have created many
> tables
> (the owner is usr1234) and created the DSN in DWMX2004. DW is connecting
> to the
> database but I can see only tables owned by dbo. I can?t see all the other
> tables.
>
> What am I doing wrong?
>