Questions tagged [oledb]
COM based database access API bundled into Windows by Microsoft.
57
questions
0
votes
0
answers
54
views
Unable to select "other data source" when creating linked server
I am unable to select the option for Other data source when creating a linked server in SSMS, because the option is completely grayed out. I have installed Microsoft OLE DB Driver (MSOLEDBSQL) for SQL ...
0
votes
1
answer
642
views
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
I have the task of migrating our databases from a Windows 2012 R2 server with SQL Server 11.0.7507 (2012) to a Windows 2019 server with SQL Server 16.0.1110.1 (2022).
I am having issues with opening ...
- 1
0
votes
0
answers
123
views
Connection Retry via OLE DB VS ADO.NET in SSIS
Problem: We want to achieve Connection resiliency in SSIS Packages(OLE DB vs ADO.NET Connection manager)
Environment Details:
Database: SQL Server 2016
SSIS Connection manager: OLEDB
OLEDB Provider : ...
- 29
2
votes
2
answers
197
views
SQL Server: Trigger with UPDATE statement causes deadlocks
I have added a trigger to perform a change tracking mechanism on a table that has a relatively high load. During testing, we encountered no issues but now as it is in production there are deadlocks ...
- 21
0
votes
0
answers
375
views
How do I determine if SQL OLE DB drivers are being used?
Today Azure Defender notified me that some OLE DB drivers are outdated on our two Azure VM's. However, I wasn't aware these are needed. Our VM's perform the following duties:
VM 1: Windows Server ...
- 850
0
votes
0
answers
31
views
Security Updates for Microsoft SQL Server OLE DB Driver
Actually I have silly question. If I install below update during working hours then is it occurring any interrupt ? Also I have checked release notes. But I couldn't find anything.
Security Updates ...
- 1,088
3
votes
1
answer
6k
views
Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite
I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://...
- 143
1
vote
1
answer
401
views
Open Row insert- SQL
When we run a SSIS package to import data from excel , we get an initial error:
The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered.
If the 64-bit driver is not installed, run the ...
- 119
0
votes
1
answer
418
views
Openquery through Oledb driver for DB2 slows down after a while - reboot only solution?
We have several sql servers that read from a db2 database on an as400 via Openquery to a linked server using the Microsoft oledb driver for db2 v5. One sql instance had a problem where its selects ...
- 83
0
votes
0
answers
947
views
Linked Server Connection Issue to SQL Server AlwaysOn Listener
I have SQL Server 2008R2 Standard Edition. I am making a Linked Server connection to a Listener of an AlwaysOn Availability Group.
However, when I run a query from SSMS I intermittently get this error:...
- 1,394
-1
votes
2
answers
1k
views
Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?
To configure linked server pointing to a SQL server, there are 4 possible options.
Server Type: SQL Server
Server Type: Other data source; Microsoft OLE DB Provider for SQL Server
Server Type: ...
- 3,476
0
votes
2
answers
2k
views
What version of MSOLAP provider am i using?
We've just upgraded a Server from SQL Server 2016 to 2019.
We have linked servers connecting to an OLAP cube.
When I look under providers for MSOLAP the label of the dialog box shows:
Microsoft OLE ...
- 3,233
0
votes
0
answers
155
views
Linked Server Issues SQL Server to Oracle
I am trying to set up a linked server from SQL Server Production to one of our Oracle instances but experiencing this error :
The test connection in ODBC succeeds, but it fails on SQL Server side. I ...
- 83
0
votes
2
answers
1k
views
How to remove linked servers provider?
I installed an Oracle OraOLEDB.Oracle provider. Now I want to remove that provider from the list. How can I do that?
- 1,283
0
votes
0
answers
171
views
Oracle source with SSIS 2008
I am trying to use an Oracle OleDb source in my SSIS package with no luck, every time I try to connect to the server I get the error:
ORA-12154 tns could not resolve the connect identifier ...
- 1