Tables on SQL server not showing

[cfortin14]

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?

[Newsgroup_User]

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?
>

[cfortin14]

Thank you Lionstone, I'll try that.