Skip to main content
S
sk8save
Inspiring
July 25, 2008
Question

User/table access issues

  • July 25, 2008
  • 1 reply
  • 353 views
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.
This topic has been closed for replies.

1 reply

S
shorlbeck
Participant
July 25, 2008
Perhaps a name collision resulting from duplicate DSNs, usernames, or application names?
S
sk8saveAuthor
Inspiring
July 25, 2008
I was talking with a DBA friend and I think we figured it out.

I was logged into the database using userX's credential. I ran a simple SQL and it didn't find the table unless I prefixed it using userX.

I looked at the security side of things for userX and the user wasn't mapped to that database in question. I'm assuming that this is the cause. In my case, I can't map the user due to the way I imported the backup (I get an error while trying to map due to the user already being in the database - or something like that).

My goal is to figure out how to import the DB properly without creating the user in the database. Then, I could simply create the login and map it to the database and in theory, I'd be done - I think.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices