You can connect to most any database with adhoc views or a linked
server. You'll need the odbc drivers installed but once you have those
use openrowset or openquery to create views into the database.
Simple Examples:
CREATE VIEW [view name here]
SELECT Rowset_1.* FROM OPENROWSET('MSDASQL', '{servernamehere}'; '{logon
account}'; '{password}', '[sql command here]') as Rowset_1
Or Create a linked server and:
CREATE VIEW [view name here]
--SELECT Rowset_1.* FROM OPENquery([linked server name], '[sql command
here]') as Rowset_1
Steven R. Christensen
DBA, AMSOIL INC.
[EMAIL PROTECTED]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
