Top "Openrowset" questions

OPENROWSET is a T-SQL function that can be used in Microsoft SQL Server to read remote data from an OLE DB data source.

The metadata could not be determined because every code path results in an error; see previous errors for some of these

I am migrating from SQL Server 2005 to SQL Server 2014 and one of the queries stopped working in SQL Server 2014: select * …

Read More
sql metadata sql-server-2014 openrowset
OPENROWSET fails with "Invalid authorization specification"

I am trying to use OPENROWSET in SQL Server 2008 SP1: SELECT * FROM OPENROWSET( 'SQLOLEDB', 'Data Source=hydrogen;User ID=scratch;…

Read More
sql-server sql-server-2008 openrowset sqloledb
OPENROWSET - how to read everything as text?

I am using the following command to load data into SQL Server: INSERT INTO [NewTable] SELECT * FROM OPENROWSET ( 'MSDASQL', 'Driver={…

Read More
sql sql-server sql-server-2008 openrowset
Accessing Oracle DB through SQL Server using OPENROWSET

I'm trying to access a large Oracle database through SQL Server using OPENROWSET in client-side Javascript, and not having much …

Read More
javascript sql-server oracle openrowset
How to use OpenRowSet to insert data into a blank file?

How to use OpenRowSet to insert data into a blank file? I need to insert into a txt file (say …

Read More
sql sql-server sql-server-2005 openrowset
Error while running node-mssql query

I am trying to run node-mssql query, if I run simple quires it is getting executed. But when I use …

Read More
sql-server node.js excel openrowset node-mssql