Putting a OPENROWSET into a query? -- sql server dts

Deke
8/30/2003 2:06:05 PM

Hi,

I have a Foxpro db Linked Server. I'm trying to make views(queiries) with
the OPENROWSET command, it works when I run it from within the view builder,
but it wont let me save it?

SELECT *
FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;
SourceDB=D:\DirectoryName;
SourceType=DBF',
'SELECT parent, pn, qtyper, scrap, prodclass FROM bom ORDER BY parent, pn')
BOM

Error when trying to save view:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server
'DEKE' is unavailable.

Any Ideas?

Thanks
Deke

John Bell
8/30/2003 7:19:21 PM

Hi

There are several things the view builder does not let you do, and at a
guess this is one of them!

Try using Query analyser and the CREATE VIEW statement.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_30hj.asp?frame=true

John

[quoted text, click to view]

sql server dts : Putting a OPENROWSET into a query?