Open RowSet for Adaptive Server

[klewis10367]

Is there a connection string using OpenRowset in Sql 2000 for Sybase Adaptive Server?

 

[bborissov]

Check

http://www.connectionstrings.com/

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[klewis10367]

Thanks for the quick reply. I have seen this site but it doesn't have the OpenRow Set format that will allow me to create a view in SQl and link it to Sybase. I do not even know if it can be done.

Example..this is a sql Open Row Set

SELECT *,'Stromberg' as DBase
FROM OPENROWSET('sqloledb', 'mbhqstr01'; 'klewis'; 'klewis1', 'select top 100 percent * from
Stromberg.dbo.STM_Dept3maint')