Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [oledb]

COM based database access API bundled into Windows by Microsoft.

Short for Object Linking and Embedding Database), OLEDB is a COM based database access API that Microsoft bundles with the Windows operating system. It can read relational and non-relational data sources, and can wrap ODBC sources with an ODBC provider. OLEDB is not used outside of the Windows platform as it is dependendent on the COM framework.

Traditional (pre-.Net) ADO typically fronts an OLEDB driver, and Microsoft provides .Net wrappers for OLEDB drivers as well as native .Net providers for many sources. Other database API standards include ODBC and JDBC.

An OLEDB driver for a particular data source is known as a 'provider.' Microsoft bundle providers for several data sources with Windows. Some vendors (e.g. Oracle) also provide their own OLEDB drivers. A list of third parties that produce OLEDB drivers for various platforms can be found here.

56 questions
6
votes
4 answers

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server

This is going to be a long story I'm afraid ;-( I have to read some text-files into a SQL database. This database is on a SQL 2008 R2 x64 database server. I want to use a linked server so after some research I found that I had to install the…
Stephan
  • 161
  • 1
  • 1
  • 3
4
votes
2 answers

SSIS OLEDB Command not firing triggers

Got a bit of a strange one that I can't seem to work out. We have a vendor database ( so we have no control over the table structure, foreign keys, etc...) that's on SQL Server 2012 SP2. We have a large amount of data that's getting loaded daily via…
philcart
  • 51
  • 5
3
votes
1 answer

What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Q 1: Whenever an Oracle SP wants to return error code/message, it fails returning below exeption: OLE DB provider "OraOLEDB.Oracle" for linked server "ORASRV" returned message "ORA-06502: PL/SQL: numeric or value error: character string buffer too…
ajeh
  • 911
  • 5
  • 14
  • 31
3
votes
1 answer

Can I use a linked server that uses Windows Authentication when I'm logged in with SQL Authentication?

I'm using SQL Server 2016 (SP1) Standard Edition. I have a linked server that uses Windows Authentication and needs to because it connects to a non-SQL Server database. It uses an OLE database provider. I have a third-party application that needs to…
sqltracy
  • 31
  • 3
3
votes
1 answer

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…
tnk479
  • 143
  • 2
  • 5
3
votes
1 answer

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

This has been going on. At first MS said they will not support TLS1.2 for OLEDB then they said, they will. You can read about it here, where they said, the support comes in March 2018 Now it looks like package has arrived. I installed it. Then I ran…
T.S.
  • 216
  • 1
  • 3
  • 11
3
votes
0 answers

Connecting to SQL Server from within an SSIS script task

In SSIS, I have defined a Native OLE DB\SQL Server Native Client 11.0 connection that I've calledMyConnection. Then I've created a data flow task, and within the Data Flow of that task there is: A flat file source (from a CSV) A script component in…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
3
votes
1 answer

Jet OLEDB driver refuses to open a linked table where the original has a lock - any way to force this?

I have a requirement to read reference data from several access databases for an ETL job. The data owners have produced a file with a series of linked tables that consolidates them all into one place. However, if one of the base files is open with…
ConcernedOfTunbridgeWells
  • 17,081
  • 2
  • 59
  • 71
3
votes
1 answer

Cannot access a temporary table?

I am using ADO/Visual C++ to access SQL Server database. I find it is OK to create only one temp table in the database. But if I create two temp tables and open recordset of one table, and access the other table, then I will get the following…
user2347976
  • 319
  • 3
  • 7
2
votes
2 answers

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

There is a killed/rolled back query on this instance that was originally attempting to execute a SELECT on a remote Oracle Server via OLEDB. This query was running for over two days before it finally got cancelled. SPID 69: transaction rollback in…
user4659
2
votes
1 answer

Invalid date format in SSIS

I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and destination. I have around 6 datetime fields in ORACLE out of which two fields give no problem while 4 fields give invalid date format issues. These four fields…
HappieFeet
  • 23
  • 1
  • 6
2
votes
1 answer

SQL Server Linked Server error and Query Problem

I have two servers running SQL Server 2000 and SQL Server 2005. There is a database A,B in SQL Server 2000. Similarly I have the same in A,B in SQL Server 2005. A,B are name of the database. I have a linked server pointing from SQL Server 2005…
SenthilPrabhu
  • 219
  • 1
  • 2
  • 9
2
votes
1 answer

Selecting from an excel spreadsheet into SQL Server table

This question has been asked before but I tried giving full admin rights to the SQL Server user on C:\temp\ folder location (I am using Windows authentication into SQL Server Express). So for the following code snippet: Declare @strSQL as…
user26746
2
votes
2 answers

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 happening from time to time. There is an old MS…
JannikB
  • 21
  • 2
2
votes
2 answers

Import Excel Table to SQL Server - with date column

I'm trying to import a excel table that has a column with dates. My query works without the column date. I'm using ODBC to import. strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ActiveWorkbook.FullName & ";Extended Properties=""Excel…
Makah
  • 153
  • 1
  • 1
  • 9
1
2 3 4