5 votes

Never Ending OLEDB Wait for Linked Server

For SQL Server targets: On the target server (the one that's receiving the linked server query), run sp_WhoIsActive and look at the linked server query. If the query doesn't show up, something's ...
Brent Ozar's user avatar
4 votes
Accepted

Where is MSOLEDBSQL provider driver? "The 'MSOLEDBSQL' provider is not registered on the local machine."

The new OLE DB driver, MSOLEDBSQL, was released today. This new driver includes the support for the latest TLS 1.2 standards and is backwards compatible with SQL Server Native Client 11 (SQLNCLI11). ...
Dan Guzman's user avatar
  • 28.2k
3 votes

Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite

I had to install the x86 version of C++ Redistributable, not only the x64 that I installed at first. After x64 and x86 install I was able to install msoledbsql
IWillFold's user avatar
3 votes

What Microsoft SQL Server 2008 R2 features do you need to install to get OLEDB Provider Linked Table Connectivity?

You can download the no-longer current VFPOLEDB provider. See: https://www.microsoft.com/en-us/download/details.aspx?id=14839 or http://download.cnet.com/Microsoft-OLE-DB-Provider-for-Visual-...
RLF's user avatar
  • 14k
3 votes
Accepted

What Microsoft SQL Server 2008 R2 features do you need to install to get OLEDB Provider Linked Table Connectivity?

The link below has the download you need: Microsoft OLE DB Provider for Visual FoxPro 9.0 The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access ...
Mike Lawell's user avatar
3 votes

SSIS OLEDB Command not firing triggers

I was not able to reproduce your error (although I only tested with one table in the mix). An OLE DB Destination has the ability to disable trigger and other check constraints when it loads but the ...
billinkc's user avatar
  • 15.9k
3 votes

SQL Native Client 11 - SQL Server 2017

Microsoft has deprecated the SQL Server Native Client (NCLI) driver, however SQL Server itself uses a wire-protocol, TDS that is independent of the driver used by the client. NCLI will continue to ...
Hannah Vernon's user avatar
  • 70.1k
2 votes

How to connect to a password protected Access 2010 database from SQL Server 2014 x64

I solved this problem with the following SQL script. My Access is 2013 MS Access 64-bit and SQl Server is 2014. Create linked server with access no password access EXEC master.dbo.sp_addlinkedserver ...
Mg Kyaing's user avatar
2 votes
Accepted

Usage of ApplicationIntent Parameter in SSIS connections

This is by design Depending on the SNAC protocol you are using there is a slight variation in the application intent connection string property. When using SQL Native Access Client SQL OLE DB, the ...
tamf's user avatar
  • 36
1 vote

SQL Server: Trigger with UPDATE statement causes deadlocks

Your trigger has a fatal flaw: it only deals with a single insert. You need to rewrite it to join by the PK of inserted and deleted. To avoid the deadlock, add both UPDLOCK and HOLDLOCK hints to the ...
Charlieface's user avatar
1 vote
Accepted

Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?

I don't think there's much specific variance on why to use one over the other, as far as SQL Server is concerned, rather they're just multiple options to accomplish the same thing. Likely it just ...
J.D.'s user avatar
  • 37.5k
1 vote

What version of MSOLAP provider am i using?

You can use SysInternals Process Explorer to find which DLL is in use. Find > Handle or DLL. Type MSOLAP in the search field then connect to your DB and hit search in Process Explorer. The result ...
sward's user avatar
  • 11
1 vote
Accepted

How to remove linked servers provider?

To remove the linked server provider, uninstall the OleDb Provider. For Oracle XCopy use the uninstall.bat in the installation folder, eg PS C:\odacinstall> .\uninstall.bat oledb c:\oracle\odac64
David Browne - Microsoft's user avatar
1 vote

Upgrading from SQLOLEDB to MSOLEDBSQL

I am presuming that refers to the existing SQLOLEDB That is not the case. The installer is not trying to upgrade SQLOLEDB. The old driver is part of Windows and won’t be affected by the ...
David Browne - Microsoft's user avatar
1 vote

SQL Native Client 11 - SQL Server 2017

I just installed the ODBC client for SQL 2017 for a python process yesterday. It seems to be working just fine. MS has stated the ODBC driver would be deprecated for at least 7 years now. I'm not ...
mv  ٠〳comment  ٠〳answer's user avatar
1 vote

Connection Issues with Informix OLEDB Provider

You need to run setnet32 "As Administrator", or the driver will not be visible. I had the same problem initializing the provider because of that, after running as admin everything works.
Adriano's user avatar
  • 11
1 vote
Accepted

Connection Issues with Informix OLEDB Provider

So, after giving up searching for answers, I started trying every imaginable combination of properties with different registries set and not set and I managed to get it working. The Connection String ...
kastner_bsa's user avatar
1 vote
Accepted

How to connect to a password protected Access 2010 database from SQL Server 2014 x64

It looks like that at the time I'm writing this there is no way to pass Windows security credentials when using a SQL Server user. The SQL Server user will always use the credentials of the Windows ...
Valerio Santinelli's user avatar
1 vote

Oracle CTE to SQL Server Using SSIS OLE DB Source

I had the same problem, which I managed to resolve by updating the Oracle driver. My environment: SSDT 11.1.20627.00 running on Visual Studio 2012 Update 4 Oracle OLEDB driver 11.2.0.1 - this ...
Serge's user avatar
  • 542
1 vote

Oracle driver and language specific chars

Indeed, the OLEDB provider from Mircrosoft is deprecated for ages and you should not use it anymore. Certainly it can have problems when you work with Unicode. Use the OLEDB Provider from Oracle. ...
Wernfried Domscheit's user avatar
1 vote

OleDBConnection.Close() very slow on server

In my experience, One of the access database exceeded 20000 records and the size was around 150 MB. It started to slow down and performance plummeted. So moved to SQL. You may consider using SQL ...
Tanmay Nehete's user avatar
1 vote

Passing a list to a SQL query in SSIS

Have you tried using dynamic sql? Something like this: declare @fieldLogID nvarchar(256) = ? declare @accountTypes int = ? declare @sql nvarchar(1000) = '' SET @sql = 'select fl.[Version] ...
Local_DBA's user avatar
1 vote

When were OLEDB based linked servers added to SQL Server?

I believe this was introduced in SQL 7. If memory serves me right, I was able to access a SQL 6.5 server from a SQL 7 server, but I could not access SQL 6.5 from/to another SQL 6.5 (I don't think the ...
Jason B.'s user avatar
  • 632
1 vote

SSIS slow performance to insert short rows

There are a lot of things that come into play in regards to the performance difference. 1) is hardware\Instance configuration (RAM, Disk IO speed, Disk Size, Block Size, SQL-server memory ...
Matt's user avatar
  • 111
1 vote

SSIS OLEDB Command not firing triggers

The following will show you if the triggers are enabled. If they are, they will fire, assuming the DML meets the trigger requirements. You should run this while the SSIS package is running. SELECT ...
Hannah Vernon's user avatar
  • 70.1k
1 vote

trigger - SQL Server 2008 - Msg 7391 - "no transaction is active/unable to begin trans"

We're also facing this issue & just resolved :) We tried to link from MsSQL2008R2 (source) to MsSQL2019 (target). Both DB servers (VM) are located in the same domain - the 1st and 2nd ocate of the ...
Denise Ching's user avatar
1 vote

Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?

You are most likely hitting this issue: https://connect.microsoft.com/SQLServer/feedback/details/187192/ If this is indeed the case, the ROLLBACK isn't actually doing anything, it is just hung and ...
Mitack's user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible