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.

53 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
  • 4
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
  • 4
  • 12
  • 29
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.
  • 177
  • 1
  • 2
  • 9
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,192
  • 10
  • 29
  • 48
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
  • 16,721
  • 2
  • 54
  • 70
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
  • 327
  • 2
  • 6
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…
Craig Efrein
  • 9,418
  • 11
  • 53
  • 94
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
  • 5
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…
Utpal Mattoo
  • 121
  • 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
2
votes
1 answer

Debugging a SSIS OleDbCommand

I have an OleDb Command component in a dataflow that does an update(yes, I'm aware of the performance implications). Running the pack in BIDS shows me that the component is being reached and runs correctly, turns green when complete, etc. However, I…
Jeff Sacksteder
  • 1,279
  • 2
  • 17
  • 27
2
votes
2 answers

SQL Native Client 11 - SQL Server 2017

We currently connect to SQL Server 2014 with the Native Client without any issues. However, the SQL Server is being upgraded to SQL 2017. I have been told that SQL Native Client will no longer work for connecting, and we need to install the OLE DB…
Kevin
  • 493
  • 2
  • 9
  • 17
2
votes
2 answers

Connection Issues with Informix OLEDB Provider

I've been trying to establish a OLEDB Connection to an Informix Dynamic Server. (Version IBM Informix Dynamic Server Version 12.10.FC12WE) Background Info: A program, which will be used by my company, requires OLEDB and doesn't support ODBC. The…
kastner_bsa
  • 31
  • 6
1
2 3 4