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.

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

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

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