Tagged Questions
1
vote
1answer
132 views
Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
I'm trying to establish a linked server from SQL Server 2008 R2 to an Access database. The Access database is not password protected. As I have seen in other posts (specifically this one), this is ...
7
votes
1answer
217 views
selecting more fields causes catastrophic failure
I have a connection to a linked server from sql server 2012 to pervasive sql.
When I do select field1, field2, field3 from mytable everything works!
However, when I do select field1, field2, field3, ...
1
vote
4answers
1k views
Select from linked server to local server causing waits on both sides
The queries in question are here: http://pastie.org/4833351
Run individually, each of these queries runs through (albeit slow).
Run as a group, it just sits there, showing either OLEDB waits on the ...
3
votes
1answer
135 views
Connecting Linked Server
Hi I want to fetch data from MS SQL DB of a Remote server using Linked Servers. I have linked the servers. I am fetching data as follows.
select * from [IP of server].[Database Name].[dbo].[Table ...
1
vote
0answers
110 views
Cannot Check if the Access Database Engine is Installed and Configured
All, I want to check if the Access Database Engine is installed and linked to SQL Server. On my development machine (x64-bit) the following queries both show the Access Engine to be avalible as a ...
