MDQ not creating typte tree from tables

[dennysthemenace]

Hi

I know this is elementary and I have done this before but it is not working with SQL2005. I have a SQL2005 local server running on my PC and I created a user DSN pointing to the server and tested it successfully. I named the database I wanted to use in DFD and used the DSN, but when I am trying to generate type trees, I get the message "Tables doesnot exist in this database." I have 10 tables in this DB and I am not sure why I am getting this message. Any help is appreciated. Thanks.

 

[janhes]

Sounds like a permissions problem. Are you connecting with the correct user?

 

[dennysthemenace]

I think that is the problem. User is different from me in the database. Thanks for your help.

 

[dennysthemenace]

I was able to use the table as a different user, but I ran into another problem. I was inserting some data into table and the rows were not inserted sequetially although all rows were inserted. Row 138 was passed as row 104 and subsequent rows were kind of interchanged. I wrote the file to disk and it is working correctly. Is this a bug or should I change some setting somewhere? I am using SQL2005 and passed the data at the card level.

File Database
100 100
101 101
102 102
103 103
104 138
105 139
106 140
107 141
108 104
109 105
110 106
111 107
112 108
113 109
114 110
115 111
116 112
117 113