Table fields missing when dragged into SQL Qry Builder
Posted on 2001-08-23
I'm creating a web project on a Win2000 pro workstation connecting to an IIS 5 server connected to SQL server via System DSN. I create my data connection,(OLE DB for SQL) all tests fine. I create my data command, and open SQL Query Builder. When I drag my tables into the upper pane there are no fields in the tables,(except the ALL Catagories field) and there are no relationships between the tables(foreign key etc.) which there certainly are if I view the database diagram on the SQL Server itself. If I open the same project on the same pc with a desktop version of SQL running, the Table's fields and relationships will showup when dragged into the upper pane, allowing me to choose the fields and make my query. I sense there's some issue with connecting to the SQL server, or IIS server, but I can't figure it out. I have dbo rights over the database, I've relaxed security on the IIS server, but I'm a newbie dealing with VI and IIs so I could've missed something. And maybe this is more of a IIS/2000 configuration question?
Thanks for your help.