Re: User/table access issues

[GArlington <garlington@xxxxxxxxxxxxx>]

On Jul 25, 3:10 am, "sk8save" <webforumsu...@xxxxxxxxxxxxxx> wrote:
> First, here's what my DB looks like (MSDE 2000):
>
>  userX.TableA
>  userX.TableB
>  ...
>
>  The DSN in CFAdmin is functional, it validates. I have provided the username
> and password for userX specified earlier in my DB setup for the DSN. It
> indicates "OK".
>
>  Here's my error when I run the page:
>  [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TableA'.
>
>  I have specified the username and password in the cfquery tag as well. I'll 
> be
> uploading this code on a production server. The code as it is works on
> production - it's shared hosting so I don't know how they're setup.
>
>  Not sure if someone can provide any clues to why this isn't working at my end
> on my development environment.
>
>  <cfquery name="qryA" datasource=#request.dsn# username="#request.dbuser#"
> password="#request.dbpwd#">
>  35 :                   select * from TableA
>  36 :           </cfquery>

Depending on DB setup (i.e. how the schemas and access is setup) you
might have to use full notation (i.e. userX.TableA)