Questions tagged [oledb]

COM based database access API bundled into Windows by Microsoft.

1
vote
0answers
27 views

After reboot SSIS cannot connect to MS Access dbs

We rebooted our sql server 2016 machine. SSIS jobs that have been running fine are now unable to connect to access dbs. it throws the error: "XXXXX:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE ...
0
votes
0answers
16 views

Linked Server Provider

Attempting to set up a linked server to a Oracle 11g database via MSSQL 2016. Unfortunately I don't seem to have any data providers to choose from in SSMS. Initially thought it was an issue with ...
0
votes
0answers
23 views

Is this an OLEDB Connection String from an SSIS package and how can I tell what generated it?

Inside of an SSIS package (.DTSX) I found a connection string similar to this: Data Source=<some-datasource-name> Initial Catalog=<table-name> Provider=SQLNCLI10.1 Integrated Security=...
0
votes
0answers
24 views

SQL Server Integration System (SSIS): looking for a way to iterate a list of Oracle databases

I am developing a package in Visual Studio in order to bring some info coming from different Oracle databases in a unique SQL Server database. Each Oracle database is a clone of the other one, the ...
1
vote
1answer
186 views

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 ...
0
votes
0answers
70 views

RING_BUFFER_CONNECTIVITY - LoginTimers - Error 17830 logs when releasing unused database connection in MS SQL

Good day, can anyone please help me with my problem? I have this program that uses QLOLEDB (also tried using the MSOLEDBSQL) to connect to local sql server express 2014 (ver 12.0.2). The program ...
0
votes
1answer
30 views

unable to add data to table because related record is required

I have an access database with my work that I am trying to insert into but I keep getting. 'You cannot add or change a record because a related record is required in table 'Projects'.' I'm running ...
2
votes
1answer
4k views

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 ...
1
vote
1answer
428 views

Oracle CTE to SQL Server Using SSIS OLE DB Source

I wrote a cte against an Oracle database and the query executes without issue when working in Oracle SQL Developer. I need to use ssis to transport the results of that query to a SQL Server database. ...
0
votes
1answer
198 views

How to execute OPENROWSET from SSRS

Trying to create a Dataset in SSRS that executes a stored procedure that imports data from an Excel file. The sproc transforms the imported data and outputs the reformatted data for the SSRS report. (...
0
votes
1answer
418 views

Oracle driver and language specific chars

I am developing an Excel / VBA - Application that connects to an Oracle database (v 11.2.0.4) instance. I need to query a customers table and search by name. Customers names will contain german umlaut ...
3
votes
0answers
2k views

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 ...
0
votes
1answer
662 views

OleDBConnection.Close() very slow on server

I am working on a few applications which connect to an MS Access database backend (.mdb) to read/insert/update records. Everything is working fine, but I noticed that my db operations were quite ...
2
votes
0answers
991 views

Usage of ApplicationIntent Parameter in SSIS connections

I ran into a puzzling configuration anomaly with a SSIS package establishing a OLEDB connection to a SQL Server 2012 availability group. The DBAs administering the AG requested that all developers ...
0
votes
0answers
79 views

Use of remote indexes in distributed queries

I have a MySQL server linked in SQL Server and I can query it like this: select * from [MYSQL]...[table] where [column] = 1 this works, but if the table contains many rows performance drops, even if ...
2
votes
2answers
1k views

Never Ending OLEDB Wait for Linked Server

We created a linked server to connect SQL Server to our ERP (running UniVerse not SQL Server). It has worked fine in the past, but now any queries to the linked server just get stuck (for days) with ...
0
votes
2answers
924 views

Passing a list to a SQL query in SSIS

I need to be able to pass a list of undefined size that will contain numbers like so ('1900'),('1920'),... to and OLE DB source in SSIS. as of right now I am trying a lot of different things that ...
0
votes
1answer
76 views

When were OLEDB based linked servers added to SQL Server?

I guess what I'm asking is in which version of SQL Server were linked servers added to SQL Server?
0
votes
0answers
3k views

OraOLEDB.Oracle not showing up in Providers in Linked Server

Im trying to link the Oracle database to our SQL Server database. However OraOLEDB.Oracle is not in the Providers list on the Linked Servers. I have installed Oracle Database Client (12.1.0.2.0) for ...
0
votes
1answer
496 views

SSIS slow performance to insert short rows

(Edit: I changed the post after some more explicative tests) I'm experiencing a lack of performance between a SSIS server (name: Server1) and MSSQL server (name: 7551) when my ETL inserts rows of ...
1
vote
2answers
1k views

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

I have the following situation: An Access 2010 database (.accdb) on a shared folder of a remote server. A domain account that can access the shared folder and files. A SQL Server 2014 x64 running on ...
2
votes
2answers
817 views

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

Which features do you need to install in your SQL Server 2008 R2 instance to get OLEDB Provider Linked Table Connectivity? Specifically I'm trying to install the VFPOLEDB provider. (And something ...
1
vote
0answers
1k views

SQL Server Linked Server with Microsoft OLE DB Provider for Visual FoxPro?

We were having some issues with our old Microsoft Visual Fox Pro ODBC driver that we shoehorned into Windows 7 and is no longer supported by Microsoft and has not been for quite a long time... So ...
1
vote
0answers
90 views

Bypass stored procedure execution CPU consumption

We are using Microsoft SQL Server Agent Jobs to execute stored procedures on the other database systems (like MySQL or Oracle). Usually we run procedures via linked servers (over OLEDB and ODBC ...
4
votes
2answers
713 views

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 ...
3
votes
1answer
1k views

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 ...
0
votes
1answer
6k views

trigger - Sql2008 - Msg 7391 - “no transaction is active/unable to begin trans”

I have a trigger on my SqlServer, located in server7. It inserts a data on another server ( server5 ), after insert, as you see the code below: CREATETRIGGER [dbo].[trgSPTInsereDepartamento] ON [...
0
votes
1answer
1k views

How to prevent or notice automatic connection retry in SQL Server and OLE DB

I have a c++ application that connects to SQL Server 2005 using OLE DB / Native client. If the connection gets broken or for example the session is killed from the database something causes the ...
0
votes
1answer
1k views

SQL Server CE 4.0 network share access

In our application we are planning to use SQL Server CE 4.0 using OLE DB. The connection string is shown below. Dim strConn As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=\\pc137\...
1
vote
1answer
79 views

OLE DB provider for ADO.NET data source

I have an application which can connect to OLE DB data sources. But me proprietary database has only ADO.NET provider. Is there any ADO.NET to OLE DB bridge which helps me to connect to ADO.NET data ...
0
votes
0answers
728 views

Query on a SQL Server view with openquery to Hive returning wrong answer

I have a view in a SQL Server instance which is running an OPENQUERY to Hive through MS OLE DB Provider. The view is getting all the records from the Hive table without any WHERE clause. Now, I ...
2
votes
2answers
2k views

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 ...
0
votes
1answer
1k views

Cannot connect with OLE DB

OLE DB connection... Can anyone suggest me on this. Authentication with windows security works in 2012-2005 "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False; ...
3
votes
1answer
10k views

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: ...
2
votes
1answer
4k views

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 ...
1
vote
0answers
387 views

Link up an ms access database to SQL Server 2008 R2?

I've installed the OLE DB Provider for JET by downloading this and installing it. I closed and reopened Microsoft SQL Studio, and connected to my SQL Server Instance. In <instance-name> ->...
2
votes
1answer
908 views

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 ...
2
votes
1answer
726 views

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 ...
0
votes
1answer
969 views

Get all the database in db2 through web

I would like to get all the databases available on a db2 instance from a C# application. The CLP command to be used is LIST DB DIRECTORY. How can I fire this command from C#? Is there another select ...
6
votes
4answers
68k views

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 ...
0
votes
0answers
916 views

Getting UserInfo data out of Sharepoint via OPENROWSET

The query below returns most of the data from the SharePoint list that my customers want: SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 'WSS;IMEX=1;RetrieveIds=...
1
vote
1answer
1k views

Connect to SQL Server using OLEDB or ODBC?

We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
1
vote
2answers
10k views

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=" & ...
2
votes
1answer
1k views

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 ...
2
votes
1answer
3k views

SSIS PL/SQL task hangs with message “Multiple-step OLE DB operation generated errors.”

I've configured a Microsoft SQL Server 2008 R2 SSIS package with an Execute SQL Task to run a PL/SQL query on an Oracle 10.2 database. The Execute SQL Task (named "SQL Update MY_STATUS flag") is ...
3
votes
1answer
573 views

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....