User/table access issues

["sk8save" <webforumsuser@xxxxxxxxxxxxxx>]

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>