Data Explorer uses the following query to return a list of tables from SQL Server. Does this work in SQL 6.5? (replace 'database' with your database name)
SELECT * FROM database.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
>I recently tried using the "Data Explorer" with MS SQL 6.5. I connect to the server without any problems and the tree structure fills out but I can't see any tables. Is there some setting or configuration that I need to set to be able to get it to work with SQL 6.5.
>
>I haven't had any problems using it with MS SQL2000. When selecting a table using the Data Explorer, I notice that the browse window is READ ONLY and that I cannot make any changes to the data. Is there a simple way to change the viewing browse window to allow updates to the tables?
>
>Thanks,
>Robert
Ryan Katri
COB System Designs, Inc.