HomeFlySpeed SQL QueryCan't get base tables for a View

Can't get base tables for a View


When try to execute this query in Flyspeed it fails. But, it works in WinSQL

DIALOG_BOX -- Application Error
Exception EODBCNativeException in module FlySpeed SQL Query.exe ar 00621758.
[AnyDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hsmt.


-- Syntax to get base tables for a view
USE SMART_JohnsonCoIA_SMARTRMS
GO
SELECT view_name, Table_Name
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE View_Name = 'mni'
ORDER BY view_name, table_name
GO
Darel | email
February 22 2012, 10:20 AM
Change the Connection method in Connection properties dialog from Native to OLE DB.
Sergey Smagin | email
6 days, 13 hours since original post
This topic is closed