OPENDATASOURCE QUERY | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

OPENDATASOURCE QUERY

Hi Friends,<br /><br />I need help of OPENDATASOURCE Query for access the MS-Access & Oracle9i database to show the data. I don’t like to make the linked server for this activity. I know this can be done by OPENDATASOURCE QUERY.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]Please provide to me solution for this result.<br /><br /><br /><br /><br />Amit Kumar<br />Mob.: 9873812005
Refer to the Books online andhttp://www.databasejournal.com/features/mssql/article.php/1756161 orhttp://www.sommarskog.se/dynamic_sql.html#OPENQUERY for an example with OPENQUERY that you can use as starter. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
The format is like this (this example uses the northwind database<br /><br />SELECT *<br />FROM OPENDATASOURCE(<br /> ‘SQLOLEDB’,<br /> ‘Data Source=ServerName;User ID=MyUID<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=MyPass'<br /> ).Northwind.dbo.Categories<br /><br />for the parameters for Oracle and Access, look in books online for<br /><br />OLE DB Providers Tested with SQL Server<br /><br /><br /<a target="_blank" href=http://www.tradeco.co.uk>http://www.tradeco.co.uk</a>
]]>